Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts International Edition

Authors: David M. Kroenke

6th Edition International Edition

0133098222, 978-0133098228

More Books

Students also viewed these Databases questions

Question

Explain union decertification.

Answered: 1 week ago

Question

7. It is advisable to do favors for people whenever possible.

Answered: 1 week ago