Skip to content

Latest commit

 

History

History
18 lines (16 loc) · 900 Bytes

File metadata and controls

18 lines (16 loc) · 900 Bytes

MySQL DB Normalization Practice

  • Practice importing data to MySQL Workbench and creating normalized database to store data (up to 3rd Normal Form)
  • The dataset used is "airport.csv", containing information of airports in the US
  • The .pdf report shows step-by-step process of normalization and presents queries that help answer a few business questions PDF
  • The .png images show glimpse of the dataset and the final schema design for the 3NF database

Glimpse of dataset


3NF Schema Design