Hello there,
I am new to this and I am after some help, I will understand if you can’t for some reason answer my email, if you can and if you want reply directly to woodenorwire2@yahoo.co.uk
I gotta design a data base for a motor pool, any suggestions?
Can u help me out?
I have to create a database established on this data.
One trip can be made by many people
One person can make many trips
One trip can be made to many destinations
One person can only take one car at the time
I am just wondering what would be the primary and the foreign keys, how would I link one to one and one to many.
This is what I got
Motor Pool Company
Company cars
Employee’s
Name
Department
Phone number
Driver’s license number
ID trip
Destination
Date reserved
Who reserved it
Starting Date
Ending date
Rental period
Miles in
Miles out
Amount due
Paid
Payment Method
License
Car ID number
Car ID number
License plate number
Model name and style
Description
Car group name
Current mileage
Daily rate
Any help is appreciated, hope to hear from you soon
W. |
