What type of table?

[mrgreg64]

I am disigning a DB to keep track of different types of equipment (laptops, desktops, printers, etc.) Each piece of equipment is tracked by a model #, Manufacturer, serial number, an individual bar code #, and other data depending on the type of equipment such as a phone number for cell phones. What is the best design method for creating a table or tables. Should I have just one large table listing each pice of equipment or have an individual table for each equipment type (one for laptops, one for desktops etc)? What are some pros and cons of each method? I hope this makes sense.

 

[boblarson]

Check out the data models here:
http://www.databaseanswers.org/data_models/

Specifically look for Item 11 (Inventory) and then look to #10 in that list for IT Assets.