School admin system db
Hi, I am trying to create a basic school admin system for internal use only. What I am trying to accomplish for now is to allow certain staff to enter comments into the system regarding the student's community service, special achievements, Sporting achievements, and a comment from their head of grade. Once complete, I want to generate a report per student with their relevant comments.
The problem I have in designing the db is how to hold info as each year rolls over? certain info, like community service, needs to reflect over a 3 year cycle. The year-to-year roll-over is my biggest problem, particularly when I want to add in the features for student marks, how do I design the db to retain the student marks and comments when year to year the student changes grade and possible subject choice too.
To be clear, I am trying to design it in 4th normal form prior to coding the front end. The marks and comments are all dependent on which subjects are chosen by a student, and all that is needs to be reported on a quarterly basis per year.
thanks
Subject
Written By
Posted
School admin system db
October 18, 2021 03:45AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.