I manage a hardware database for our company and now we need to add all software and licenses to the DB.
In my Inventory table there's a PropertyNumber column representing each computer, along with a bunch of other info, e.g., IP address, location, etc.
I now need to create a Software table with rows representing each of a couple hundred types of software.
So now each property number needs to be associated with any of these 200 or so kinds of software.
What is the best way to store this information? Should I add a single new column to the Inventory table with a comma-delimited list of software IDs?
johnoa: Look up "intersection table." You have a situation with many computers, and many pieces of software. An intersection table is used to implement a many-to-many relationship.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert