Question: 2. Specify the following 5 queries in SQL on the Music record database schema of Figure 1.1 Total for que 2 is 10 marks) i.

 2. Specify the following 5 queries in SQL on the Musicrecord database schema of Figure 1.1 Total for que 2 is 10marks) i. List all your 5 queries in the table below firstin SQL. ii. Implement the answering of your 5 queries in 2(i)

2. Specify the following 5 queries in SQL on the Music record database schema of Figure 1.1 Total for que 2 is 10 marks) i. List all your 5 queries in the table below first in SQL. ii. Implement the answering of your 5 queries in 2(i) using Sqlplus and the same database you created in question 1, providing your execution and answers to these questions in a script file called username assn3que2.txt. (5 marks) (5 marks) (a) Retrieve the names and phone numbers of all producers of songs by Chief Keetf. (c) For each song, retrieve its title, author, album, copyrightdate, and number of performances of the (d) Retrieve the title, Performing musician's name, and album title of each song. (e) Retrieve the instrument name, musickey and playing musician name of all instruments that are not played by more than one musician. Fig 1.1: An Example Database State of Windsor Music Records Database Musician MNAME Majid Peters Steven Markel MADDR 4747 Oakwood Dr SSN PHONE 222222222 333333333 Melanie Good 444444444 John Doe 1113331112 1231 Berry Ave 2221113332 423 Walker Rd1231235555 5431 Hefty Lane 6751231231 Instrument INAME Flute Trumpet Guitar Drums MUSICKEY C-Flat E-Flat A-Minor B-Minor Album ATITLE Recovery Revival Welcome AID COPYRIGHTDATE FORMAT 2012-08-08 CD CD CD 2015-09-09 2014-04-03 Song STITLE Hello World Happy All Love Sosa Ball For Me AUTHOR 21 Savage 21 Savage Chief Keef Post Malone Play SSN INAME Drums Flute Guitar Trumpet Guitar Contain:s STITLE Hello World Happy All Love Sosa Ball For Me AID Performs SSN STITLE Hello World Love Sosa Ball For Me Hello World Produces SSN AID

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!