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.

  1. 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

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!