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 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
Get step-by-step solutions from verified subject matter experts
