Hello,
I have a relatively simple question to ask. Any help is
great appreciated.
Let us say that I want to create a classic table
that would have columns for a persons name, eye color,
age, etc.
However, I also want to store a list (somewhere) of that particular
persons favorite foods
James --
You haven't done enough book work this is basic db design stuff,
covered in Dubois book and evey other, the short answer is:
Primary Key - foriegn Keys i.e
People table:
person_id, # Primary key, unique and auto increment
fname
lname
...
Food
person_id # pulled from People table via