Question: 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

 Consider the following relational schema. Enroll(SIN: Integer, CID: String, Term: String,

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. a. [2 marks] All grades are between 0 and 100 (inclusive) b. [3 marks] No student can take more than 5 courses in a term

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!