Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are hired to design a database for a company called Newtown Records. After a meeting with company management we have gathered following information. For
You are hired to design a database for a company called Newtown Records. After a meeting with company management we have gathered following information. For each musician we would like to store SSN, a name, an address, and a phone number Poorly paid musicians must live in a house but often share the same address, and no address has more than one phone. However, some musician live at more than one place Each instrument used in songs recorded at Newtown has a unique identification number, a name (e.g., guitar, synthesizer, flute) and a musical key (e.g., C, B-flat, E-flat). Musician may play several instruments, and at the same time an instrument may be played by several musicians. An instrument must be played by a musician and all musicians play at least one nstrument. Each album recorded on the Newtown label has a unique identification number, a title, a copyright date, a format (e.g., CD or MC). An album has a number of songs on it, and a song may appear on more than one album. It is not possible to have an album without a song and song must also be associated with an album. Each song recorded at Newtown has a title and an author. A song must be performed by one musician and a musician must perform a number of songs Each album has exactly one musician who acts as its producer. A musician must produce only one album. Design an ER diagram for this application using CHEN's notation, no other notation is acceptable and will not be graded. Write any unspecified requirements and any assumptions that you need to make the specification complete. In your ER diagram also identify all structural constraints
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started