Natural Join
Relational Schema
Artist(artist_id, name, website)
Album(album_id, artist_id, title, year, label)
Track(album_id, track#, title, length)
Primary keys
Primary keys are underlined.
- Artist: artist_id
- Album: album_id
- Track: album_id, track#
Foreign keys
- Album(artist_id) → Artist(artist_id)
- Track(album_id) → Album(album_id)
|