Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer using UML diagram (5) Sun City Records has decided to store information about musicians who record songs in their studio in a database.

Please answer using UML diagram 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_2

Step: 3

blur-text-image_3

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

Time Series Databases New Ways To Store And Access Data

Authors: Ted Dunning, Ellen Friedman

1st Edition

1491914726, 978-1491914724

More Books

Students also viewed these Databases questions

Question

Q: Does the evaluation improve the level of training?

Answered: 1 week ago

Question

What is group replacement? Explain with an example. (2-3 lines)

Answered: 1 week ago

Question

=+such as the dirigenti in Italy?

Answered: 1 week ago

Question

=+ Are there closed-shop requirements or practices?

Answered: 1 week ago