Multiple values associated with a single value

[shrims4u]

Hi all, I want a trick as to how to add multiple values for a single value . For example : A Person named "A" has two cars "Car1" , "Car2" How do I design the database for this ??

[Rob Philpott]

You have a table Person keyed say on PersonId. You also have a table Car, keyed on CarId. Also in this table you have a PersonId fogeign key to the first table. Each Person can then own multiple cars, and to see which you need to do a query with a 'join'.

Regards, Rob Philpott.

[Corporal Agarn]

Hello, Rob Philpott has the right idea. Do not forget to index the combination table. If you want to have only one table then I would suggest having an ID, Person, and Car columns that way the ID could be your primary key and you could have an index on the person column and one on the car column. However, Rob's way is the proper way to setup a database.

[AmbiguousName]

I think Rob's idea is better as it is easy to handle, rather than to make All-in-One table. There is really a basic databse rule invloved here that we should make another table for the multi-valued attributes. Parent table's primary key will be foriegn in the newly made table.