Hello all, I am developing a database for computer inventory regarding several departments in different buildings. There are 3 buildings and 10 departments. There are several departments in one building and each department has a computer. I have always struggled with the physical model of designing a database. Can someone take a look at the table structure and let me know if I am on the right track? I will probably need to break out the peripherals to different tables also? Thanks Jim Wagner Building BuildingID BuildingName Address City State Zip
Unit UnitID UnitName UnitNumber UnitPhone BuildingID Monitor MonitorID Manufacturer ModelNumber SerialNumber BuildingID Tower PCID Manufacturer ModelNumber SerialNumber CPUSpeed CPUName RAM HardDiskSize Description BuildingID Periphials Mouse Keyboard Printer Fax BuildingID Printer PrinterID Manufacturer ModelNumber SerialNumber BuildingID ProductKey ProductKeyID ProductKey BuildingID Registered Number RegisteredID RegistereNumber BuildingID Software SoftwareID Title SoftwareDescription Manufacturer BuildingID
