Table Definitions
- Music Artists: Stores performer information. Primary Key: ArtistID
- Music Collections: Contains album data. PK: AlbumID, FK: ArtistID
- Song Items: Individual recordings. PK: TrackID, FK: AlbumID
Teaching staff and course units maintain a complex relationship: