Questionnewtown records has determined to store information

Assignment Help Computer Engineering

Reference no: EM13348989

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: EM13348989

Questions Cloud

Question the corporate income tax rates in two countries a : question the corporate income tax rates in two countries a and b are 40 and 25 correspondingly. additionally both

Questionarrays and control structures are important tools : questionarrays and control structures are important tools while programming. an array contains a number of variables

Question in the fiscal year 2013 the voters of the city of : question in the fiscal year 2013 the voters of the city of bingham approved the issuance of 3 tax supported bonds in

Question1 generate a mockup of the page to show how it will : question1. generate a mockup of the page to show how it will look. this can be done in a number of ways - you could use

Questionnewtown records has determined to store information : questionnewtown records has determined to store information about musicians who perform on its albums in a database.

Questionclassify the entities attributes and relationship : questionclassify the entities attributes and relationship among them for following scenario and create a database for

Question below is an extra credit tax case read the facts : question below is an extra credit tax case. read the facts and the issues. give final case in the form of a 1-2 page

Questioncreate an employee class with enough numbers of : questioncreate an employee class with enough numbers of data members to store employee data of following structure-id

Question on january 1 20x1 clark and lois each contributed : question on january 1 20x1 clark and lois each contributed 110500 to form the kal-el general partnership and the

User Account

All Pages