Someone can help me I’m a little new in the matter... DATABASE

Asked

Viewed 34 times

-4

I’m setting up a quiz site... has three types of tests. FRIENDSHIPS BOYFRIENDS MARRIED

each test has 15 questions, how do I save the text of these questions in the database and then generate a hit result?

mysql

1 answer

0


Hello, the logic would be to create a table with the categories you quoted, with ID, Category. another of questions with: ID, Question, FK of the Type finally another table with: Alternative, FK of the question and a STATUS to indicate if the alternative is correct.

the rest would be more the application who would do, of course depending on your business rules can be more complex. if you wanted to save the staff answers or create a ranking, for example.

  • Po man I understand your logic, I just can’t understand where I’m going to save the text of the 15 questions you understand???

Browser other questions tagged mysql

You are not signed in. Login or sign up in order to post.