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

 

Real Time Hotel Management System Java Project Synopsis

Hotel management System is a real time java project.

Modules implemented in this project are below:

Modules

  1. Super admin Module
  2. Admin Module
  3. Travel Agency
  4. Government

Hotel Management System is SAAS Application; every hotel we will give only username and password they will access our Domain.

Supper admin he creates and deletes and Renewals subscription hotels; travel agency and Government Accounts

  1. Super Admin
  • Add New Hotel/Edit/Delete/Update

Hotel Registration

Auto-generate (int)

Hotel Name

 

State

 

City

 

Address

 

Phone Number

 

Email ID

 

Website

 

Logo

 

Government

 

Manager Details

First Name

 

Middle Name

 

Last Name

 

Gender

 

E-mail ID

 

G.S M 1

Phone no

G.S.M 2

Phone no

Address

 

Photo

     

Operation Details

First Name

 

Middle Name

 

Last Name

 

Gender

 

E-mail ID

 

G.S.M 1

Phone no

G.S.M 2

Phone no

Address

 

Photo

Image

   
       
       
  • View Hotels Export PDF and Excel
  • Create Hotel Users/Edit/Delete
  • View Users/Renewal Users
  • Create a Travel Agency

Travel ID Registration

Auto-generate (int)

Travel Agency Name

 

State

 

City

 

Address

 

Phone Number

 

E=mail ID

 

Website

 

Logo

     

Manager Details

First Name

 

Middle Name

 

Last Name

 

Gender

 

E-mail ID

 

G.S M 1

Phone no

G.S.M 2

Phone no

Address

 

Photo

     
  • View Travel Agency
  • Add Travel Agency User/Block/Renewal subscriptions
  • Add government accounts for Tax Management Every State has own government within one country so we will register there, and then we will create the users
  • Create Users governments
  • View Users/Block and Renewal
  • View Governments/Exports PDF

Billing Module

  • Yearly Hotel Payments billing
  • View paid and Unpaid and Export PDF and Excel
  • Send alert messages Automatic for Billing Payment for Expire
  • Government account payments yearly
  • View unpaid and paid account
  • View income
  • View Profit and Lose
  • Transfer money to Hotels, booked by online or travel agency
  • View unpaid amount for hotels
  • Transfer money from travel Agency Commission
  • Deposit money for Travel Agency
  • View per hotel is accounting statements their Commission
  • View per travel agency accounting reports Only those booked Travel agency their commission

Hotel Management System

  • Create operation users
  • Create cleaning users
  • Create Front desk users
  • Create Accounting users

Extra features

  • Alarm message for expiring Subscription
  • Accounting reports
  • Setup room fees
  • View amount not yet paid by travel agency booked customers
  • View tax paid and Unpaid Payments
  • Expenses
  • View expenses reports
  • Hire Employee
  • Salary payments
  • Income reports
  • Expenses reports
  • Income from travel agencies
  • Income from work in Customers
  • Balance sheet

Travel Agency

Travel agency they make room reservations, and they will see what they have to get commissions and the Money balance they have they cannot Cross their limited if the supper admin give them 500 rupees limited to book they cannot create more than 500 rupees, once they money finish they can ask supper admin to add their accounts some amounts

Governments

The governments they set up the taxi, the governments are within the country so its federal system so we have like Telangana State; and AP state, the hotel in Telangana the tax set up by Telangana governments and they collect the tax according to any person who booked a room per night, while we are registration the hotel we will select the government, so they will only view the hotels who are in their states and they will get tax payment only for that governments,

  • Hotel tax payment
  • View hotels unpaid and Paid taxi
  • Hotel billing tax Statement
  • Pay Billing tax
  • Send an alarm message to pay the tax
  • View Hotels with their details

Automating the Irrigation Process by Analyzing the Soil & Weather Conditions

This is Automating the Irrigation Process by Analyzing the Soil & Weather Conditions Project.

The main aim of developing this Smart Irrigation System IoT project to provide easy irrigation methods to the farmers as per the Soil & Weather Conditions.

In this project, we are using GSM Module (SIM300 Module), this is used to receive text messages from the Android app and it gives the message to the Arduino UNO board.

The Job of the Arduino board is to read messages from the GSM and it will process the output for the motors and it will also tell us the status of the soil moisture, temperature, and humidity in the agriculture field.

Smart Irrigation System IoT project

This project 2 Modes

In Auto mode, it detects the soil and if it is dry The motor will be on and If it is wet then the motor will be off.

and can swich on/off the pestiside motor also.

In Manual Mode, the farmer can switch on the motor manually with the help of the Android app.

Whatever the messages We send via an Android app, The GSM receives and it sends to the Arduino UNO board over serial communication.

from this Arduino we have 2 Relays, Relays are nothing but electromechanical switch. This Arduino giving a signal to the relay board.

The below is the working procedure of the Smart Irrigation System project.

Ghat Road Alerting System IoT Project

This is Ghat Road alerting System Project, The main aim of developing this Aurdino based IoT project is to provide safe & secure journey while travelling to the Ghat roads, Hill Stations, etc.

In this IoT project We are using 2 IR sensors, Aurdino board and blue tooth, status indications LEDs Red & Green.

In a Ghat route When the vehicle is coming from one direction, these 2 IR sensors senses that there is a vehicle is coming and the alert signal is sent to the opposite side vehicle and the same thing can be updated in the Android app also.

When the signal is green it indicates that it is safe to take turn which means there is no vehicle is coming in opposite direction.

These 2 sensors can give input to the aurdino and aurdino will send data to bluetooth and bluetooth send data to android app.

The below is the working procedure of the Ghat road alert system project.

Auto Irrigation System over IoT Project

This is the smart Irrigation system project. With the help of this project, any farmer can able to operate and control devices in the farming land.

We are going to provide auto and manual way of on/off the water pump, Fertiliser pump based on the soil wet/dry conditions.

Android App Operations below:

The farmer can switch on the Water Pump
Can Switch off the water Pump
Switch on the Fertiliser Pump
Switch off the Fertiliser Pump
Automatic Mode

In the Auto mode, it works automatically when soil is dry the motor will be on and once the soil is wet it will off automatically.

In this IoT project, we have soil Moisture Sensor, Comparator Circuit, 2 relay Modules are used for switching on the water pumps, basically relay module is has a small transistor, WIfi Module sends a signal to the transistor to switch on the relay,

The relay will trigger the motor power supply

This wifi module will receive the signal from the android app over the IP address.

The below is the working procedure of the Auto Irrigation system project.