Someone can help me I'm kind of new on the subject ... DATA BANK

Question

Someone can help me I'm kind of new on the subject ... DATA BANK

Navigation

#1 by (0 votes)

-4

I'm creating a test site for questions ... has 3 types of tests. FRIENDSHIPS BOYFRIENDS MARRIED

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

mysql

asked by anonymous 18.01.2018 / 00:18

1 answer

LIMIT does not interpret the variables How to put a datepicker in an Android application whose page is being developed in PHP

score 0 · Accepted Answer

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 Type finally another table with: Alternative, question FK 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 answers from the staff or create a ranking, for example.