MCS-243 HW 3: Integrity Constraints and Views (January 2000)

Due: January 26, 2000, 9:00 am

  1. 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.
  2. Do exercise 6.2 from page 437. Part of "faithfulness" is enforcing referential integrity.
  3. 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.
  4. Do exercise 6.9 from page 440.


Instructor: Max Hailperin