Cambridge AS Level (9618) - Interactive 3NF Database Manager

1. Add New Student (`STUDENT` Table)

2. Enroll Student in Club (`STUDENTCLUB` Link)

Live Normalized Database State

STUDENT Table

StudentID (PK)StudentNameSchoolClass
101S. Patel11A
102M. Botha12B
103L. Naidoo11A
104A. Smith10C

CLUB Table

ClubID (PK)ClubNameClubRoom (FK)
C01CodingLab 2
C02RoboticsWorkshop
C03ChessRoom 4

ROOM Table

ClubRoom (PK)TeacherInCharge
Lab 2Mr. Jones
Room 4Ms. Adams
WorkshopDr. Smith

STUDENTCLUB Table (M:N Link)

StudentIDStudent NameClubIDClub NameAction
101 S. Patel C01 Coding
101 S. Patel C03 Chess
102 M. Botha C01 Coding
103 L. Naidoo C03 Chess
103 L. Naidoo C02 Robotics