Question: match it with the correct one First Normal Form Every attribute type of a relation must be atomic and single valued - no composite or
First Normal Form Every attribute type of a relation must be atomic and single valued - no composite or multivalued attribute types (domain constraintl) Second Normal Form A relation R satisfies 1 NF and every non-prime attribute type A in R is fully functional dependent on any key of R Third Normal Form The dependency XY, between two sets of attribute types X and Y implies that a value of X uniquely determines a value of Y Functional Dependency A functional dependency XY in a relation R is a transitive dependency if there is a set of attribute types Z that is neither a candidate key nor a subset of any key of R, and both XZ and Z. s Y hold. A relation is in this normal form if it satisfies 2 NF and no nonprime attribute type of R is transitively dependent on the primary key
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
