Hi guys,
I'll doing a car rental database with 4 tables. Below is my the data after normalization..Could you guys pls tells me is it correct? If it's wrong, what to amend? Thanks so much..
Customer {CustomerID, FirstName, LastName, Address, ContactNo, Email}
Agent {AgentID, FirstName, LastName, ContactNo, Email, RentaLID(FK)}
Vehicle {VehiclePlateNo, Type, Brand, Model, ManufacturingDate, Color}
Rental {VehiclePlateNo, CustomerID, Hour, Rate, TotalAmount, Date, Time-In, Time-Out}
*RentaLID = VehiclePlateNo + CustomerID
Best Regards,
Roland
rhfh 0 Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.