Students and Staff Automation System Java Project

Abstract:

The Project “Students and Staff Automation System Project” targeted for the College Students and for faculty members integrates the transaction management and inventory management of the College for better control and timely response.

The College is provided with better control over the transactions like entering the admission details, maintaining the staff details, providing course and admission details, maintaining fee details.

This project’s main motto is to reduce the effort of the college administrator and provide better service to students and Faculty.

The Basic functionalities of a college are to maintain its information in an orderly manner such as student admission details, staff details, course details and so on. “Students and Staff Automation System ” has enabled to maintain the information on a computerized system.

As a result of this method, the college management has maintained the information in an orderly manner and the information can be retrieved quickly within a less time period.

This system also enables to modify and update the information whenever they require. This application enables the college to maintain the college details in a secure manner avoiding forgeries

Project Introduction:

Student and staff automation system project is database management software with front end data updating using java HTML pages.

Application is developed for colleges and schools for handling data of students and staff in a single database. Admin will upload details of student and queries for new course details.

Admin can update, delete and modify existing data from the database.

Existing System:

In the existing system, students and faculty must visit different departments and wait for department staff to get information about any queries and this will involve different stages of the process moving a file from one department to another.

In this process, students and staff should waste time. In process is a manual process.

Proposed System:

The proposed system works on the automation process where we use software tools to develop an app using Java and MySQL database.

In this system process of workflow from the application process to deliver process will be by online. This process will save time and reduce manual work.

Advantages of the proposed system:

1. Data management is easy and effective.
2. Data management will be easy. Admin or user can view data of any records in a short time by just entering in the search field.
3. Time is taken for report generation and record retrieval is very short.
4. Data security is provided for total records.
5. Any department inside an organization can easily access old and new data in a short time.

Drawbacks in the existing system:

Disadvantages of the existing system are given below which are major reasons for moving to an updated version.
Time delay:
Time taken for processing any type of work for students and faculty is more.
Redundancy:
Information of each user is maintained in multiple tables which will provide redundancy.
Nonuser Friendly:
Since the existing system is not an automated process which is not user-friendly.

Dataflow Diagrams of Context Level, First Level, and Second Level

ADMISSION STUDENT AND STAFF ENTITY RELATIONSHIP DIAGRAM

Data Dictionary

SYSTEM DESIGN:

Hierarchy Chart:

Designing Data Tables:

The following tables are used in the Database:

• Admission
• Attendance
• Fee
• Login
• N_staff_d
• N_staff_exp
• Research
• Result
• Staff_d
• Staff_exp
• Staff_res
• student

Name:     Admission

Purpose:  For storing all the details of students.

Name	Type	Description
Adm_no	Number	Admission no of student
Name	Varchar	Name of student
Gender	Varchar	Sex of student
Region	Varchar	Place of student
DOB	Varchar	Student Date of birth
Addr	Varchar	Student address
Fee	Number	The total fee of student
DOJ	Varchar	Student date of join
A_year	Varchar	Academic year
Course	Varchar	Course of student
Fname	Varchar	Student father name
Occupation	Varchar	Father occupation
Phone	Number	Student phone no
Medium	Varchar	Medium of student

Name:     Fee

Purpose:  For storing fee details of the student.

Name	Type	Description
Sno	Number	Student number
Amount	Number	Total fee
Paid	Number	Fee Paid
Balance	Number	Remaining fee

 Name:   Attendance

 Purpose: For storing attendance details of the student.

Name	Type	Description
Sno	number	Student number
Name	varchar	Student name
Month	varchar	Month
Now	number	No.of working days
Nop	number	No.of present days
Medium	varchar	Medium of student

 Name:   N_STAFF_D

 Purpose: For storing Nonstaff details.

Name	Type	Description
Staff_id	number	Staff id number
Name	varchar	Name of the staff
Experience	varchar	Staff experience
Pay bill	number	Salary of  the staff

Name:   N_STAFF_EXP

 Purpose: For storing Nonstaff experience details.

Name	Type	Description
Staff_id	number	Staff id number
NOI	varchar	Name of the Institute
Experience	number	No.of experience years

 Name:   Research

 Purpose: For storing staff research details.

Name	Type	Description
Staff_id	number	Staff id number
Subject	varchar	Subject researched
University	varchar	University
Guide	varchar	Research guide

 Name:   Result

 Purpose: For storing Student result details.

Name	Type	Discription
Sno	number	Student number
Istmid	number	Ist mid percentage
IIndmid	number	IInd mid percentage
Avg	number	Average percentage
Sem	number	Semester percentage
Result	varchar	Result(pass or fail)

Name:  Staff_d

 Purpose: For storing Staff details .

Name	Type	Description
Staff_id	number	Staff id number
Experience	number	Experience of staff
Subjects	varchar	Subjects handled
Name	varchar	Name of the staff
Research	varchar	Researched subjects
Paybill	number	Salary of the staff

Name:   STAFF_EXP

 Purpose: For storing staff experience details.

Name	Type	Description
Staff_id	number	Staff id number
NOI	varchar	Name of the Institute
Experience	number	No.of experience years

Name:   STAFF_RES

 Purpose: For storing staff research details.

Name	Type	Description
Staff_id	number	Staff id number
Subject	varchar	Researched Subject
University	Varchar	University
Guide	varchar	Research guide

Name:   Student

 Purpose: For storing student. details

Name	Type	Description
Sno	number	Student number
Name	varchar	Student name
Fname	varchar	Father name
Addr	varchar	Student address
Icet_rank	number	Student Icet rank
NRI	varchar	Management category(Y or N)
Caste	varchar	Student caste
Religion	varchar	Student religion