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..
Tables

EquipmentInfo
Make
Model
Memory
SanitizationProcedure
EquipmentType
SiteApproval

LocationInfo
CageCode
SiteName
Custodian
Area
TestStand

Assets
InformationSystem
Make
Model
SerialNumber
AssetTag
Location
Auditor
Status

Transactions
AssetTag
UserPerformingAction
Date
StartTime
EndTime
ActionPerformed
Notes



Any guidance would be appreciated. I ordered a couple books off amazon