Due date: Saturday Dec. 31.
Submit an electronic copy by email if possible,
instead of a hard copy.
Part 1: Database Design (30%)
· Summarize your database application domain. Your description should be clear but concise for a first-time reader to understand the essence of the application domain.
· Include an E/R diagram for your application domain. Don’t forget to underline key attributes and include arrows and numbers indicating the multiplicity of relationships.
· Display the structures (names and types of the columns, primary keys, and foreign keys) of the tables you create for the database application.
· Explain whether your tables are all in BCNF relation schemas.
Part 2: SQL (30%)
· For each table, list at least 5 sample records you have created for the table.
· List 12 interesting SQL queries over multiple tables of your database, and for each query
o explain the purpose (i.e. what kind of information is intended to be retrieved by the query)and
o display the result you got from running the query over your sample records in the tables.
Part 3: Web-Interface (30%)
· List the URL(s) of the main web page(s) of your interactive web application.
· Describe what your web application can allow the user to accomplish across the Internet. At least you should allow the user to see the contents of your individual tables. In addition, you should implement web interfaces for the user to try 5 or more of the 12 queries you have in Part 2.
· List the contents of the script files and web pages.
Part 4: Evaluation of your effort (10%)
· For each individual of your team, estimate the amount of time the individual has spent in the three parts above throughout the semester.
· List (i) things in progress but not yet accomplished and (ii) the technical problems you have encountered in the process of the project.