Mapping from ER to Relational Model
Questions 3-4:
[10 x 2 Marks]
Convert the ERDs in questions 1-2 to logical relational schema. Draw the schema using the approach used
in Figure 5.7 in the book i.e., relations, attributes, keys, foreign keys must be properly indicated. Also,
describe in the text form if there are any other constraints. Upload these schemas to your submission on
Crowdmark.