Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Exercise 3 (2 pts) Write a CHECK constraint that expresses the following condition on table Schedule in University Database: In each term occurring in this
Exercise 3 (2 pts)
Write a CHECK constraint that expresses the following condition on table Schedule in University Database: In each term occurring in this table, at least two courses are offered. Hint: Use NOT EXISTS.
CourseId | Term | InstrId |
---|---|---|
CS 200 | Fall 2016 | 003 |
CS 200 | Fall 2017 | 003 |
CS 300 | Spring 2017 | 003 |
CS 400 | Fall 2016 | 004 |
CS 400 | Fall 2017 | 004 |
Math 200 | Fall 2016 | 001 |
Math 200 | Spring 2017 | 004 |
Math 200 | Fall 2017 | 001 |
Phys 400 | Spring 2017 | 002 |
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