中文网站
  Advanced Search
Read the latest Blogs from IT professionals in the field. Read and write community created documents. Need IT help? Ask our staff. Connect with your peers. Check our Tech Shop for posters, books and software tools. Home

6.2.2 Database Systems: Referential Integrity in the E-R Model

1. These constraints arise frequently. Every relation arising from a relationship set has referential integrity constraints.

  • Figure 6.1 shows an n-ary relationship set R relating entity sets E1,E2, .. .En.

              Figure 6.1: An n-ary relationship set

  • Let Ki denote the primary key of Ei.
  • The attributes of the relation scheme for relationship set R include K1∪ K2 ∪. . .∪Kn.
  • Each Ki in the scheme for R is a foreign key that leads to a referential integrity constraint.

2. Relation schemes for weak entity sets must include the primary key of the strong entity set on which are existence dependent. This is a foreign key, which leads to another referential integrity constraint.

Database System Structure: