2023 CST 333 Database Systems Online Homework Assignment 4 Max 12 pts Exercise 1 2 pts Write a CHECK constraint that | Assignment Collections
Computer Science 2023 SQL
2023 CST 333 Database Systems Online Homework Assignment 4 Max 12 pts Exercise 1 2 pts Write a CHECK constraint that | Assignment Collections
CST 333 Database Systems (Online)
Homework Assignment #4 (Max: 12 pts)
Exercise 1 (2 pts)
Write a CHECK constraint that expresses the following condition on attribute Rating in table Movies in Movie Database: “Any possible value of Rating is either a null value or a number in the interval from 0 to 10 inclusively”.
Exercise 2 (2 pts)
Write a CHECK constraint that expresses the following condition on records in table Laptop in Hardware Database: “If the screen is larger than 20, then the price is higher than 2000”.
Exercise 3 (2 pts)
Write a CHECK constraint that expresses the following condition on table Schedule in University Database: “Each course (occurring in this table) is offered at least two times”. Hint: Use NOT EXISTS.
Exercise 4 (2 pts)
Write a CHECK constraint that expresses the following condition on table StarsIn in Movie Database:
We give our students 100% satisfaction with their assignments, which is one of the most important reasons students prefer us to other helpers. Our professional group and planners have more than ten years of rich experience. The only reason is that we have successfully helped more than 100000 students with their assignments on our inception days. Our expert group has more than 2200 professionals in different topics, and that is not all; we get more than 300 jobs every day more than 90% of the assignment get the conversion for payment.