Answered step by step
Verified Expert Solution
Question
1 Approved Answer
(5) Sun City Records has decided to store information about musicians who record songs in their studio in a database. Design a relational database schema
(5) Sun City Records has decided to store information about musicians who record songs in their studio in a database. Design a relational database schema for Sun City Records(include a diagrammatic representation). The following specification describes the mini-world that your database must model. Be sure to indicate all keys and constraints, and any assumptions you make. + Each musician that records at Sun City has an SSN, a name, an address, and a phone number. SSN uniquely identifies a musician. Each instrument used in songs recorded at Sun City has a unique identification number, a name (eg: guitar, flute) and a musical key (eg: C, B-flat, E-flat). Each song recorded at Sun City has a title and a date. Songs are uniquely identified by a song id. There are two types of musicians recording a song: vocalists and instrumentalists. Each instrumentalist may play several instruments, and a given instrument may be played by several instrumentalists. Each instrumentalist plays at least one musical instrument. Each instrument must be played by some instrumentalist. Each song is performed by one or more musicians, and a musician may perform a number of songs. Each musician who performs a song receives a payment. Each song must be performed by some musician. A singer has a type (eg: baritone, tenor, and soprano). Singers do not play any instruments. The set of singers and the set of instrumentalists are disjoint
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started