Creating and Using a New Database in Access 2010 or higher versions
Section B:
In this section create a New Music Database in Access 10 or higher version, given the following
schema:
CD (CDNumber, Title, Year, Price)
Track (CDNumber, PerformanceCode, trackNo)
Recording (PerformanceCode, Song Title, Year)
Composer (CompName, Song Title, PerformanceCode)
Singer (SingerName, PerformanceCode)
Write SQL queries (and verify by checking the results of your) that it will find correctly:
5) The singer on the CD that contains the largest number of songs.