MusicAgencyEnterprise

MusicAgencyEnterprise - a unique track number within a...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Music Agency Enterprise Generate an ER schema for the Music Agency Enterprise. Create a version that uses the basic cardinality notation and a version that uses (min, max) pairs. A music survey agency wants to keep track of CD-titles, the songs in each title, the musical group that recorded the CD, the recording label that produced the CD, the artists that wrote the songs in the CD, and the ratings for each CD title and song title. A recording label has a unique id, a name and a location. Each recording label produces several CD titles. But each CD title may be produced by one and only one recording label. A CD title has a title and a unique code. The year in which the CD was released and the number sold so far must also be recorded. Each CD title consists of several songs, with a minimum of one song in each CD. Each song has a title and a unique code. The same song could also be present in multiple CD titles. Each song has
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the 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.

Page1 / 2

MusicAgencyEnterprise - a unique track number within a...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online