WGU C170
CandidatebnKeybn-bnanswers--
Anbnattribute,bnorbncombinationbnofbnattributes,bnthatbnuniquelybnidentifiesbnabnrowbninbnabnrelation.
CompositebnKeybn-bnanswers--Abnprimarybnkeybnthatbnconsistsbnofbnmorebnthanbnonebnattribute
FirstbnNormalbnFormbn-bnanswers---Eliminatebnrepeatingbngroupsbninbnindividualbntables.
-Createbnabnseparatebntablebnforbneachbnsetbnofbnrelatedbndata.
-Identifybneachbnsetbnofbnrelatedbndatabnwithbnabnprimarybnkey.
SecondbnNormalbnFormbn-bnanswers---
Createbnseparatebntablesbnforbnsetsbnofbnvaluesbnthatbnapplybntobnmultiplebnrecords.
-Relatebnthesebntablesbnwithbnabnforeignbnkey.
ThirdbnNormalbnFormbn-bnanswers---Eliminatebnfieldsbnthatbndobnnotbndependbnonbnthebnkey.
SignedbnNumberbn-bnanswers--Positivebnorbnnegativebnnumber
UnsignedbnNumberbn-bnanswers--Abnnumberbnthatbncannotbnbebnnegative
Entitybn-bnanswers--Abnperson,bnplace,bnproduct,bnconcept,bnorbnactivity
BinarybnRelationshipbn-bnanswers--Abnrelationshipbnbetweenbntwobnentitybntypes
UnarybnRelationshipbn-bnanswers--
Associatebnoccurrencesbnofbnanbnentitybntypebnwithbnotherbnoccurrencesbnofbnthebnsamebnentitybntype
CandidatebnKeybn-bnanswers--
Anbnattribute,bnorbncombinationbnofbnattributes,bnthatbnuniquelybnidentifiesbnabnrowbninbnabnrelation.
CompositebnKeybn-bnanswers--Abnprimarybnkeybnthatbnconsistsbnofbnmorebnthanbnonebnattribute
FirstbnNormalbnFormbn-bnanswers---Eliminatebnrepeatingbngroupsbninbnindividualbntables.
-Createbnabnseparatebntablebnforbneachbnsetbnofbnrelatedbndata.
-Identifybneachbnsetbnofbnrelatedbndatabnwithbnabnprimarybnkey.
SecondbnNormalbnFormbn-bnanswers---
Createbnseparatebntablesbnforbnsetsbnofbnvaluesbnthatbnapplybntobnmultiplebnrecords.
-Relatebnthesebntablesbnwithbnabnforeignbnkey.
ThirdbnNormalbnFormbn-bnanswers---Eliminatebnfieldsbnthatbndobnnotbndependbnonbnthebnkey.
SignedbnNumberbn-bnanswers--Positivebnorbnnegativebnnumber
UnsignedbnNumberbn-bnanswers--Abnnumberbnthatbncannotbnbebnnegative
Entitybn-bnanswers--Abnperson,bnplace,bnproduct,bnconcept,bnorbnactivity
BinarybnRelationshipbn-bnanswers--Abnrelationshipbnbetweenbntwobnentitybntypes
UnarybnRelationshipbn-bnanswers--
Associatebnoccurrencesbnofbnanbnentitybntypebnwithbnotherbnoccurrencesbnofbnthebnsamebnentitybntype