Quizzes

[wounded_soul]

hi all,

anybody can help me

i want to create a table for student quezzes grade and i don't know how many number of quezzes the doctor will give the student

should i put in database:

quis 1,quis 2,quis 3,quis 4,....

and concatenate these with course table (forigen key courseid)

i have many courses and each course also has a number of quezzes

[bradgrafelman]

wounded soul;10983717 wrote:

should i put in database:

quis 1,quis 2,quis 3,quis 4,....

Definitely NOT (can't emphasize that enough).

Proper database design can require a lot of knowledge and experience. I'd first suggest you find some articles on DB normalization and design.

Next, you'd want to figure out what are all of the pieces of data (quiz id, quiz name, course id, course name, student id, student name, etc. etc. ad nauseum) that your DB should contain.