Database design and implementation (normalization)

 

As a database administrator, you are tasked with creating a logical database design that will be used later to
implement the physical database named State_Capitals. The first step of creating a logical database design is
normalization.
Please download the Excel workbook.
UnitIII_US_States.xlsx
Instructions for the project including the following.
Introduction: Explain what normalization is, and the difference between third normal form (3NF) and BoyceCodd 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.

 

 

 

 

The post Database design and implementation (normalization) first appeared on COMPLIANT PAPERS.

Posted in Uncategorized