Suppose that the Student Registration System is to be expanded to include graduation clearance. Describe some additional items that must be stored in the database. Describe some additional integrity constraints.
What will be an ideal response?
Newitems might include the graduation requirements and the clearance status of each
student. Perhaps the graduation requirements for a student depend on the year the
student started at the school. In that case, the newitems might be the year the student
started at the school, and the graduation requirements that were in effect in each year.
An integrity constraint might be that the status of a student is ’cleared’ only if that
student satisfies the graduation clearance requirements.
You might also like to view...
If you use the Color Scale conditional formatting, you are limited to how many colors (and their gradations?)
A) 2 or 3 B) 1,012 C) Unlimited D) 256
To change the order in which behaviors are triggered, select the behavior in the ____ panel, then click the up arrow button or the down arrow button to move the behavior up or down in the list.
A. Action B. Behaviors C. Elements D. Format