Course history in an Access database

Navigation
0

My problem is that I am making a database in Access, it is very simple, it only has the tables of Students and Courses, linked to each other, so that the courses group the students. My problem comes when a student changes course, how could I keep in a history the previous courses to which a student has belonged? So that when you add it to the new course it stays somewhere in the course that it was previously.

Thanks

    
asked by Zafiro 15.05.2018 в 08:46
source

1 answer

1

You can create a History table, which has a reference to the student and another to the Course. Something like this:

"Create table history (Date start, End date, int studentId references Students (studentId), int courseId references (courseId)).

It's an idea. Now that you are going to require handling transactions when updating student courses.

    
answered by 15.05.2018 / 19:58
source
Problems with the git push heroku master Responsive problems in Bootstrap