Category: BCA Projects

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:     Fee

Purpose:  For storing fee details of the student.

 Name:   Attendance

 Purpose: For storing attendance details of the student.

 Name:   N_STAFF_D

 Purpose: For storing Nonstaff details.

Name:   N_STAFF_EXP

 Purpose: For storing Nonstaff experience details.

 Name:   Research

 Purpose: For storing staff research details.

 Name:   Result

 Purpose: For storing Student result details.

Name:  Staff_d

 Purpose: For storing Staff details .

Name:   STAFF_EXP

 Purpose: For storing staff experience details.

Name:   STAFF_RES

 Purpose: For storing staff research details.

Name:   Student

 Purpose: For storing student. details

The main aim of developing this java application is to provide a complete school or college based attendance management system for students and profile system for staff and management.

Faculty information is to be maintained securely and should be accessible only to the respective faculty and the administrator when required. Student’s daily attendance should be entered by the faculty and should be managed perfectly. In the existing system manually the corresponding faculty will enter attendance details in files. If the administrator or faculty want to know the student information, he must able to search the sheets, this consumes a lot of time. Here the project eliminates that problem and makes the process automation.

The Student Attendance and Staff Profile project mainly focus on maintaining of faculty profile, student daily attendance in which different levels of users are restricted to access the database. We can make the users access the data but they can’t modify or update the database. Only the authorized faculty and administrator can access and update the database. Each faculty and administrator should log in to get the details of the faculty and student attendance.

Objectives of the project

• Complete automation is possible in this sector, which is against the main disadvantage namely time-consuming.
• Can maintain company faculty details and student details.
• Any kind of information based on faculty profile or student attendance can be retrieved within less time.
• Only authorized faculty or administrator can access the database by providing necessary information.

Requirement Analysis

A requirement is a feature that must be included in the system. Before the actual design and implementation start, getting to know the system to be implemented is of prime importance.

We are overcoming the difficulty of maintaining faculty details and student attendance which were manual in the current system and here we generate detailed information about the faculty and students attendance which will save our time to maintain all information and retrieve when required. 

Functional Requirements:

This section describes the functional requirements of the system for those requirements which are expressed in the natural language style.

A faculty member should be able to login to the system through the first page of the application, and he can perform actions like viewing and entering student attendance and can update his profile. An administrator can login into his account and he will update the faculty information.

System Design:

UML Diagrams:

Description:

In this class diagram, we are considering the main classes administrator, faculty, and databases where we mainly perform the operations. Here we are also providing the classes for the interface as the operations can be facilitated easily and this comprises of the many options. And we maintain classes for the faculty to maintain its student details and the faculty details are also maintained.

Interaction Diagram for Registration of new faculty:

Description:

In this interaction diagram, the administrator registers a new faculty member by entering his details in the registration form and updates the database.

Interaction Diagram for daily attendance:

Collaboration diagram for daily attendance:

Description:

In this interaction diagram, the faculty selects a subject and a date and enters the attendance by clicking on the corresponding checkboxes of students roll numbers and updates the database by clicking submit.

Interaction Diagram for change password:

Description:

In this interaction diagram, the user can change the password by entering the new password and validate the password by re-entering it and update the database by submitting it.

Interaction Diagram for faculty details update:

Description:

In this interaction diagram the faculty details will be displayed and he can update the details that are already available in the database from the user interface and the new details entered can be updated in the database.

Use case diagram for administrator:

Description:

In this use case diagram, it includes the main functionalities of the administrator. Here main activity of administrator is to register the faculty, view daily, monthly and cumulative attendance.

Description:

In this use case diagram, it includes the main functionalities of the faculty. Here main activity of faculty is to maintain student attendance, update the student’s attendance and to modify his profile.

Description:

Here the activity diagram explains how the system administrator performs different operations.

Data Base Design 

Table 1:faculty_login 

Table 2:faculty_profile 

Table 3:faculty_status 

Table 4:f_att_bxxxxx 

Table 5:mic_student_status

System Test Cases & System Test Report

Output Screens:

1) Login screen
2) Administrator Profile
3) Change Password
4) All faculty
5) Add faculty
6) Remoce faculty
7) Validation message
8) View faculty status
9) Edit faculty status
10) Add faculty status
11) Select Date
12) Daily attendance
13) Select month for attendance
14) Cumulative attendance
15) Aggregate attendance
16) Report generation
17) Logout Page
18) Faculty Home Page
19) Faculty Profile
20) Update faculty Profile
21) Select subject to view attendance
22) Date wise attendance
23) Cummulative attendance
24) Selection of subject
25) Enter attendance
26) Attendance entered Successfully

CONCLUSION

The project mainly focused on the total computerization of student’s attendance details and faculty profile in which different levels of users are restricted to access the database. By restrictions, we can make the users access the data but they can’t modify or update the database like students attendance, and other information etc.

This project mainly operated by two modules mainly faculty and administrator. The administrator can view the details of the students like marks view. The faculty members can view, update, add and delete the student’s attendance. This approach has features such as less manual intervention, data security is high and confidentiality can be maintained. The user can access the student’s details within less time.

Installation Steps:

• Install Java (Java Run Time Environment)
• Install Apache Tomcat with port number 9090.
• Install Oracle 10g with port number 8080.
• Create new system DSN with data source name: project & Username: project
• Copy the project folder to c:\tomcat 6.0\webapps
• Load the database from a backup file.
• Open any browser and type the following address
• http://localhost:9090/project/login.html
• Now use the login credentials to log in and continue.

Login Credentials:

Oracle 10g:

Username: project
Password: project

Login.html:

For administrator-> Username: admin password: admin
For faculty-> Username: 101 Password: 101

DSN: project

For attendance the database is available for the following details:

Please select these from the list:
Class: IV c.s.e Section: A or B

Download College Student Attendance and Staff Profile System Java Project Source Code and Database