Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

(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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

C++ Database Development

Authors: Al Stevens

1st Edition

1558283579, 978-1558283572

More Books

Students also viewed these Databases questions

Question

How are asset accounts usually arranged in the balance sheet?

Answered: 1 week ago

Question

U11 Informing Industry: Publicizing Contract Actions 317

Answered: 1 week ago

Question

2. Discuss the steps in preparing a manager to go overseas.

Answered: 1 week ago

Question

8. Measure the effectiveness of the succession planning process.

Answered: 1 week ago