Cite some examples of integrity constraints that you think can apply to the database shown in Figure 1.2.
What will be an ideal response?
We give a few constraints expressed in English. Following each constraint, we give its type in the relational database terminology that will be covered in Chapter 6, for reference purposes.
(a) The StudentNumber should be unique for each STUDENT record (key constraint).
(b) The CourseNumber should be unique for each COURSE record (key constraint).
(c) A value of CourseNumber in a SECTION record must also exist in some COURSE record (referential integrity constraint).
(d) A value of StudentNumber in a GRADE_REPORT record must also exist in some
STUDENT record (referential integrity constraint).
(e) The value of Grade in a GRADE_REPORT record must be one of the values in the set
{A, B, C, D, F, I, U, S} (domain constraint).
(f) Every record in COURSE must have a value for CourseNumber (entity integrity constraint).
(g) A STUDENT record cannot have a value of Class=2 (sophomore) unless the student has completed a number of sections whose total course CreditHours is greater than 24 credits (general semantic integrity constraint).
You might also like to view...
A throw statement passes which type of value to the catch block?
Fill in the blank(s) with the appropriate word(s).
An image of an active window on your computer that can be pasted into a document is known as a(n) ________
Fill in the blank(s) with correct word
The distance above and below each paragraph in a Word document is ________
A) line spacing B) paragraph spacing C) alignment D) orientation
You would use a system image to access several options in the Windows Recovery Environment
Indicate whether the statement is true or false