Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Object Databases The Essentials

Authors: Mary E. S. Loomis

1st Edition

020156341X, 978-0201563412

Students also viewed these Databases questions