MIS 325 Lecture Notes - Lecture 1: Multivalued Dependency, Second Normal Form, Functional Dependency

• School: UT-Austin
• Department: Management Information Systems
• Course: MIS 325
• Professor: John Mote

Document Summary

1) create a new relation for each priamry key attribute (or combination of attributes) that is a determinant in a partial dependency. that attribute is the primary key in the new relation. 2)move the nonkey attributes that are only dependent on this primary key attribute(or attributes) from the old relation to the new relation. 3)keep what ever is left in the old relation a relation that is in 1nf will be in 2nf if one of the following conditions applies: - 1)the primary key consists of only one attribute. by definition there cannot be a partial dependency. 2)no nonkey attributes exist in the relation (thus all of the attributes in the relation are components of the primary key) there are no functional dependencies in such a relation. Orderid-->customerid --> customeraddress both customer name and address are uniquely identified by customerid, but. Customerid is not part of the primary key.