MCS-243 HW 3: Integrity Constraints and Views (January 2000)
Due: January 26, 2000, 9:00 am
-
We could help catch non-Y2K-compliant data entry to our movie database
by looking for movies that are made in ridiculously early years. If
someone tries entering 99 instead of 1999, for example, we should
reject it, since there were no movies in the year 99. The earliest
movies in the Internet Movie Database (www.imdb.com) are from 1892, so that
is probably a safe constraint to place on our movie database. Show
how.
- Do exercise 6.2 from page 437. Part of "faithfulness" is
enforcing referential integrity.
- Do exercise 6.5(a), p. 438. When O'Neil mentions "current
restrictions," he is referring to his discussion of the X/OPEN
restrictions. Where a statement is illegal, state which rule it
violates.
- Do exercise 6.9 from page 440.
Instructor: Max Hailperin