Hello,
Can you please guide me through the process of creating a custom database table to store the grades of all the individuals with respect to questions.
The table should be:
| Q1 | Q2 | Q3 | Q4 | Q5 | Grade | |
| Student 1 | 1 | 0 | 0 | 1 | 0 | 2 |
| Student 2 | 0 | 1 | 0 | 1 | 0 | 2 |
| Student 3 | 1 | 0 | 0 | 1 | 1 | 3 |
| Total No. of student answered | 2 | 2 | 0 | 3 | 1 |
Also, i would like to know if there is a way to connect to that table and access the data through ODBC/JDBC? If so, pls tell me the procedure.
Thank You
-Sudarshan shetty