Do the tables represent features of the same thing?
Joined: Jun 28, 2007
yes the features of same thing. actually i am parsing an XML file and then transferring its data into the database.
Let me elaborate my question by giving example:
suppose my xml file is the below one:
i want to design a database to store above xml file information. one table that i decided is Question table that contains que_number, question, and answer columns. now, whether i should create another table for score element or shall i add max_score, min_score, and actual_score columns to the Question table itself. what shall be the better approach. please guide me. thank you.
Joined: Oct 13, 2005
I hope somebody else will comment, because I might be mistaken, but how can a score be bound to a question? Surely it is bound to whoever answered the question as well. In which case it would fit better into a separate table. You have a question table with an answer, then you have a participant table, and you link answer given with the question, so you can see whether the answer was correct or incorrect.
I am sure other people will have different suggestions, so fire away . . .