Database Reference
In-Depth Information
Figure 26-8b.
Database Terminology Puzzle
5.
5a.
State and briefly clarify two integrity rules that must
govern a database.
{04}
5b.
How should deletion of referenced tuples be treated?
Give an appropriate example.
{06}
5c.
Suppose that it is desirable to record the following
information in a normalized database:
Course
[C]
Teacher
[T]
Hour
[H]
Room
[R]
Student
[S]
Grade
[G]
Assume that the following dependencies hold:
[H+R]→ C
[H+T] → R
[C+S] → G
[H+S] → R
[C] → T
