Due: Mo, Mar 9

Course Project

Form a team of 2–3 students as soon as possible. Each group should design a database for the case study The Mountain View Community Hospital. Use the following approach.

1. (25%) Offer an ER diagram representing the described database

2. (15%) Map the ER diagram to a relational data schema

3. (10%) List the functional dependencies for each of the relations

4. (10%) Convert the relations into 3NF. Are the relations in BCNF? Justify your answer.

5. (15%) Define a physical design for the normalized relational data schema. The physical design should consist of SQL table definition statements for the different relations, specifying also key and referential constraints.

(25%) Provide a documentation describing and justifying the design, implementation, and testing of the database.

Notes:

• You are not required to implement the database.
• The project can be provided in hard copy or electronic form. For electronic submissions use the command: submit XXX project filename. XXX represents ‘c670aa’ for students of the 3:30 section, and ‘c670ab’ for students of the 5:30 section.
  • Files are restricted to 1,048,576 bytes
  • The submit program issues error messages to the student’s CSE email account

• The case study is from Fred R. McFadden, Jeffrey A. Hoffer, and Ananth Srinivasan, Case Book for Data Base Managment, Benjamin Cumings, 1985.

Q&A