This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: a unique track number within a particular CD. For each year, the end-of-the-year rating (top 40) of each CD title and song title must be maintained. A CD title is recorded by a single musical group, which has a name, and a unique code. A musical group may record several CD titles during its life span. The group consists of one or more artists, each of whom has a first name, last name and a unique id. The year in which the artist was born is also recorded. Since any artist may belong to multiple musical groups over time, the database must record the date when an artist joined a particular group and the date when he or she left the group. One or more artists write each song title on a CD. A single artist may contribute towards the writing of multiple song titles within a CD, but it isnt necessary for an artist to write a song. Figure 1: ER Diagram for Music Agency Enterprise...
View Full Document
This note was uploaded on 02/27/2011 for the course CSE 412 taught by Professor Davulcu,h during the Spring '08 term at ASU.
- Spring '08