Hello. It is necessary to implement a database for the survey system. There should be the following columns: poll id, poll name, survey response options, number of voters for this or that answer. How can this be implemented? I would be grateful for the idea

    1 answer 1

    The "polls" table - contains the fields "poll id" (primary key) and "poll name".

    The table "answer options" - contains the fields "id of the answer" (primary key), "poll id" and "answer variant".

    The table "voices" - contains the fields "id response options" and "number of votes."

    The relationship between the "polls" and "answer options" tables is one-to-many, and between the "answer options" and "votes" tables - one to one.