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) |