title: Correctly place table into 4NF?
body: <p><strong>Question:</strong></p>
  
  <p>Place the PERSON relation into 4NF where</p>
  
  <p>PERSON (Name, Sibling, Shoe_Size)
  Assume the following functional dependencies exist:</p>
  
  <p>Name -->--> Sibling</p>
  
  <p>Name --> Shoe_Size</p>
  
  <p>..................</p>
  
  <p>Is what I have come up with below a correct version of the table in 4NF? Still getting my head wrapped around Normalization.</p>
  
  <p>LIST THE MULTIVALUED DEPENDENCIES</p>
  
  <p><strong>Name -->--> Sibling</strong></p>
  
  <p>SPLIT MULTIVALUE DEPENDENCIES INTO OWN TABLE</p>
  
  <p><strong>PERSON_2([PK]PersonName, Shoe_Size)</strong></p>
  
  <p><strong>SIBLING([FK]PersonName, SiblingName)</strong></p>
  
  <p>STEP TWO:  LIST THE FUNCTIONAL DEPENDENCIES</p>
  
  <p><strong>PersonName -> (Shoe_Size, SiblingName)</strong></p>
  
  <p>STEP THREE:  LIST THE INITIAL CANDIDATE KEYS</p>
  
  <p><strong>PersonName</strong></p>
  
  <p>STEP SEVEN:  STATE THE FINAL TABLES AND CREATE REFERENTIAL INTEGRITY CONSTRAINTS</p>
  
  <p><strong>PERSON_2([PK]PersonName, Shoe_Size)</strong></p>
  
  <p><strong>SIBLING([FK]PersonName, SiblingName)</strong></p>
  
  <p>..</p>
  
  <p><strong>WHERE SIBLING.PersonName must exist in PERSON_2.PersonName.</strong></p>