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
Database Structure Analysis
Academic Structure Model
Teaching staff and course units maintain a complex relationship:
- Educator(StaffID, GivenName, FamilyName)
- CourseUnit(UnitID, UnitTitle)
- TeachingAssignment(StaffID, UnitID, ResponsibilityType)