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

Dance Studio Web Project Synopsis

ABSTRACT:

This project Dance Studio is an online website which provides a platform for all age groups to learn and excel in the most amazing and loved field called Dance. It has various famous choreographers available to train the candidates.

It also provides a safe and fun environment that allows every individual in developing skills. Here candidates are given opportunities to take part in various competitions in the studio.

It has some features like:

  • Candidates can register online for their desired dance forms.
  • It has two types of service which are at the studio and at home.
  • There is a limited number of registrations are done under each choreographer.
  • This studio also gives rewards and appreciation for all the winners and also provides a costume for all the candidates.
  • It displays calendar blocked (if two or more candidates register for the same choreographer, at the same time for different locations).

The registered candidates will receive confirmation SMS with required details of choreographer on the registered mobile number but the registration gets canceled if the candidate fails to submit the form within 30 minutes.

Hence, valuable suggestions and comments of all candidates are solicited. The feedback will certainly help us in further improving the studio in the future.

Software Requirements : JAVA, MYSQL, HTML

Assignments and Materials Java Project

ABSTRACT

The main aim of developing this assignments and materials web-based java & MySQL application is to provide a simple way of educational communication between student and the faculty. Here Admin role is to just view and manage faculty and student information if anything goes wrong.

Both faculty and Student has to register themselves into the application and login with registered credentials, Where Faculty can upload the necessary material for the questions to be asked in the exam, where students can view the material which is uploaded by the particular teacher for their teaching subjects, Once the student reads the material and if he is ready for the exam.

The Faculty asks questions for a particular branch and section wise where student give an answer for the particular question and again Faculty verifies the answers and finally, Faculty provides marks for the given answers.

This is a simple way to provide materials and conduct an exam assignment online. With the help of this project, we can reduce the manual work, paperwork, and save time.

We have used Java, NetBeans7.4, JDK 1.7, MySQL 5.5, SQLYog, HTML, JavaScript, and CSS software technical requirements to develop these assignments and materials application.

Modules:

  • Admin
  • Faculty
  • Student

UML Diagrams:

Class Diagram:

Activity Diagram:

Output Screens process details

  • Home Page
  • Admin login
  • Admin Home
  • View faculty
  • View student
  • Faculty registration
  • Faculty Login
  • Faculty Login
  • Faculty home
  • Faculty home
  • Upload questions
  • Upload Material
  • View Student Answers
  • Enter Marks
  • Student reg
  • Student Login
  • Student home
  • View Questions
  • Write Answers
  • View Materials
  • View Marks

Employee Attendance Monitoring System Java Project

ABSTRACT

In this Employee Attendance Monitoring project, attempts were made to register the presence of employees. The main purpose of this java application is to maintain information about the presence that all employees can use in their departments. This web application retrieves the details of the departments assigned to the relevant administrative employees and employees enrolled in the courses from the server with the internet connection and stores them in the database. At the end of the month, when the administrator is needed to attend, attendance reports can directly generate an administrator report view.

Existing System:

In the Existing System, we maintain information manually to maintain the information in manually is also time taken. Calculate the loss of pay is also time taken.

Proposed System:

In Proposed System, we are maintaining all the employees’ information in Their attendance and their salary‘s. In this project Employee’s also can view the Attendance and LOP’S. The Application automatically calculates their LOP’s based on their Salary’s.

Modules:

Admin:

  • Login
  • View Employee Details
  • Add Employee Details
  • Delete Employee Details

Admin Staff:

  • Update the Employee Attendance.
  • Calculate LOPS

Employee:

  • Login
  • View Employee Attendance
  • View Lop
  • Apply for The Leave

Requirements Specifications

Hardware Requirements

  • Processor: Pentium-III (or) Higher
  • Ram: 64MB (or) Higher
  • Hard disk: 10GB

Software Requirements

  • Technology: Java 2 Standard Edition, JDBC
  • WebServer: Tomcat 7.0
  • Client Side Technologies: HTML, CSS, JavaScript
  • Server Side Technologies: Servlets, JSP
  • Data Base Server: MySQL
  • Operating System: Microsoft Windows