Database design
I'm building an app for a center 'school' for Quran teaching and memorization.
I want to track students daily progress and attendees, there is also can monthly tests, each class also can choose best student of the week each week.
For example an admin visits the app dashboard and want to view a student's average attendance for a certain year, or maybe he wants to know how the had progressed in a certain year.
I want to track students daily progress and attendees, there is also can monthly tests, each class also can choose best student of the week each week.
My question is:
how do I link these data to a certain year?For example an admin visits the app dashboard and want to view a student's average attendance for a certain year, or maybe he wants to know how the had progressed in a certain year.