Plan an er diagram, Plan an ER diagram

Plan an er diagram

Assignment Help Computer Engineering

Reference no: EM132937

Question

Newtown Records has determined to store information about musicians who perform on its albums in a database. The company has wisely chosen to hire you as a database designer (at your usual consulting fee of $2500/day).

1. Each musician that records at Newtown has an SSN, a name, an address, and a phone number. Badly paid musicians often share the same address, and no address has more than one phone.

2. Each instrument used in songs recorded at Newtown has a unique identification number, a name as in guitar, synthesizer, flute and a musical key (e.g., C, B-flat, E-flat).

3. Each album recorded on Newtown label has a unique identification number, a title, a copyright date, a format such as CD or MC and an album identifier.

4. Each song recorded at Newtown has a title and an author.

5. Each musician might play several instruments, and a given instrument may be played by several musicians.

6. Each album has a number of songs on it, but no song may appear on more than one album.

7. Each song is performed by one or more musicians, and a musician could perform a number of songs.

8. Each album has approximately one musician who acts as its producer. A musician can produce several albums, of course.

The preceding information describes situation that the Newtown database must model. Plan an ER diagram for this application. Be sure to indicate all key attribute and cardinality and participation constraints and any assumptions you make.

The ER diagram is already designed in the attached file. Redraw diagram using your own way you be able to make it colorful id you want.

Reference no: EM132937

Questions Cloud

Evaluate the amount of taxes paid in country : Evaluate the amount of taxes paid in Country

Arrays and control structures important tools in programming : Arrays and control structures important tools in programming.

Make entries in the journals of the capital projects fund : Make the appropriate entries in the general journals of the Capital Projects Fund

Create an xml document containing information : Create an XML document containing information.

Plan an er diagram : Plan an ER diagram

Create a database for the company : Create a database for the company.

Evaluate the tax rules for a parsonage : Evaluate the tax rules for a parsonage usually? Under each of the subsequent conditions, what are the tax implications to the Imam and mosque?

Create an employee class with enough numbers : Create an Employee class with enough numbers.

Evaluate clarks tax basis in his kal-el interest : Evaluate Clark's tax basis in his Kal-El interest on December 31, 20X1?

User Account

All Pages