WGU C170

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