New to java development. Using Spring Boot and Spring JPA to develop a web app.
We have the following data model.
Student – ID, Name, Grade
Course – ID, Name
StudentCourse – ID, StudentID, CourseID, StartDate, Status
StudentAttendance – ID, StudentID, CourseDate, AttendaanceDate, Status
StudentCourseGrade – ID, StudentID, Attempt, CompletionDate, Grade
There are a few more tables as well. All the tables will have StudentID as the referential key.
Have created JPA repository for all the tables. We use single sign on for the student logon. Hence the StudentID will be available in the context. After logon, the student should query only his own data. For example, when the student queries the courses (StudentCourse), he should be able to view only his own courses. Also, when a student joins a new course (StudentCourse), the StudentID should be automatically applied. This is applicable to all tables containing StudentID. What is the best way to implement this in a generic way for all the tables containing StudentID? Pointers to documentation will also be helpful. Thanks in advance.
Developer is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.