mysql - JSON Type or JOINS on non-queried data

I'm working on an application for preparing and then generating tests for school.
Currently, I have faced the following dilemma - how to most effectively store answers to questions?
At the moment I have a ready table for questions, however, due to the fact that I will not search for answers to questions (tests will not be online only for printing) I have a dilemma how to store them. I have 2 concepts:

an additional table containing individual variants of the response along with their attributes

additional column to the question table in which the JSON structure will be located (I was thinking about a JSON or BIGTEXT type)

There is no limited number of answers for questions so we assume that one question has N answers and I will not search for them in the database.
What do you think about it? (application in PHP, Symfony 4)

1 answer

Good database design rules say that in this case, where you have a 1:N relation, you should create a table that contains all the answers to the questions along with their attributes, like you said in the first point, and then link the two tables with a foreign key.

guys Iam new to php and api and l need some help please! so the thing is that I made a searchbox and I want to connect that to swapi api so whenever I search for a movie I get the movie as a clickable link. What can l do to connect the swapi api to the index. php? how can l search for a movie or name and get results in php?