MusicSchema

MusicSchema - topCDs(cdCode, year , rating) composedOf...

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

View Full Document Right Arrow Icon
WinRDBI Music Agency Relational Database Schema recordingLabel(labelID , labelName, location) cd(cdCode , cdTitle, numberSold, year, labelID, groupCode) song(songCode , songTitle) musicalGroup(groupCode , groupName) artist(artistID , firstName, lastName, yearBorn)
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: topCDs(cdCode, year , rating) composedOf (cdCode, songCode , trackNumber) topSongs(songCode, year , rating) member(groupCode, artistID, fromDate , toDate) writtenBy(songCode, artistID )...
View Full Document

Ask a homework question - tutors are online