What is a multivalued dependency, and how is it resolved by 4NF? To answer thesequestions, consider the following relation:STUDENT(StudentNumber, StudentName, SiblingName, Major)Assume that the values of SiblingName are the names of all of a given student’sbrothers and sisters; also assume that students have at most one major.A. Show an example of this relation for two students, one of whom has three siblings and the other of whom has only two siblings.B. List the candidate keys in this relation.C. State the functional dependencies in this relation.D. Explain why this relation does not meet the relational design criteria set out inthis chapter (that is, why this is not a well-formed relation).E. Define and discuss 4NF, and how 4NF can be used to allow a set of wellformed relations.F. Divide this relation into a set of relations that meet the relational design criteria(that is, that are well formed). Specify the type of final normal form for eachthe final relations.
What is a multivalued dependency, and how is it resolved by 4NF? To answer these
questions, consider the following relation:
STUDENT(StudentNumber, StudentName, SiblingName, Major)
Assume that the values of SiblingName are the names of all of a given student’s
brothers and sisters; also assume that students have at most one major.
A. Show an example of this relation for two students, one of whom has three siblings and the other of whom has only two siblings.
B. List the candidate keys in this relation.
C. State the functional dependencies in this relation.
D. Explain why this relation does not meet the relational design criteria set out in
this chapter (that is, why this is not a well-formed relation).
E. Define and discuss 4NF, and how 4NF can be used to allow a set of wellformed relations.
F. Divide this relation into a set of relations that meet the relational design criteria
(that is, that are well formed). Specify the type of final normal form for each
the final relations.
Trending now
This is a popular solution!
Step by step
Solved in 5 steps
