Task 1

(a) Table Explanation

• Artist: Represents musicians or bands. PK: ArtistID
• Album: Represents collections of tracks. PK: AlbumID, FK: ArtistID
• Track: Represents individual songs. PK: TrackID, FK: AlbumID

(b) ER Diagram Description

Lecturers and Modules have a many-to-many relationship with roles:

• Lecturer(LecturerID, FirstName, LastName)
• Module(ModuleID, ModuleName)
• LecturerModule(LecturerID, ModuleID, Role)