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 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
Get step-by-step solutions from verified subject matter experts
