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
- You are currently managing an options portfolio with delta, cash gamma, vega, and theta of -19.8, $-243,000, $-26,000 and $2,425 respectively, quantify and
- Complete the Health Insurance Matrix found under the student materials section of this assignment. You must use the Health Insurance Matrix provided to
- According to the Centers for Medicare and Medicaid (CMS), U.S. health care spending grew 4.3 percent in 2016, reaching $3.3 trillion or $10,348 per person.