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.
(25%) Offer an ER diagram representing the described database
(15%) Map the ER diagram to a relational data schema
(10%) List the functional dependencies for each of the relations
(10%) Convert the relations into 3NF. Are the relations in BCNF? Justify your answer.
(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: submitXXX 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 BaseManagment, Benjamin Cumings, 1985.