For the first project you will demonstrate your mastery of SQL and practice database design by creating a website that allows users to enter and analyze data.
The website can be related to anything you want, but it must meet the following requirements.
- Have a database with a complex structure.
- Allow the user to perform an interesting analysis of the data in the database.
- Allow the user to modify the database by entering new information and to modify existing information by deleting and/or editing.
This assignment requires web programming. If you have no experience with web programming you may collaborate with someone who does. If you do, both partners must work on the same computer and actively contribute to every line of code. Only one partner needs to submit code, but both partners names should be in the code.
Your project will be evaluated according to the following requirements:
a. The database should have multiple tables. b. The database should have at least one to-one relationship. c. The database should have at least one to-many relationship.
a. The database should use constraints to maintain integrity. b. The database should use appropriate data types. c. The database should reduce redundancy and promote efficiency.
a. The analysis should provide non-obvious insights about the data. b. The analysis should be customizable by the user.
Modify the data
a. The database should be initialized with a large set of data. b. The user should be able to add new data. c. The user should be able to modify existing data.
a. The user interface should be intuitive and easy to use.
This project has several submission deadlines:
- Submit a proposal for a project as a text document on the course Inquire page before class on Tuesday, March 13th. Be prepared to present your proposal during class before forming teams.
- Submit a design document, including a database schema, user interface illustration, requirements list, and timeline, to the course Inquire page before class on Tuesday, March 20th.
- Submit a zip file containing your project’s source code and a URL to an operational version to the course Inquire page before class on Tuesday, April 3rd. Be prepared to present your project during class.