I am trying to design an Asset Tracking Database for my organization. There are currently about 10 different sites that use 10 different access databases that were all created locally at their site and no 1 database is the same.
The database will most likely be MS SQL since our IT Dept uses it.
Basically the assets are electronic test equipment and computers. I need to know where everything is at all times.
This will be a web based application that will have inventorying capabilities
Ability to add new types of equipment, add new assets, create transactions on assets
this is what im thinking so far..
Any guidance would be appreciated. I ordered a couple books off amazon