Database Reference
In-Depth Information
Figure 1.22
The Music Studio
Schema.
ARTIST.
A musician who has either recorded a song or participated
in recording another musician's song. Each artist record has the
name, address, and e-mail of the musician. Every artist has a unique
identification number (ARTIST_ID) assigned when the record was
entered into the database table. In addition, a special column called
INSTRUMENTS contains a list of musical instruments the musician
plays. This special column is a collection (a list of many values held in
a single column).
SONG.
The ARTIST_ID column identifies the owner of each song
in the table. Each song has a title, recording date, and playing time.
The RECORDING column contains the final recorded song in an
audio format, ready to play.
MUSICCD and CDTRACK
. A music CD has two tables for all the
information. First, the MUSICCD table holds the CD title, date it
was pressed, and the total playing time of the CD. Second, the
CDTRACK table contains all the songs for each CD and the order in
which that song appears on the CD. This arrangement of tables
