Student School Record Keeping System Application Database Project

Project Background

Efficient management of student-related information becomes challenging for any educational organization when the volume of data and operations over that data increases. Information systems and database systems are the needed tools that help in the efficient management of such large volumes of data. These systems not only manage the data but even help in the easy retrieval and processing of useful information.

Vision

This project work vision is thus to come up with an efficient database management system that is capable of maintaining student records for an educational organization.

Project Objective

The objective of designing and implementing such a database management system is to manage the student records in a proper and organized manner, enable data flow and information flow among various activities related to student information processing, and secure the student data.

The project scope is as follows:

  • To come up with an efficient database management application for student record management.
  • The application shall help to add in student records like their personal information, fees-related information, scholarship-related information, and course-related information, and marks-related information.
  • the application shall allow to edit or delete any student record based on authorized permission
  • The application shall allow generating reports like marks statistics, feed duellist of students, etc.
  • The application shall have access based on authorization and role-based authorization shall be enabled for read and write processes.
  • The key information like payment, a password shall be stored in encrypted form for security purposes.

Value proposition

This database application shall help the educational organization to keep track of all the student records and manage them in more efficient manner. It shall reduce the number of manual errors, do the student record processing task in quick time and thus reduce human effort. It shall enhance the student and teacher experience in generating reports and getting key notifications.

Technical development plan

Existing system makes use of excel based record. These are file based system. The biggest challenge in this system is that there are more duplicate records due to lack of any control mechanisms that control duplicates. Database management system makes use of primary key that is unique and it is capable of identifying any unique record. Thus, it is a way of eliminating duplicates.

The existing system are not user friendly to use as they lack user friendly APIs. With supporting scripting languages like PHP, CSS, Java Script it is possible to come up with interactive GUI. Such GUI helps the user to do the tasks in more efficient manner.

Thus, the proposed system shall make use of the following:

Front end: PHP

Back end: MySQL

Web Server: Wamp server

Operating system: Windows 7 and above.

Development Methodology

The application development shall adopt the Rapid application development methodology and develop the application in small set of task. The objective shall be to come up with a rapid prototype and iterate it as per the testing results. The development process shall begin from starting from system requirements, system design, coding, testing & debugging implementation & maintenance. It shall bean iterative process.

The development tasks shall be small manageable tasks. This shall make project monitoring and management easier.

Requirements Analysis

The first functional requirement of the project is to have an application capable of adding and managing student records.

Thus, application should allow Admin to do the following

  • Add student: to should allow the admin to add student details like name, enrolment id, contact address, course enrolled, subjects, date of birth, address, gender, and other details.
Activity diagram depicting adding or deleting student
Activity diagram depicting adding or deleting student

Figure 1: Activity diagram depicting adding or deleting student

  • Manage student: to allow the admin to view student record, delete existing student record, edit or update any existing student record.
  • The application should allow the admin to add marks, manage marks and generate result
  • The admin can add subject or course details.
  • The application should allow admin to generate lists of students who have not paid fees and those who have availed scholarships.
  • Manage user records and change passwords

Student can do the following:

  • The application should allow student to register,
  • view result and download result

Conceptual diagram

Student record system overall architectural diagram

Figure 2: Student record system overall architectural diagram

Tasks of Student and Admin explained in figure below:

Figure 3: Task in detail

Interview Questions

With front end designer:

  • What entries are needed for a student form wherein details can be entered?
  • What entries are needed for result form so that admin can add marks of the students?
  • What entries are needed for course and subject form?

With back end designer:

  • What columns should be used for a student table, result table, course table, user table and fees tables.
  • Which column should be the primary key to help in unique row identification?
  • How to connect front end and back end?

Tables

Student table:

Student_id

firstname

lastname

gender

age

Date of birth

Contact no

address

City

CourseId

emailid

Password

Primary Key Varchar (10) Unique

Varchar (30)

Varchar (30)

Varchar (30)

int

date

int

Varchar (100)

Varchar (30)

Varchar (30)

Varchar (30)

Varchar (30)

Course table:

Course_id

Coursename

Subjects

Primary Key Varchar (10) Unique

Varchar (30)

Varchar (30)

Subject table:

Subject_id

Subjectname

Course_id

Primary Key Varchar (10) Unique

Varchar (30)

Varchar (30)

User table:

User_id

username

password

role

Primary Key Varchar (10) Unique

Varchar (30)

Varchar (30)

Varchar (30)

Result table:

Result_id

Student_id

firstname

lastname

Course_id

Subject_id

Marks obtained

Total marks

Grade

Primary Key Varchar (10) Unique

Varchar (30)

Varchar (30)

 

Varchar (30)

Varchar (30)

Int

int

Int

About admin

Check Also

Restaurant Management System Database Project using PHP, MySQL/MS Access

The aim of this project is to create a Restaurant Management Database (RMD) is an …

Leave a Reply

Your email address will not be published.