CREATE TABLE Student(
    StudentID INT(5),
    StudentName VARCHAR(25),

    CONSTRAINT Student_PK PRIMARY KEY(StudentID)
);

CREATE TABLE Faculty(
    FacultyID INT(4),
    FacultyName VARCHAR(25),

    CONSTRAINT Faculty_PK PRIMARY KEY(FacultyID)
);

CREATE TABLE Course(
    CourseID VARCHAR(8),
    CourseName VARCHAR(15),

    CONSTRAINT Course_PK PRIMARY KEY(CourseID)
);
CREATE TABLE Qualified(
    FacultyID INT(4),
    CourseID VARCHAR(8),
    DateQualified DATE,

    CONSTRAINT Qualified_PK PRIMARY KEY(FacultyID, CourseID),
    CONSTRAINT Qualified_FID FOREIGN KEY(FacultyID) REFERENCES Faculty(FacultyID),
    CONSTRAINT Qualified_CID FOREIGN KEY(CourseID) REFERENCES Course(CourseID)
);

ALTER TABLE Student ADD Class VARCHAR(4);

DROP TABLE Registration;

ALTER TABLE Faculty MODIFY

SELECT * FROM Student WHERE StudentID < 50000;

SELECT * FROM Faculty WHERE FacultyID = 4756;

SELECT MIN(SectionNo) FROM SECTION WHERE Semester= "I-2008";

SELECT COUNT(*) FROM Registration WHERE SectionNo = 2714 AND Semester = "I-2008";

SELECT FacultyID, CourseID, DateQualified FROM Qualified WHERE YEAR(DateQualified);