DER Student Question Theme

Question

I am developing a learning control system, where I will have a database of questions that will be listed in an activity and subsequently answered by students. As soon as the student answers the question, I would like to store whether he hit or missed the question.

The key point of my system is to allow a follow-up of the student’s learning, so I thought I’d store in the bank the number of questions he missed and got right from each topic. My problem is how to demonstrate this in the DER.

Below is my current DER.

Answer 1

If I were you, I’d put the answer in the association Pergunta_Atividade:

+----------------------------------------------------+
|                 Pergunta_Atividade                 |
+----------------------------------------------------+
| IdPerguntaAtividade integer primary key            |
| IdPergunta integer foreign key (Pergunta)          |
| IdAtividade integer foreign key (Atividade)        |
| Resposta integer not null                          |
+----------------------------------------------------+

The calculation of the correct answers would be a INNER JOIN amid Pergunta_Atividade, Atividade and Pergunta, done in the application.

Answer 2

To facilitate your operations, you can create a history table

+----------------------------------------------------+
|                 HistoricoPerguntas                 |
+----------------------------------------------------+
| IdHistoricoPerguntas integer primary key           |
| IdPergunta integer foreign key (Pergunta)          | 
| IdAluno integer                                    |
| IdAtividade integer foreign key (Atividade)        |
| Resposta integer not null                          |
| Correta integer                                    |
| DataResposta date                                  |
| ...                                                |
+----------------------------------------------------+

And with more information than you deem necessary. So you have a table that contains the history of questions and answers, the date, assertiveness, and more what you deem necessary.

Answer 3

In the entity Activity, you can include a field with the answer and even whether it is correct or not, maybe a field for some kind of observation.

And based on that relationship you’ll be able to extract the detail you want for a final report.