This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: no 1s at the ends of the lines). This is because Access, unlike the book, considers one-to-one relationships to be mandatory in both directions. That is, each record in one table must have a matching record in the other, and vice versa. Since this is not how super type/sub type relationships work (records in the Customers table are only matched in one of the sub type tables, not both), we must show these relationships without referential integrity enforced. If you have super type/sub type relationships in your assignment 1 databases, you do not need to enforce referential integrity on them. You should still enforce referential integrity on all other relationships....
View Full Document
This note was uploaded on 03/17/2010 for the course IOE 373 taught by Professor Snadwich during the Winter '08 term at University of Michigan.
- Winter '08