Assignment: Database
• What is a referential integrity constraint? Define the term, and give an example of its use. Are null values allowed in foreign key columns with a referential integrity constraint? How does the referential integrity constraint contribute to database integrity?
• Explain the role of referential integrity constraints in normalization.
• Do relations StudID_SocialSecurityNumber and SocialSecurityNumber_StudName contain a transitive dependency?
• In normalization example 3, why is the EXTENDED_PRICE relation "silly"?
• In normalization example 4, under what conditions is the functional dependency (StudentID, Activity) S ActivityFee more accurate than Activity S ActivityFee
• If a determinant is part of a candidate key, is that good enough for BCNF?
• In normalization example 5, why are the following two tables not correct? DEPARTMENT (Department, DeptBudgetCode, Buyer) SKU_DATA_4 (SKU, SKU_Description, Department)
• How does a multivalued dependency differ from a functional dependency?
• Consider the relation: PERSON (Name, Sibling, ShoeSize) Assume that the following functional dependencies exist: Name S S Sibling Name S ShoeSize Describe deletion, modification, and insertion anomalies for this relation.
• Why is BCNF referred to as the best of the forms?
• Consider the relation: PERSON_2 (Name, Sibling, ShoeSize, Hobby) Assume that the following functional dependencies exist: Name S S Sibling Name S ShoeSize Name S S Hobby Describe deletion, modification, and insertion anomalies for this relation.
• What must we know in order to find functional dependencies in a table?
• What is a multivalued dependency?
• How do the conditions for DK/NF correspond to the conditions for BCNF?
Format your assignment according to the give formatting requirements:
• The answer must be using Times New Roman font (size 12), double spaced, typed, with one-inch margins on all sides.
• The response also includes a cover page containing the student's name, the title of the assignment, the course title, and the date. The cover page is not included in the required page length.
• Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.