Consider the Musician database ER diagram as shown in Figure 1.
5.1) (10 marks) Give the FDs for the constraints in the ER diagram. You should not include trivial or redundant FDs.
5.2) (10 marks) Map the ER diagram to a relational database schema following the ER-to-relational-database-schema mapping rules. Indicate the primary key (underline) and any foreign keys (asterisk) in each relation.
Fig. 1 The Musician database ER diagram
Recently Asked Questions
- The figure shown below shows a cross section of a long cooling fin of width W, thickness t, and thermal conductivity k, that is bonded to a hot wall,
- Keeping in mind today's method of raising food with its vast array of technology incorporated into the process; e.g., chemical fertilizer, insecticides,
- Which of the following is NOT a factor suggested in Leslie Sheldon’s article, Evaluating ELT textbooks and materials (OUP 1988)? Educational validity