Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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, 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started