Question: Consider the following relational schema. Enroll ( SIN : Integer, CID : String, Term : String, Grade : Integer); Teaches ( CID : String, Term
Consider the following relational schema.
Enroll(SIN: Integer, CID: String, Term: String, Grade: Integer);
Teaches(CID: String, Term: String, InstructorSIN: Integer);
Note: in the above relations, SIN stands for Social Insurance Number, and thus is a unique identifier for any person associated with the university (whether student, instructor, or other employee of the university).
Write SQL CHECK constraints, assertions or triggers (as appropriate) to ensure each of the following requirements, considered independently.
- All grades are between 0 and 100 (inclusive)
b. No student can take more than 5 courses in a term.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
