Question
Griffith's music school is about to launch a music company, which needs a new database to be developed to store all the necessary information about
Griffith's music school is about to launch a music company, which needs a new database to be developed to store all the necessary information about musicians, albums, songs, and live performances. Following is further detail. o Each musician in the company has a unique SSN, first name, last name, an address, and a phone number. o Each album recorded has an album ID, title and an author (musician). o Each album has multiple songs on it. Each song has a unique Song ID, name, length, and a track number. o Each song is performed by one or more musicians, and a musician may perform multiple songs. o Musicians also perform in live performances. The company wants to keep track of the location and time of each performance that a given musician took part in.
question:
Write SQL DDL for the relational schema created above. Use camelCase naming convention for tables and columns names. Choose appropriate data types for table fields, set the primary and foreign keys to implement the relationships. Run the DDL statements on MySQL server to create tables of the database and take a screenshot of the result for each query executed successfully. (
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