I need help with the following question:
a) I have a table called “student subject” with the following columns: student id, class the student belongs to (15 classes), date representing the time he chose the subject he would like to take (day, month, time , min and s), the course you are currently studying, the first course option to take, the second course option to take, the third course option to take.
b) a second table called “vacancy-per-course” with the columns name of the courses (containing the names of the 15 courses) and the column quantity (amount of vacancies per course).
Table called “student subject”
| student id | student | class | Data | currently | first | second | third |
| 1 | student1 | 1m1 | 26/05/2023 15:25 | D | A | B | C |
| 2 | student2 | 1m2 | 27/05/2023 15:25 | A | B | C | D |
| 3 | student3 | 1m3 | 28/05/2023 15:25 | B | A | C | D |
| 4 | student4 | 1m4 | 29/05/2023 15:25 | B | C | A | D |
| 5 | student5 | 1m5 | 30/05/2023 15:25 | A | B | C | D |
| 6 | student5 | 1m6 | 30/05/2023 15:25 | B | C | A | D |
| 7 | student5 | 2m1 | 01/06/2023 15:25 | D | A | B | C |
| ... | | | | | | | |
Table called “vacancy-per-course”
| course | quantity |
A | 2 |
B | 2 |
C | 2 |
D | 2 |
... | ... |
My objective is to allocate students in these courses considering the time (time) they made the choice and the priority of the course choices (it needs to be different from the course they are currently studying).
In the end, I need a matrix with the allocations, with the name of the student and the chosen course taking into account the priority.
I need help for this problem.
