Share
Explore BrainMass

Question 11. What are "referential integrity constraints"? P

Question 11.
What are "referential integrity constraints"? Provide an example.
Question 12.
What are the advantages and disadvantages of personal DBMS products hiding the complexity of database systems?

Attachments

Solution Preview

Question 11.
What are "referential integrity constraints"? Provide an example.

A referential integrity constraint is a value that "appears in one relation for a given set of attributes and also appears for a certain set of attributes in another relation" (GreenWebHost, 2011).
Essentially, they are rules that make up the database table scheme, which can accept nulls. The referential integrity constraint can happen in almost any data model, and specifies three key pieces of information. The first factor it identifies is the principal end of the constraint, which is the entity type, "Whose entity key is referenced by the deepest end" (Microsoft, 2012). Other factors it identifies include the entity key of the principle end of the association involved in the referential integrity constraint, and the dependent end of the constraint. The dependent end of the constraint is the entity type that symbolizes the entity key at the principal end. The fourth relevant factor identified is the referencing property on the dependent end of the association.
An example of a referential integrity constraint is a setup where customers are each assigned a specific number that is located in the master ...

Solution Summary

Question 11.
What are "referential integrity constraints"? Provide an example.
Question 12.
What are the advantages and disadvantages of personal DBMS products hiding the complexity of database systems?

$2.19