Can someone please give me a hand with this, this table needs to be normalized i
ID: 3661871 • Letter: C
Question
Can someone please give me a hand with this, this table needs to be normalized in 1NF, 2NF, & 3NF.
TRUCK(TruckID, TruckPrice, TruckSalesTax, TruckType, TruckModel, TruckDatePurchase, TruckESTMPG, TruckFuelType, FuelID, FuelDate, BeginningOdometerReading, EndOdometerReading, NumOfGallonsPurchased, CostPerGallon, MaintID, MaintenanceLineNumber, MaintenanceDesc, MaintenanceDate, MaintenanceCost, OperationCostID, OperationCostLineNumber, OperationCostDesc, OperationCostDate, OperationCostAmount)
Explanation / Answer
After Normalizing with 1NF, 2NF and 3NF
The tables will be as follows:
TRUCK(TruckID, TruckPrice, TruckSalesTax, TruckType, TruckModel, TruckDatePurchase, TruckESTMPG, TruckFuleType)
FUEL(TruckID, FuelID, FuelDate, BeginningOdometerReading, EndOdometerReading, NumOfGallonsPurchased, CostPerGallon)
MAINTENANCE(TruckID, MaintID, MaintenanceLineNumber, MaintenanceDesc, MaintenanceDate, MaintenanceCost)
OPERATION(TruckID, OperationCostID, OperationCostLineNumber, OperationCostDesc, OperationCostDate, OperationCostAmount)