Consider the following database schema: STUDENTS (SNUM: integer, SNAME : string, MAJOR : string, LEVEL : string, AGE : integer)
CLASS (NAME : string, MEETS_AT : time, ROOM : string, FID : integer)
ENROLLED (SNUM : integer, CNAME : string)
FACULTY (FID : integer, FNAME : string, DEPTID : integer)
The meaning of these relations is straightforward; for example, ENROLLED has one record per student-class pair such that the student is enrolled in the class. Express each of the following integrity constraints in SQL unless it is implied by the primary and foreign key constraint; if the constraint cannot be expressed in SQL, say so.
1. No faculty member from department number 5 can teach more than four courses.
2. The number of CS majors must be more than the number of math majors.
3. No student should enroll in more than 2 classes offered by the same faculty.