logo
  • About us
  • Services
  • Products
  • Work
  • Contact

Feedback

In Focus

  • Flash XML slideshow
  • Database training

1.2.12. Referential integrity

  • Given two relations R1 and R2
    • R1 contains a foreign key (FK) that references
    • A primary key (PK) in R2
      • R1 referencing relation, R2 referenced relation
    • Shared domains: dom(FK) = dom(PK)
    • Foreign exists: t1 in r(R1), t2 in r(R2)
      • t1[FK] = t2[PK] || NULL
    ‹ 1.2.11. Constraintsup1.3. Joins ›
  • s5 slideshow
 

 

 

Copyright 2007 Lightenna Limited

  • About us
  • Services
  • Products
  • Work
  • Contact