After developing conceptual data models for MVCH’s new system and reviewing them with yo...

After developing conceptual data models for MVCH’s new system and reviewing them with your team and key stakeholders at the hospital, you are ready to move on to the logical design for the relational database. Your next deliverable is the relational schema. You may also have to modify the EER model you created in Chapter 3.

for the relational database. Your next deliverable is the relational schema. You may also have to modify the EER model you created in Chapter 3.

Map the EER diagram you developed in Chapter 3 to a relational schema, using the techniques described in this chapter. Be sure to underline all primary keys, include all necessary foreign keys, and clearly indicate referential integrity constraints.