Attendance Management System (ERD) Entity Relationship Diagram

Attendance Management System (ERD) Entity Relationship Diagram in DBMS

Attendance Management System ERD – Hi there Itsourcecoders! I will discuss to you the Attendance Management System Entity Relationship Diagram (ERD). This simple database design will give you deep understanding about Attendance Management system database project with tables on how would it handle or store the given data. This will also teach you in managing Attendance Management as well as the relationships of tables in Attendance Management system project database design. And if you like to have a reference for your project making, you can have the PDF copy og this Attendance management system ER Diagram.

This Entity Relationship Diagram for the Attendance Management System project with data table, will also give you ideas on how to make a database design with ERDtables, and schema.

The idea presented in this ERD can be used for your own Attendance Management system final year project. You could also enhance the ER diagram for a system in this article to meet your desired system requirements.

What are included in this ERD for Attendance Management System Database projects 2021?

  • Attendance Management system Description with Features
  • Attendance Management system database tables
  • Simple diagram for Attendance Management system
  • ER Diagram for Attendance Management System

Attendance Management System ERD Description

This  Attendance Management system database design was made based on managing attendance requirements. The system can secure and monitor the attendance of students. The school admin can have access to the students’ status during checking of attendance. all in all, they can handle and update the student attendance.

The features included in this Management system’s ERD were the security and monitoring of the student attendance records and status. These features were also listed and recorded in reports that served as the history of attendance checking done in the system.

ER Diagram For Attendance Management System With Tables and Features

Time needed: 5 minutes.

Here’s the processes included in simple database design for Attendance Management system ER Diagram.

  • Attendance Management

    It is the main feature of the system wherein the designed ER diagram contains the basic details in attendance checking of the students. The design will show the specific database that are needed in processing the checking of attendance.

  • Student Management

    This feature plays a big role for the system because this gathers the important information of the student. These information were stored to the student database and the data will be used during the attendance checking.

  • Manage Attendance Information

    The attendance information management was important for the system because it serves as the basis for the whole attendance reports. This will also help in calculating the number of student absences for the School year or semester.

Attendance Management System Entity Relationship Diagram Tables

These tables below provide the complete database tables details such as Field NameDescriptionsdata typescharacter lengths.

Table Name: Student

FieldDescriptionTypeLength
stud_ID (PK)Student IDInt11
fname Student First NameVarchar255
lname Student Last NameVarchar255
gender Student GenderInt11
age Student AgeInt11
contact_addContact AddressInt11
stud_email Student EmailVarchar255
stud_pass Student PasswordVarchar255

Table Name: Subject

FieldDescriptionTypeLength
subject_ID (PK)Subject IDInt11
subject_nameSubject NameVarchar255
course_ID (FK)Course IDInt11
stud_ID (FK)Student IDInt11

Table Name: Course

FieldDescriptionTypeLength
course_ID (PK)Course IDInt11
course_nameCourse NameVarchar30

Table Name: Present

FieldDescriptionTypeLength
present_ID (PK)Present IDInt11
stud_ID (FK)Student IDInt11
subject_ID (FK)Subject IDInt11
dateDate PresentDate

Table Name: Absent

FieldDescriptionTypeLength
absent_ID (PK)Transaction IDInt11
stud_ID (FK)Student IDInt11
stud_ID (FK)Student IDInt11
dateDate of AbsentDate

Table Name: Reports

FieldDescriptionTypeLength
report_ID (PK)Report IDInt11
stud_ID (FK)Student IDInt11
absent_ID (FK)Absent IDInt11
present_ID (FK)Present IDInt11
total_absentTotal AbsentInt11
school_yrSchool YearInt11
course_ID (FK)Course IDInt11

Entity Relationship Diagram for Attendance Management System

ER Diagram of Attendance Management System shows the system entity relationships in each entity and their supposed functions in each relationship.

Sample ER Diagram for Attendance Management System Project

ER Diagram for Attendance Management System
ER Diagram for Attendance Management System

Based on the image above, the Entity Relationship diagram for this System is the entity of the Attendance Management system database, which is presented by tables.

The tables are made to meet the required specification of the system and provide much more specific details of each entity within the system.

You can now have the PPT and PDF file of the Attendance Management System ER Diagram for you to have your own copy and basis for your future studies in DBMS.

Conclusion

So that completes our discussion about ER Diagram project fellas, and I hope that this article about ER Diagram For Attendance Management System Database Design 2021 will help you a lot.

Now let me ask you something. What have you learned through the discussion?

May this article help you with your projects in the future!

If you have inquiries or suggestions about Entity Relationship Diagram (ERD) for Attendance Management System just leave us your comments below.

Keep us updated and Good day!

Related Articles:

Leave a Comment