Skip to content

1NF, 2NF, 3NF data normalization for Carnival car dealership database - NSS Group Project

Notifications You must be signed in to change notification settings

rebekahgrandey/Carnival-Data-Normalization

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 

Repository files navigation

Carnival-Data-Normalization

1NF, 2NF, 3NF data normalization for Carnival car dealership database - NSS Group project

ERD (Prior to Data Normalization)

  • Created new tables for body_type, make, and model columns from the original VehicleTypes table.

  • Added foreign key id columns in VehicleTypes table for those three columns.

  • Added foreign key constraints to new id columns in VehicleTypes table to connect them to their respective primary key in the new tables.

  • Imported .CSV data into the new tables, remapping column names that didn't correspond to the column names of the tables in the database.

  • Populated foreign keys vehicle_bodytype_id, vehicle_make_id, and vehicle_model_id by writing UPDATE queries which set their ids to match corresponding string data found in that table.

  • Dropped body_type, make, and model columns from VehicleTypes.

About

1NF, 2NF, 3NF data normalization for Carnival car dealership database - NSS Group Project

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published