Answered: Enroll(SIN: Integer, CID: String, Term:…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

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” 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)

No student can take more than 5 courses in a term.

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions