Query Microsoft Access
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 |
Solution:
Query:
ALTER TABLE Schedule ADD CONSTRAINT myCheck CHECK(ScheduleRowcount(Courseid, Term)>= 2);
I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)
Query Microsoft Access Write a CHECK constraint that expresses the following condition on table Schedule in...