Database Programming :: Projects :: Web App
Interview Transcript Due: Sep 18
Web App Homepage Due: Oct 4
ER Diagram Due: Oct 15
Attribute List Due: Oct 22
SQL Queries Due: Nov 9
Final Web App Due: Dec 14
You will be working on a web app that will be used by the Yorkville High School community. Mr. Miller will assign your project. All of the items listed below should be turned in to one folder on Google Drive, other than the web app itself which will exist on the web.
You need to interview your client(s) to determine what they need for their web app. You may want to record the interview so you can create a more accurate transcript and pay better attention during the interview itself. The interview transcript should be typed and turned in to Google Drive.
The homepage will be the first page people see for your web app. It may be a simple log in screen, but create something that looks good even though it won't be functioning until the end of the project.
Turn in an ER diagram to Google Drive with all entities and relationships as well as cardinalities. Do not list attributes on the ER diagram.
Turn in an attribute list to Google Drive with all primary and foreign keys indicated.
Normalize the tables from your attribute list. Create your tables in phpMyAdmin and export the SQL data. Turn in the exported data to Google Drive.
The final web app is due at the end of the semester and should meet all the requirements set forth by your client(s).