PA
Final Course Project: “Student Database Management”
The group member's name and SID are given below.
SI Name SID
01 Anisur Rahman n0032977033
02 Shayma Sultana n0032581101
03 Sanjib Kumar Shil n0034004663
Sanjib Kumar Shil
International American
University
MIS 560: Database Management Systems
Professor: Prasanth Kalakota
February 22nd ,2024
PA
Introduction
New methods help schools simplify operations and manage student data. A student database
management system streamlines work, reduces personnel, and improves efficiency. It also gives
institutions reliable data to make better decisions.
Database system benefits
The student management system lets authorized individuals see academically enrolled student
records. It simplifies office operations throughout Wilmington College's educational campuses
(Reathor, 2022).
Student Database Management System, a simple application, stores student data in the cloud.
Without the application, staff would have to repeatedly input data for transportation, library
cards, hostel facilities, etc. A student database management system synchronizes data across
departments and makes it instantly available, so employees don't have to input it.
Student database management systems organize test results, progress reports, attendance records,
and medical information. A teacher or other authorized staff member may swiftly review student
information with a few clicks (ŁACHECISKI, 2020).
Entities and Attributes
Various Entities observed are STUDENT, PARENT, ATTENDANCE, ABSENTREASON,
LESSON, TEACHER, SUBJECT, and TEACHER HAS SUBJECT.
Table Description: the list of the courses or programs offered by the school is stored. The table
has 3 columns; (1) STUDENT_ID is the primary key of the table, (2) STUDENT_NAME is the
name of the course, and (3) PARENT_ID is the foreign key of the table.
PA
STUDENT Entity contains the following Attributes.
● STUDENT_ID
● FIRST_NAME
● LAST_NAME
● PARENTS_ID
PARENT Entity contains the following Attributes.
● PARENT_ID
● FIRST_NAME
● LAST_NAME
● POHNE_NUMBER
● EMAIL_ADDRESS
ATTENDANCE Entity contains the following Attributes.
● ATTENDANCE_ID
● LESSON_ID
● STUDENT_ID
● ABSENTREASON_ID
ABSENTREASON Entity contains the following Attributes.
● ABSENTREASON_ID
PA
● REASON
LESSON Entity contains the following Attributes.
PA
● LESSON_ID
● DATE
● TEACHER_ID
● SUBJECT_ID
TEACHER Entity contains the following Attributes.
● TEACHER_ID
● FIRST_NAME
● LAST_NAME
● PHONE_NUMER
● EMAIL_ADDRESS
SUBJECT Entity contains the following Attributes.
● SUBJECT_ID
● SUBJECT
Exam Entity contains the following Attributes.
● SUBJECT_ID
● SUBJECT
● EXAM_ID
PA
Relational Diagram
Figure: 1 shows the Relational diagram between different entities
DBSchema software is used to create the Relational Diagram. Explain about diagram.
Parents Attendance Subject Exam
SUBJECT_ID SUBJECT_ID
PARENT_ID ATTENDANCE_ID
SUBJECT SUBJECT
FIRST_NAME LESSON_ID
Exam ID
LAST_NAME STUDENT_ID
ABSENTREASON_ID
POHNE_NUMBER
Teacher
TEACHER_ID
FIRST_NAME
Student ABSENTREASON Lesson LAST_NAME
LESSON_ID PHONE_NUMER
STUDENT_I ABSENTREASON_ID
DATE EMAIL_ADDRESS
D REASON TEACHER_ID
FIRST_NAME SUBJECT_ID
LAST_NAME
Figure 1: Relationship Diagram for Student Management System
PA
Implementation
I selected MS Access to implement the database. The tables, forms, and reports are created using
MS Access.
Creating tables:
The following diagrams/Figures show the tables created in Access with data. The parent's table
has 5 data fields, the student table has 4 data fields, the Attendance table has 4 data fields, the
Absent reason has 2 data fields, the Subject has 2 data fields, the Lesson has 4 data fields, the
Exam has 3 data fields, Teacher has 5 data fields. All the Figures are given below:
Figure: Parents Table
PA
Figure: Student Table
Figure: Attendance Table
Figure: Absent Reason Table
Figure: Subject Table
PA
Figure: Exam Table
Figure: Lesson Table
Figure: Teacher Table
PA
Form View:
The following Form was created in Access with data. We have created 3 form views.
a. Parents Form
b. Student Form
c. Teacher’s Form
Figure: Parents Form
PA
Figure: Student Form
Figure: Teacher’s Form
Query and Query Reports:
There are 2 queries and 2 query reports have been cheated.
a. Absent Reason Query & Absent Reason Query Report
b. Student Query & Student Query Report
Figure: Absent Reason Query
PA
Figure: Absent Reason Query Report
Figure: Student Query
PA
Figure: Student Query Report
Project goals
The system maintains track of each student's academic progress as well as the courses and
modules they have registered for. The program is distributed because the registration database
administrator centrally saves the data and makes it available to academic staff and administrators
across the whole Wilmington workforce. The method is used by students to look through their
test results. As a service-oriented system, the real system would expose some of its functionality
as a set of services that other applications may utilize.
PA
Conclusion and Summary
In conclusion, a student management system is an essential tool for educational institutions to
manage student information and improve administrative efficiency. Such a system can store and
retrieve student records, manage admissions, track academic performance, monitor attendance,
and automate various administrative tasks. Additionally, it can provide valuable insights through
reports and analytics, allowing administrators to make data-driven decisions to improve the
educational experience. Ultimately, a student management system can enhance the overall
student experience by reducing administrative burdens and enabling educators to focus on
teaching and learning.
Future Work:
There are several potential areas of future work for student management systems, including:
● Integration with emerging technologies
● Personalization of the student experience
● Improving data analytics
● Enhancing communication and collaboration
Overall, the future of student management systems will likely involve the integration of
emerging technologies, the personalization of the student experience, and the continued focus on
data analytics, communication, collaboration, accessibility, and inclusivity.
PA
Reference
ŁACHECIŃSKI, S. (2020). Obsługa danych temporalnych na platformie MS SQL Server i Azure
SQL Database. PRZEGLĄD ELEKTROTECHNICZNY, 1(12), pp.97–103.
Reathor (2022). Ultimate Benefits of Using Student Database Management System.
https://code-boxx.com/school-management-system-erd/
Sharmila, S. and Anusya, A. (2012). Database Design for Scheduling System using
Normalization and SQL. Paripex - Indian Journal Of Research, 3(7), pp.1–4.
https://projectabstracts.com/6933/student-database-management-system.html
