Question: 4 . Normalize the below single table database to ( 3 N F ) ( 2 0 points ) : RENTAL _ CARS
Normalize the below single table database to N F points:
RENTALCARS
CarVIN
CustomerID,
CustomerName,
CustomerPaymentMethod, SalespersonID, SalespersonName, CarMake, CarModel, ReturnDate, BilledAmount
Assume the following functional dependencies in your solution:
FD: CustomerID rightarrow SalespersonID
FD: CarVIN, CustomerID rightarrow ReturnDate, BilledAmount
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
