Question on databases
I am attempting to build what in my mind is a simple database. However, translation from my mind to the computer is proving a tad more difficult for my limited database experience. Here's the need:
We have a fleet of vehicles that we loan out to journalists on a weekly basis. I would like to build a database that contains the following elements...1) all the vehicles in the fleet, VIN...basically a list of assets, 2) the journalists' info, addresses, DL #s...basically a contact manager, 3) a loan agreement form that populates with information from both the vehicle and the journalist portions.
Ideally, the vehicle portion would have a sort of running record for each vehicle of who borrowed it and when. The journalist portion would list all the vehicles they've been in and when.
Is this as difficult as I'm making it out to be?
Thanks in advance.
From your description, it seems as though you will need at least 3 tables: Vehicle, Person, Rental.
Your loan agreement can be based on the Rental table as it would store the foreign keys of the person ID who rented it, the vehicle ID that was rented, and other rental info such as date out and date in.