Explanation:The delete “cascades” to the course relation, deletes the tuple that refers to the department that was deleted. 7. Domain constraints, functional dependency and referential integrity are special forms of _________.
A. Foreign key
B. Primary key
C. Assertion
D. Referential constraint
Answer:A
Explanation:The delete “cascades” to the course relation, deletes the tuple that refers to the department that was deleted. 7. Domain constraints, functional dependency and referential integrity are special forms of _________.
A. Foreign key B. Primary key C. Assertion D. Referential constraint
Explanation:An assertion is a predicate expressing a condition we wish the database to always satisfy. 8. Which of the following is the right syntax for assertion?