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

 

One Reply to “Students and Staff Automation System Java Project”

Leave a Reply

Your email address will not be published. Required fields are marked *