title: Question about setting up inventory database
body: <p>Ok, so I am creating a sql database to keep track of inventory. I have around 170 individual types of items. Some of the types have more than one item in them. For example: I have a cisco switch (Type of Item) and I have 20 of these switches. </p>
  
  <p>I am trying to figure out how to enter these into the database. Each item has a serial number, do i need to enter each switch individaully into the database? Or is there a way I can enter the switch type once and list all the serial numbers for that one row? I want to use the Count function to get a count of how many rows there are for each item also. </p>
  
  <p>I am just trying to figure out the best way to set this up. Not asking for a solution, just suggestions. let me know if more info is needed.</p>
  
  <p>Here are the tables I have and their columns:</p>
  
  <p>Table: Item</p>
  
  <p>Columns: id, ItemDescriptorID, LocationID, AccessoriesID, SerialNumber, AssignedTo</p>
  
  <p>Table: ItemDescriptor</p>
  
  <p>Columns: id, Brand, DeviceName, Model, Image, Type, Notes</p>
  
  <p>Table: Accessories</p>
  
  <p>Columns: id, ItemDescriptorID, OnHandCount, StorageRoomCount</p>
  
  <p>Table: Location</p>
  
  <p>Columns: id, Location</p>