Chat with us, powered by LiveChat Explain what normalization is, and the difference between third normal form (3NF) and Boyce-Codd normal form (BCNF). Body: Attached is an Excel spreadsheet that contains - Writeden

 

Instructions for the project including the following.

  • Introduction: Explain what normalization is, and the difference between third normal form (3NF) and Boyce-Codd normal form (BCNF).
  • Body: Attached is an Excel spreadsheet that contains data of the 50 states: country, region, and states.
  • Use the normalization technique in this unit to normalize the relation.
  • Conclusion: Explain the resulting relations.

Submit your assignment as a word document. APA Style is not required for this assignment.

List of States of US

States of the United States
Country Region States
United States Midwest Iowa (IA), Illinois (IL), Indiana (IN), Kansas (KS), Michigan (MI), Minnesota (MN), Missouri (MO), North Dakota (ND), Nebraska (NE), Ohio (OH), South Dakota (SD), Wisconsin (WI)
United States Northeast Connecticut (CT), Delaware (DE), Massachusetts (MA), Maryland (MD), Maine (ME), New Hampshire (NH), New Jersey (NJ), New York (NY), Pennsylvania (PA), Rhode Island (RI), Vermont (VT)
United States South Oklahoma (OK), Texas (TX)
United States Southeast Alabama (AL), Arkansas (AR), Florida (FL), Georgia (GA), Kentucky (KY), Louisiana (LA), Mississippi (MS), North Carolina (NC), South Carolina (SC), Tennessee (TN), Virginia (VA), West Virginia (WV)
United States West Alaska (AK), Arizona (AZ), California (CA), Colorado (CO), Hawaii (HI), Idaho (ID), Montana (MT), New Mexico (NM), Nevada (NV), Oregon (OR), Utah (UT), Washington (WA), Wyoming (WY)