hi, based on the following specifications, i am to do a project. i have come out with an erd but am not sure if its correct. anyone willing to help me check?
Your task is to develop a database to manage a collection of music (you may assume all of the music is on CDs). Using the database, you should be able to find in an efficient manner:
* a song with a specified title,
* all songs of a specified genre (e.g. rock, pop, folk, jazz, reggae, blues,…),
* all songs by a specified artistes,
* all songs of a specified duration (e.g. between 3 and 4 minutes long), and
* a song with a specified record company,
as well as any combination of the above criteria.
Your system should accommodate the possibility that some albums are compilations from different artistes, and that the same song may be covered by different artistes. For compilations it should be able to find the track number of the song in the original album it is compiled from.
http://farm3.static.flickr.com/2296/1578523742_0f06137446.jpg?v=0