ERD help!
Posted by: gorilla tanz
Date: October 15, 2007 08:25AM

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

Options: ReplyQuote


Subject
Written By
Posted
ERD help!
October 15, 2007 08:25AM
October 19, 2007 09:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.