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 Number	Model Name	Seat Capacity	Chassis Code	Chassis Manuf	Chassis Model	Feature Code	Feature Name
SC102	Pupil Express	27	FRDA1	Ford	A-100	SCBL	School bus lights
SC102	Pupil Express	27	FRDA1	Ford	A-100	RDO	Radio
SC110	Pupil Express Plus	23	FRDA1	Ford	A-100	SCBL	School bus lights
SC110	Pupil Express Plus	23	FRDA1	Ford	A-100	RDO	Radio
SC110	Pupil Express Plus	23	FRDA1	Ford	A-100	WCLF	Wheelchair lift
SC110	Pupil Express Plus	23	FRDA1	Ford	A-100	WCTD	Wheelchair tie-down
RS100	Rental Express	20	FRDA1	Ford	A-100	RDO	Radio
RS100	Rental Express	20	FRDA1	Ford	A-100	ILRK	Internal luggage rack
RS50	Rental Sprint	14	DGSP	Dodge	Sprinter	RDO	Radio
RS50	Rental Sprint	14	DGSP	Dodge	Sprinter	ILRK	Internal luggage rack
MT55	Maxi Taxi X5	3	DGSP	Dodge	Sprinter	WCLF	Wheelchair lift
MT55	Maxi Taxi X5	3	DGSP	Dodge	Sprinter	WCTD	Wheelchair tie-down
MT60	Maxi Taxi C6	3	GMUV	GMC	Utilivan	WCLF	Wheelchair lift
MT60	Maxi Taxi C6	3	GMUV	GMC	Utilivan	WCTD	Wheelchair tie-down
MT60	Maxi Taxi C6	3	GMUV	GMC	Utilivan	RDO	Radio

Design a relational database to keep this same information in third normal form and create each new table with its corresponding data.

UNF:

1NF:

2NF:

3NF:

Tables in 3NF: