Question
Construct an Entity Relationship Diagram (ERD) and a Database Schema of the following system description: This system is made to keep the records about the
Construct an Entity Relationship Diagram (ERD) and a Database Schema of the following system description:
This system is made to keep the records about the attendance of the students and the effects that are made by the attendance on the students courses.
The admin can manage all the accounts and the registered users like teachers and students can only manage their own accounts. Teachers can mark the attendance of the students and can also rectify it if it is needed and can also see the students that have less attendance than the required one.
Teachers can see the courses they are teaching to the students and the sections they are taking. On the attendance management system teachers can also send the messages to the sections like when they will be on leave and when will the makeup for the same will be taken.
Teachers can also see the students that have not paid the fees and the students that have not paid the fees can be detained by the teacher for not paying the fees on time.
Similarly, the students have many modules like checking the messages uploaded by their teacher, their result, their test marks, their attendance, their fee status etc.
The difference here is that students can only see this data and cannot make any changes to the data that is shown. This attendance management system can be implemented into N number of schools and colleges without any problem.
Note: Please make the answer as neat as possible
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started