s this database schema look right? From what these steps

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Does this database schema look right? From what these steps are asking me?

• 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.
Lo
Transcribed Image Text:• 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. Lo
(Phone
A trace (Loan)
(
Musician
(11m)
Instrumen's Chns
musical
key
ка
4 Play:
CSSN
Singer
Emil
type
Cin)
Instrumentalists
Perform
Song
Sonsid
(parmint
date
Gitk
Transcribed Image Text:(Phone A trace (Loan) ( Musician (11m) Instrumen's Chns musical key ка 4 Play: CSSN Singer Emil type Cin) Instrumentalists Perform Song Sonsid (parmint date Gitk
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Concurrency control
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education