4vE9kTh3

1CREATE TABLE IF NOT EXISTS STUDENT (
2StudentID INT(11) NOT NULL AUTO_INCREMENT,
3StudentName VARCHAR(45) NOT NULL,
4PRIMARY KEY (StudentID)
5);
6CREATE TABLE IF NOT EXISTS FACULTY (
7FacultyID INT(11) NOT NULL AUTO_INCREMENT,
8FacultyName VARCHAR(45) NOT NULL,
9PRIMARY KEY (FacultyID)
10);
11CREATE TABLE IF NOT EXISTS COURSE (
12CourseID INT(11) NOT NULL AUTO_INCREMENT,
13CourseName VARCHAR(45) NOT NULL,
14PRIMARY KEY (CourseID)
15);
16CREATE TABLE IF NOT EXISTS QUALIFIED (
17FacultyID INT(11) NOT NULL,
18CourseID INT(11) NOT NULL,
19DateQualified DATE NOT NULL,
20PRIMARY KEY (FacultyID, CourseID),
21CONSTRAINT fk_qualified_facultyID FOREIGN KEY (FacultyID) REFERENCES FACULTY (FacultyID),
22CONSTRAINT fk_qualified_courseID FOREIGN KEY (CourseID) REFERENCES COURSE (CourseID)
23);
24CREATE TABLE IF NOT EXISTS SECTION (
25SectionNo INT(11) NOT NULL AUTO_INCREMENT,
26Semester VARCHAR(45) NOT NULL,
27CourseID INT(11) NOT NULL,
28PRIMARY KEY (SectionNo, CourseID),
29CONSTRAINT fk_section_courseID FOREIGN KEY (CourseID) REFERENCES COURSE (CourseID)
30);
31CREATE TABLE IF NOT EXISTS REGISTRATION (
32StudentID INT(11) NOT NULL,
33SectionNo INT(11) NOT NULL,
34PRIMARY KEY (StudentID, SectionNo),
35CONSTRAINT fk_registration_studentID FOREIGN KEY (StudentID) REFERENCES STUDENT
36(StudentID),
37CONSTRAINT fk_registration_sectionNo FOREIGN KEY (SectionNo) REFERENCES SECTION
38(SectionNo)
39);