Question: please help understand this, only task Q1, Q2, Q3 Entity Relationship Diagram (ERD) Practice For each practice please make note of the following: Noun =

 please help understand this, only task Q1, Q2, Q3 Entity Relationship

please help understand this, only task Q1, Q2, Q3

Entity Relationship Diagram (ERD) Practice For each practice please make note of the following: Noun = Entity/table Adjective =Attributes/column/field Verb = Relationship Read the following and complete the task listed. Consider the following about Luxury Records: Here's the information that you gather: Luxury has decided to store information about musicians who perform on its albums (as well as other company data) in a database. Each musician that records at Luxury has an SSN, a name, an address, and a phone number. Poorly paid musicians often share the same address, and no address has more than one phone Each instrument used in songs recorded at Luxury has a unique identification number, a name (e.g., guitar, synthesizer, and flute) and a musical key (e.g.,CB-flat, E-flat). Each album recorded on the Luxury label has a unique identification number, a title, a copyright date, a format (e.g., CD or MC), and an album identifier. Each song recorded at Luxury has a title and an author. Each musician may play several instruments, and a given instrument may be played by several musicians Each album has a number of songs on it, but no song may appear on more than one album. Each song is performed by one or more musicians, and a musician may perform a number of songs. Each album has exactly one musician who acts as its producer. A musician may produce several albums, of course. Task: 1. List each Entity that is identified in Luxury Records System. 2. For each entity list the attributes. 3. Draw a logical model to represent each entity and the relationships between them. 4. Draw an Entity Relationship Diagram (ERD) that captures the entire system

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!