Mapeo de Music

Mapeo de Music - topSongs(songCode year rating PK(songCode...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 RecordingLabels(labelID, labelName, location) PK(labelID) MusicalGroups(groupCode, groupName) PK(groupCode) Year(year) PK(year) SongTitles(songCode, SongTitle) PK(songCode) CDTitles(cdCode, labelID, groupCode, numberSold, cdTitle, year) PK(cdCode) FK(labelID) references RecordingLabels(labelID) FK(groupCode) references MusicalGroups(groupCode) Artists(artistID, firstName, lastName, yearBorn) PK(artistID) Member(artistID, groupCode, fromDate, toDate) PK(artistID, groupCode) FK(artistID) references Artists(artistID) FK(groupCode) references MusicalGroups(groupCode)
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: topSongs(songCode, year, rating) PK(songCode, year) FK(year) references Year(year) FK(songCode) references SongTitles(songCode) topCDs(year, cdCode, rating) PK(year, cdCode) FK(year) references Year(year) FK(cdCode) references CDTitles(cdCode) writtenBy(songCode, artistID) PK(songCode, artistID) FK(artistID) references Artists(artistID) FK(songCode) references SongTitles(songCode) composedOf(songCode, cdCode, trackNumber) PK(cdCode, songCode) FK(cdCode) references CDTitles(cdCode) FK(songCode) references SongTitles(songCode)...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online