Description
Question #1 (13 marks):
The following Figure 1 shows an EER schema for a database that can be used to passenger tickets for
cruise ship itineraries. Map this schema into a relational data model, including all primary keys and
referential integrity constraints (foreign keys). The diagram is also posted on D2L separately for better
visibility.
For the given specialization, consider the four Step 8 options presented in the lecture notes for mapping
specializations/generalizations. Show the relational schema design under each of those four options (8A,
8B, 8C, 8D). You only need to show the rest of the model and the referential integrity once.
Figure 1: An EER schema for a cruise ship passenger database.
Question #3 (12 marks):
The following Figure 2 shows a relational schema for a library loan database. Reverse engineer the
schema to create a conceptual ER model. State any assumptions that you make. You do not need to
include participation or cardinality constraints.
