The company has wisely chosen to hire you as a database designer. • Each musician that records at Tropic Vibe 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 Tropic Vibe has a unique identification number, a name (e.g., guitar, synthesizer, flute) and a musical key (e.g., C, Bflat, E-flat). • Each album recorded on the Tropic Vibe 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 Tropic Vibe 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. Design and draw an ER diagram that captures the information about the Records Shop. Use only the basic ER model here; that is, entities, relationships, and attributes

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Tropic Vibe Records has decided to store information about musicians who perform on its albums (as well as other company data) in a database. The company has wisely chosen to hire you as a database designer. • Each musician that records at Tropic Vibe 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 Tropic Vibe has a unique identification number, a name (e.g., guitar, synthesizer, flute) and a musical key (e.g., C, Bflat, E-flat). • Each album recorded on the Tropic Vibe 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 Tropic Vibe 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. Design and draw an ER diagram that captures the information about the Records Shop. Use only the basic ER model here; that is, entities, relationships, and attributes

Expert Solution