Database Normalization 
Assignment #3 - Normalization: School Buses The following single-table database contains information on the product offerings from a firm that supplies small, van-like buses to various markets. The company takes chassis produced by major vehicle manufacturers and builds them into various finished, more specialized products. The table contains information on the products offered, which chassis each product is based on, and which features each finished product has. Model Name Feature Feature Name Code Seat Capacity 27 27 23 23 Model Number SC102 SC102 SC110 SC110 SC110 SC110 RS100 RS100 RS50 RS50 MT55 MT55 MT60 MT60 MT60 23 20 Pupil Express Pupil Express Pupil Express Plus Pupil Express Plus Pupil Express Plus Pupil Express Plus Rental Express Rental Express Rental Sprint Rental Sprint Maxi Taxi X5 Maxi Taxi X5 Maxi Taxi C6 Maxi Taxi C6 Maxi Taxi C63 Chassis Code FRDA1 FRDA1 FRDA1 FRDA1 FRDA1 FRDA1 FRDA1 FRDA1 DGSP DGSP DGSP DGSP GMUV GMUV GMUV Chassis Chassis Model Manut Ford A-100 Ford A-100 Ford A-100 Ford A-100 Ford A-100 Ford A-100 Ford A-100 Ford A-100 Dodge Sprinter Dodge Sprinter Dodge Sprinter Dodge Sprinter GMC Utilivan GMC Utilivan GMCutivan 20 SCBL RDO SCBL RDO WCLF WCTD RDO ILRK RDO ILRK WCLF WCTD WCLF WCTD RDO School bus lights Radio School bus lights Radio Wheelchair lift Wheelchair tie-down Radio Internal luggage rack Radio Internal luggage rack Wheelchair lift Wheelchair tie-down Wheelchair lift Wheelchair tie-down Radio 14 14 Design a relational database to keep this same information in third normal form and create each new table with its corresponding data. UNF: INF: 2NF: 3NF: Tables in 3NF: Assignment #3 - Normalization: School Buses The following single-table database contains information on the product offerings from a firm that supplies small, van-like buses to various markets. The company takes chassis produced by major vehicle manufacturers and builds them into various finished, more specialized products. The table contains information on the products offered, which chassis each product is based on, and which features each finished product has. Model Name Feature Feature Name Code Seat Capacity 27 27 23 23 Model Number SC102 SC102 SC110 SC110 SC110 SC110 RS100 RS100 RS50 RS50 MT55 MT55 MT60 MT60 MT60 23 20 Pupil Express Pupil Express Pupil Express Plus Pupil Express Plus Pupil Express Plus Pupil Express Plus Rental Express Rental Express Rental Sprint Rental Sprint Maxi Taxi X5 Maxi Taxi X5 Maxi Taxi C6 Maxi Taxi C6 Maxi Taxi C63 Chassis Code FRDA1 FRDA1 FRDA1 FRDA1 FRDA1 FRDA1 FRDA1 FRDA1 DGSP DGSP DGSP DGSP GMUV GMUV GMUV Chassis Chassis Model Manut Ford A-100 Ford A-100 Ford A-100 Ford A-100 Ford A-100 Ford A-100 Ford A-100 Ford A-100 Dodge Sprinter Dodge Sprinter Dodge Sprinter Dodge Sprinter GMC Utilivan GMC Utilivan GMCutivan 20 SCBL RDO SCBL RDO WCLF WCTD RDO ILRK RDO ILRK WCLF WCTD WCLF WCTD RDO School bus lights Radio School bus lights Radio Wheelchair lift Wheelchair tie-down Radio Internal luggage rack Radio Internal luggage rack Wheelchair lift Wheelchair tie-down Wheelchair lift Wheelchair tie-down Radio 14 14 Design a relational database to keep this same information in third normal form and create each new table with its corresponding data. UNF: INF: 2NF: 3NF: Tables in 3NF
