College Student Attendance and Staff Profile System

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:

Class diagram
Fig: Class diagram

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:

Sequence diagram for daily attendance
Fig: Sequence 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:

Sequence Diagram for change password
Fig: Interaction Diagram for change password
Collaboration Diagram for change password
Fig: Collaboration 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 

DATA BASE TABLES Field Data type
Faculty_login_rowid number
Faculty_id varchar2(60)
Faculty_password varchar2(60)

Table 1:faculty_login 

Field Data type
Faculty_profile_rowid Varchar2(60)
Faculty_id varchar2(60)
Faculty_name varchar2(60)
Faculty_dept varchar2(60)
Faculty_course varchar2(60)
Faculty_desg varchar2(60)
Faculty_qual varchar2(60)
Faculty_dob varchar2(60)
Faculty_texp varchar2(60)
Faculty_rexp varchar2(60)
Faculty_iexp varchar2(60)
Faculty_spl varchar2(60)
Faculty_joinyear varchar2(60)
Faculty_emailid varchar2(60)
Faculty_phno varchar2(60)
Faculty_addr_dono varchar2(60)
Faculty_addr_street varchar2(60)
Faculty_addr_city varchar2(60)
Faculty_addr_pin varchar2(60)

Table 2:faculty_profile 

Field Data type
Faculty_status_rowid Varchar2(60)
Faculty_id varchar2(60)
Faculty_name varchar2(60)
Faculty_course varchar2(60)
Faculty_dept varchar2(60)
Faculty_courseyear varchar2(60)
Faculty_section varchar2(60)
Faculty_acyear varchar2(60)

Table 3:faculty_status 

Field Data type
rid Varchar2(60)
dt varchar2(60)
sub varchar2(60)
H71A0XX1 varchar2(60)
H71A0XX1 varchar2(60)
H71A0XX1 varchar2(60)
. varchar2(60)
.. varchar2(60)
…. varchar2(60)
H71A0XXN varchar2(60)

Table 4:f_att_bxxxxx 

Field Data type
Student_rollno Varchar2(60)
Student_joiningyear varchar2(60)
Student_course varchar2(60)
Student_dept varchar2(60)
Student_acyear varchar2(60)
Student_course_year varchar2(60)
Student_section varchar2(60)

Table 5:mic_student_status

System Test Cases & System Test Report

SNO Name Input Expected result Observed Result
1. Giving the wrong username and password Username

And password

Alert message should be displayed Alert

the message is displayed indicating

invalid

username

or

password

2. Registering faculty without proper information Faculty details Alert messages should be displayed Alert

messages are displayed.

3. Inserting attendance into the database attendance Message should be displayed if attendance inserted successfully Message is displayed
4. Click On Sign Out User should be signed out and Login page should be displayed Login page is displayed

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

Java Project on Travel & Tourism Management System

Abstract:

The Main objective of this Travel & Tourism project is to make the travel easy and comfortable for the users right from finding the routes and buses to till the booking of the tickets. In this project, we have two modules, Admin, and user.

Admin in this Travel & Tourism Management System project will log in with the default username and password and admin has authority to add the bus routes and add the travel and assign the route id’s and bus id’s and finally, the admin will add the buses at particular times in different routes. Admin will also add the different travel agencies while adding buses admin will fix the ticket price and the capacity of seats.

Finally, the user will register and log in and the find the appropriate routes and use the route id he will search the bus by giving all details like date of journey and type of seat etc. After selecting the information user will be headed to select seats in a view the selected seats will be displayed as red and then after successful payment the booking confirmation will be shown.

If the user feels any feedback need to give, he can provide feedback to admin.

Existing System:

In the existing system, the user needs to find the bus routes by visiting the travel desks and enquire the information and the user needs to book the tickets manually and there may be a chance of no availability of tickets. So we Proposed this project this will overcome all difficulties.

Proposed System:

In the proposed system, the user need to just login into the application and can find the routes and booking immediately and complete the booking process for a successful transaction.

Data Flow Diagrams:

Context Level DFD and Level 1 Data Flow Diagram for Administrator, Users

Level 2 Data Flow Diagram for Travels, Routes, Pickup Points, Booking Modules

Use Case Diagram:

Activity Diagram:

ER Diagram:

Class Diagram:

Download Travel & Tourism Management System Java Project Source Code, Project Report Documentation, PPT, UML Diagrams and Output Screens.

Java Project on Computer to Computer Learning System

Computer to Computer Learning System

Computer to Computer Learning is the modern way of education, in which the students can get the valuable information through CD’s and Digital Copies. Generally, an existing system the educational institutions provide online material which is one-way uploading and hence the database is limited to a single person and hence the information updating needs time, But in this project, the database was made online so the database was accessible to multiple users. Any Format of information can be uploaded like audio, video, text etc. In this application, there are 3 modules

  1. Admin

Admin can view the institutes and students registered and delete them if he feels unnecessary. Admin can also view the complaints given by students

All the users are controlled by admin. Administrator services are

  1. Approve the institute
  2. delete institute
  3. view students
  4. view complaints
  1. College:

The college needs to register and log in and upload the articles on different topics providing the information and maintains the faculty details and view the responses and requests provided by students.

College is an Organization which can handle the all the student details. The College services are

  1. Registration
  2. Upload Articles
  3. Faculty Management
  4. Update profile of College
  5. Send Responses
  6. send a response for appropriate requests
  7. view request and send feedback
  1. Student:

The student will log in with a valid username and password and he can send a request to college he can view the response from college and he can also give feedback to admin. He can also update his profile.

The Student services are

  1. Update profile
  2. send a request to the college
  3. view responses
  4. and send feedback

Existing System:

In the existing Computer to Computer Learning System, the main problem is the database is maintained at individual such as in excel sheets and hence the system is not available for all college students so we propose the multiple access database systems in this project.

Proposed System:

In Proposed Computer to Computer Learning System, we used Centralized or Multiple access databases and it is automatically updated with the multiple users on the system so this makes the system fast.

Output Screens:

  1. Login Page:
  2. Registration Page:
  3. Clooege Registration:
  4. Student Registration:
  5. Admin Login:
  6. Student List:
  7. College Login:
  8. Student Login:

Architecture Diagram:

Use Case Diagram:

Sequence Diagram:

Activity Diagram:

Class Diagram:

Download Computer to Computer Learning System Java Project Source Code,  Project Report, PPT, UML Diagrams.

Java Project on Computer to Telephony Integration System

In Any Growing Business or organization customers, satisfaction is the most common factor so to accomplish that we need to take the feedback from the customers or else we need to provide a complaint service for customers to solve any errors or problems occurred to them so, we need some call center executives. In this Computer to Telephony Integration System project, there are 3 modules.

  1. Admin
  2. Customer
  3. Employee

1.Admin:

Admin will login with valid username and password after logging admin can add employees and delete employees. Admin can view the Customers registered and generate the reports.

All the users are controlled by admin. Administrator services are

  1. Employee Management
  2. View Customers
  3. Generate The Reports
  4. Check The Feedback

2.Customer:

Customer will register and login into the application and update his profile. He can Submit the complaints and wait for the reply and he can see the status of the complaint and can give the feedback to the admin.

The Customer services are

  1. Update profile
  2. submit the complaints
  3. view complaints status
  4. send feedback

3.Employee:

Employee will login and view and update his details and view the complaints uploaded by the customer and provide a solution and submit reports. He can view and request and send feedback.

The employee is a work which can handle the all the customer details. The Employee services are

  1. Edit profile
  2. view/solve complaints
  3. submit reports
  4. view request and send feedback

Software Requirements 

Operating System: Windows or Linux/Solaris

User Interface: HTML, CSS

Client-side Scripting: JavaScript

Programming Language: Java

Web Applications: JDBC, JSP

IDE/ Workbench: Eclipse with MyEclipse Plug-in

Database: Oracle / MySQL

Server Deployment:  Apache Tomcat

Architecture Diagram:

Admin Use Case Diagram:

Customer Use Case Diagram:

Employee Use Case Diagram:

Activity Diagram:

Sequence Diagram:

Class Diagram:

Output Screens:

  1. Home Page:
  2. Admin Page:
  3. Customer Registration:
  4. Customer Login:
  5. Edit Customer Profile:
  6. Add Employee Details:
  7. Customer Details:
  8. Employee Login:
  9. Update Employee Details:

Download Computer to Telephony Integration System Java Project Source Code, Project Report, PPT, UML Diagrams

Track Machine Management for Railways .Net Project

Railways is a big organization which need to maintain the details of different things like tracks and their material so it is tedious job to maintain all these details manually,in order to overcome this problem track procurement management system is providing the successful tools and techniques to a broad range of activities like maintaining  inventory of the material needed for tracks like bolts,nuts,joints etc…,the project mainly contains the modules like material purchasing,material issuing, stock maintenance, zonal issuing,monitoring of track machines.

This project is about the maintenance of Railway tracks of particular region.

UML Diagrams:

Class Diagram:

Sequence Diagram for Employee, Administrator, Manager & Supplier:

Data Flow Diagrams:

And this project consists of four modules.

  1. Admin
  2. Manager
  3. Employee
  4. Supplier

Administrator

  • Views the details of manager,employee, Supplier.
  • Updates,deletes details.
  • To view the details ,admin should login

  • Admin logins by using user name –admin
  • User type admin
  • Views the details of manager,employee and supplier.
  • These details are stored in database using MS-SQL server 2000 where these data is stored in the form of Tables.
  • Similarly data is stored for manager,employee in database.
  • Admin can add new shipping address Requirements
  • When admin wants to add new shipping address
  • He can by filling the add new shipping address form

Manager

  • Orders material requested by employee
  • Gets the information of material supplied to employee from supplier.
  • Logins by using username,password and Type-manager
  • He can view his personal details, employee details and supplier details.
  • He gets the details of the material supplied to the employee.
  • He can delete employee details from database
  • Approve material
  • This information is given to manager by employee.
  • Received material information is forwarded by supplier
  • When supplier delivers material to employee.

Employee:

  • Third module
  • Logins by using user type-employee
  • Views personal details, supplier details, received materials, requested materials.

Supplier:

  • Sends material to the employee directly
  • Gives information of the material delivered to employee ,to the manager.
  • i.e both manager and employee can view received material
  • Delivers the material from shipment
  • He can view personal details, requested material and send material

SOFTWARE REQUIREMENTS

Operating System      :        MS Windows

Languages                   :        Asp.Net with C#

Database System       :       MS-SQL Server

Download this Track Machine Management for Railways .Net Project Source Code & Database.