I will try to ask my question succinctly.
I am charged with maintaining an employee roster. These employees represent several different departments and have various roles in the organization.
Likewise, I am charged with maintaining an inventory of all vehicles. Again, vehicles are assigned to several different departments for use by employees with various roles.
Things like credentials, demographics, seniority dates, drug tests, accidents etc., need to be tracked for employees in addition to the vehicles to which they are assigned.
Purchase information, annual mileage, maintenance costs, etc., need to be tracked for all vehicles.
I am assume this would require multiple related tables. Would it make sense to have one database for all of this data? Would it be easiest to utilize forms for data input by separate individuals?
Thanks