Hi all, I'm new here, and I'm a newbie in database design. I have some questions regarding database design:
1.) Say I want to maintain a information of a person in a database. In the table "Person", I want to have a field call friends which represent a list of "Id" of "Person"(reference to the same table). What datatype should I use to store a list of Id's in a single field?
2.) Say I have a table "Questions" that maintain questions in different kinds of
test, like physics, chemistry, biology... but some questions may be in more than one catergories (i.e. a question can be both chemistry and physics question). Should I maintain all questions in one table with the fields "Phy", "Chem", "Bio" as flags? Or should I maintain one table that contains all questions, and three more table "PhyQuestions", "ChemQuestions", "BioQuestions", that contain only the "Id's" of question in the "Questions" table?
Thanks
Cal