How to determine Database Schema in Access
Posted on 2014-11-14
I am building an Asset tracking and management database. The assets are assigned to one of several offices. I have a one to many relationship set up between the assets table and the office table (one office can manage many assets). My question is in regard to the assets table and the type of asset. For example I need to track expenses for vehicles, but also buildings. Each asset type will have significantly different items to track for example :
Vin, Year, Make, Model, Color, Engine Size, etc.
Address, CIty, State, Appraised Value, Assessed Value, Water Provider, Power Provider, etc.
There are other asset types and items to track for each but this is an example of two. I'm not sure how to set up the tables to be able to track all the different things I need. Would I make several one to one relationships with the main asset table based on asset type?