College Sports Management System .Net Project using Asp.net, C#.Net and SQL

PROJECT DESCRIPTION: The College Sports Management System’s objective is to provide a which manages the activity of many sports at a time. It also manages the registration process and announcement of the results.

Modules

Add sports

We can add new sports into the system so that we are able to retrieve them later during the registration process. The sports added would be viewed during the creation of a new intra- college or university tournament.

Add Scoreboard

We add a scoreboard so that the students can view it and the results of each match are announced here so that there will be only one platform for the results. This would reduce the chaos during the score announcement.

Add Tournament

Each tournament from an intra-college or a university can be added here. It later would help in the registration of any sports in that tournament. While adding a new tournament the system would show the set of sports that are entered into the system by the director of the sports so only those sports can be included in the tournament while creation.

Remove Sports

This module will help in the removal of any sports that the sports director thinks are not needed in the system. The removed sports would not be shown anywhere in the system that includes during the addition of a new tournament.

Edit Scoreboard

The added scoreboards would be updated here. This module helps in updating the scores on the scoreboard. Only the scoreboard which is added using the add scoreboard module would be present here and only these scoreboards can be updated. We won’t be able to add a new scoreboard here.

Remove players

This module would remove each player after each round of the tournament. So that only the existing player will be present and the one that is not qualified for the next round would be removed using this module. This would give a clear picture of the qualified players. As well as the player from the college team I can also be removed.

Remove Tournament

After each tournament in the college or a university, we should remove it, so that there won’t be any confusion between different tournaments which are going to be held later on. This module would help in removing all the details of the deleted tournament.

Registration Individual

This module would help in the registration of individual sports events held in the tournament. We selected the tournament in which we want to be part and the sports in which we want to participate in and the player would add his name and the required details asked in the registration form. After all these processes then we can click on the submit button and the student has registered for the tournament that they wish to participate in.

Registration Group

This module would help in the registration of group sports events held in the tournament. We selected the tournament in which we want to be part and the sports in which we want to participate in and the set of player’s names would be added and the other required details asked for in the registration form. After all these processes then we can click on the submit button and the student has registered for the tournament that they wish to participate in.

Payment

This module would help with online payment. So that the students wouldn’t have to stand in a queue or have hard cash in hand in order to do any payment to the sports department. By using this module we are reducing a lot of paperwork and we are giving the students the liberty of doing the payment from wherever they are.

  • This College Sports Resource Booking Project is related to the College Sports Management System Project. You can also visit & download the Android Application project on College Sports Resource Booking

SYSTEM STUDY

EXISTING SYSTEM

The existing system is more of a manual work, where the students have to walk up to the sports department and have to register for the events that they desire to participate, it’s not just the registration process but even other activities such as the announcement of the result, the payment, etc. This results in a lot of paperwork and the chance of the data getting mixed up is high. In the existing System, students are not able to get proper information about the games conducted in various venues. The student needs to spend a lot of time to get the information about the game. The student should attend the venue to get information on the game which takes a lot of time. The information such as the qualified player’s list, the timing of the event, the score of the sports happening, etc.

DISADVANTAGE OF THE EXISTING SYSTEM

  • Involves a lot of paperwork
  • Students have to walk a lot for the registration and other sports-related activities
  • Data getting corrupted is high
  • Human error is common during intra-college and university tournaments.
  • The students need to visit the venue to get all the information about the tournament and would have to wait for a long time.
  • Manually recording all information with regard to all data and manually creating the contest schedules, coordinating facility usage, and hand-registering athletes and teams. The dissemination of information would require that documents be typed, photocopied, and put up on the notice board or common place where students can view them.

You can also visit & download the website project on University Leave and Outing Pass Automated System

PROPOSED SYSTEM

In the proposed College Sports Management System student can get all the information about various games and the venue.

OUTPUT SCREENSHOTS

  • Sports team
  • Adding new tournament
  • Adding new sports
  • Removing sports
  • Removing Players
  • Index page for Registration
  • Registration form for intra-sports
  • Registration form for group events
  • Admin Login
  • Index page
  • Admin Home page
  • Adding scoreboard

You can also visit & download the web application project on Student Activity on Sports System

CONCLUSION

Sport is a part of the curriculum in college. Hence it’s time for the sports department and its activities to be automated and go online as it will be beneficiary for everyone who is associated with sports in college. The “College Sports Management System” project will assist the sports department of the college and would help the students in saving a lot of time in searching for games being conducted in the college. Our project provides students to get register from anywhere and anytime. It helps the administration by streamlining the current intra-college sports event administrative practices. Specifically. It will allow the administrators to configure a set of Tournaments into the system and simply record the results of those contests so that administrators and the public can track the teams during the course of the tournament.

.NET Framework makes the application robust, secure, and reliable. This system provides better scalability and is open to more enhancements. More levels of abstraction can be implemented at the front end and back end, thereby making the system easily adaptable to any changes in the environment.

The software developed was implemented and tested with real data and was found to be error-free. Also, it is found that the system works successfully. The user has to provide their personal detail to buy a package. All the necessary validations are carried out in this project so that the company can make use of this software and the necessary messages make them conscious of the error they have made. Henceforth, valuable reports have been generated for this organization.

You can also visit & download the Java and MySQL-based web Application project on Sports Event Management System

Download the Complete College Sports Management System .Net Project with ASP.Net, C#.Net, and SQL Server.

Hotel Online Room Reservation System Project Proposal

Hotel businesses are one of the top-running businesses all over the world. The hotel business has emerged with massive growth over the last decades. Hotel industries are also one of the main reasons for tourism growth. The section of the service industry that deals with guest housing and lodging are the hotel business. Swagath Hotel is one of those hotel businesses for whom we are going to develop a system to make reservations for customers.

Swagath Hotel business is one of the hotel businesses using a manual system for hotel reservations, bill settlement, and others. Managing the task manually can be very hard and time-consuming. There comes the role of the Room reservation System. The room reservation system helps customers to reserve hotel rooms from anywhere at any time with the medium of the internet.

The room reservation system for this hotel works as the mechanism through which guests can create a secure online reservation. The Room management system is capable of handling various activities like Guest details, Reservation details, invoice details, and many more. This system provides good information sharing to both customers and staff of the hotel. The room reservation system will be the means to eliminate the manual system which then provide faster and more efficient operation in the hotel. The Room reservation system is also considered to offer an efficient, informative, and user-friendly website. Customers will be able to easily make accommodation reservations, for different types of rooms, and select rooms within their range simply by going to the hotel website.

Problem Statement

The problem that our system might face are:

  1. Lack of hotel and hotel website
  2. Inability to match guest
  3. As guests can arrive directly to hotels and reserve rooms and if the admin forgets to set the room reserved in the system it can create confusion and
  4. If the admin does not view the guest reservation and acknowledge them guests might have to wait for a long period to assure that their reservation is
  5. Guest cannot access every detail of the
  6. The guest does not know what the surrounding of the hotel looks
  7. A technical problem like a server down may be another

Objectives

The room reservation system will be involved in the following actions:

  1. To avoid manual and repetitive
  2. To keep track of available rooms and
  3. To create a database where every customer’s detail is
  4. To secure all the data and records.
  5. To provide speed reservation and registration service.
  6. To retrieve records simply whenever
  7. To authorize the users to have access to the records.
  8. To generate a proper
  9. To inform the availability of rooms in real-time.
  10. To provide the ability to reserve rooms anytime from anywhere with an internet

Methodology

For our project on the room reservation system, we will be using the waterfall method as it is easy to manage because of its rigidity.

Working Mechanism of the Room reservation system

Requirement identification

Study of the existing system

The current system of hotel management is fully based on paperwork. All the records of customers and rooms which are available in the hotel are managed by the hotel management through paper. There may be some problems or delays in allocating rooms and providing services by a human. Manually handling the hotel room records, customer details, and other management is hard and time-consuming. While all the records are kept in files they may get torn out, lost, or get damaged due to water or fire. Calculations done by staff may not be accurate sometimes. And even transferring the records or finding records is a big problem and also creates a mess. The manual system of room reservation is also time-consuming as a customer have to visit the hotel first and ask for available rooms then inspect those room then only if the customer like it, he will take the room or else he won’t and for all these processes cost a lot of time.

There are also many hotel booking websites but those websites create competition among the hotels. Those websites also create confusion for customers to choose between many hotels. Those websites may also charge some fee for linking up the hotel site. Those websites may also take paid promotions from the big hotels and refer only those hotels to the customers.

Disadvantages of the existing system:

  1. Time-consuming system for making reservations and recording
  2. Mixing of two or more customers
  3. Recording of data manually is not
  4. A lot of space can be taken from
  5. It may face the problem of human
  6. Possibility of losing customers
  7. Unwanted duplication of the record.
  8. Difficulty in maintaining file security and
  9. Easy access to guest information by unauthorized users.
  10. Reusing and retrieves of guest records are extremely difficult.

Requirement Collection

Functional requirement 

    1. The administrator can check the information of users.
    2. Users have to register and log in.
    3. The system accepts the user registration only if the required fields are
    4. Users can search and book rooms according to their
    5. Booking confirmation should be sent to the user’s email and
    6. Confirmation of room reservations should be stored in a
    7. Users can also cancel the booking without any
    8. The system will be able to display the available
    9. The system allows the customer to check the
    10. Displaying their charges and other

Non-Functional requirement

    1. It is easy to use, efficient, and
    2. It will be developed in such a way that the system is available both day and
    3. Any modification like insert, delete, update, etc. for the database can be synchronized quickly and can only be executed by the
    4. System payment will be accepted via various
    5. The system must recover easily from any kind of
    6. The system must be protected from unauthorized

Feasibility Study

A room reservation system is a system that is highly feasible for these kinds of hotels. This system is being developed after a high-level study of the entire system analysis and design process which helps the hotel in every aspect. The system being developed will be flexible to support the hotel to acquire more guests. There are three types of feasibility studies we kept in our mind for the development of the system for this hotel.

Technical feasibility

The proposed system of room reservation is very technically feasible as we are going to develop the system using existing technology. The required hardware and software for the development of the system are available. The software developed for the hotel management system is used in a client-server architecture where HTML, CSS, and JavaScript are used as the front end and PHP is used as the back end for this project. With every knowledge of working with programming languages, we are going to develop the system.

Operational feasibility

The room reservation system is very feasible regarding the operation of the hotel reservation. The system is just an advancement of the manual system. The main purpose of the system is to provide an online reservation service to guests which is easy to operate and staff to handle that reservation easily. The system helps to promote the hotel and also creates a user-friendly environment for room booking that saves time. The system helps in recording the details and providing invoices for both guests and the staff without having to deal with time-consuming paperwork.

Economical feasibility

The system will help reduce the traditional record-keeping style which will eventually reduce the expense of hotels for registers and files. Keeping records in a digital format is less costly yet reliable. The system also does work alone which requires two or more people to do it. The cost for the development of the system is also one time cost as the system is reliable in the long run.

High-Level Design of System

(system flow chart/ methodology of the proposed system/ working mechanism of the proposed system)

ER diagram

Figure 1: ER diagram

The above figure is of ER diagram, this figure shows the relationship between one entity with another other. Here there are 5 entities with their respective attributes. The guest entity checks for the room while the reservation of the room is made if he/she likes the room. Reservation can only be made if the room is empty so reservation is a weak entity. Payment is allowed when the reservation is made. The employee manages the reservation and also is responsible to check if the payment has been received or not.

Use case

Figure 2: Use Case Diagram

In the figure above, the guest and admin are the actors, and gives are the actions performed by them in the system. Both of them have to log into the system for performing any task. The guest has to insert their details while booking the room which will be verified by the admin when the guest checks in at the hotel. Whenever the guest makes or cancels the reservation admin has to acknowledge it. Guests always check for the rooms before making a reservation. The guest receives the bill and the admin should provide him with the bill. Admin is responsible to establish room rates and also categorize the rooms.

Flowchart diagram

Figure 3: Flowchart diagram

The above diagram shows the flowchart of the user logging into the system for the reservation. When the guest visits the website, he/she sees the home page from where he/she can log in. If the guest is not registered in the database, he/she has to register first then only they can explore the room information given on the website. If he/she likes the room they check for its availability. If the room is available, they have to insert their details to confirm their reservation.

Expected Outcomes

When the project is completed then the users can register and log in to their account in this application and can easily book their choice of rooms in the hotel. This system also helps to minimize the work of the staff by digitally storing records. It also increases the reservations of the hotel. People can book rooms at the hotel from anywhere at any time. The invoices are printed within a second with full accuracy. From this system, we expect to introduce the hotel internationally. The well-developed website creates a user-friendly environment which makes it easy to use the website.

Professor Online Question Paper Submission to the Examination Cell ASP.Net Project

Introduction

Online Question paper submission is a web portal that is developed or implemented in the ASP.NET domain or platform. This project is helpful for the Professor to submit the question paper to the examination cell or to the Examiner from this site. In the current generation preparing the question paper and handovering in the examination cell is not that much security. This project is developed for a Professor to maintain his details, experience, and preparation of question paper and submit the same to the examiner. The examiner also gives his information, experience and takes approval from the administrator, and then selects the question paper. This project will work on the same line of online examinations; Apart from this, it contains much more additional information such as Course type, Department details, and other details of professors and examiners in this web portal.

For the examination cell, it is very difficult to identify whether the particular question paper is submitted or not. The online Question paper submission portal is implemented in 3 main modules. Professor module, Examiner module, and Admin module. Admin module will add multiple courses and departments under different branches so Professor can easily know the best details of about subjects. The professor module ought to register with the application and choose the course and upload the question paper to the site.

Scope of the Project

The scope of the project is used to manage the details of the professor, Examiner, and Administrator. The Professor and Examiners Sign up by providing the appropriate information and then take approval from the administrator. According to course-wise Professors prepares the question papers and send them to the examiner, then the examiner selects the question paper and submits it to the board. And all these records are stored in Online Question Paper Submission Database. 

Design of the Project:

ER Diagram:

Main Modules of the Project

Administrator

 He administrates by giving approval to Examiner and Professor’s Signup. He also creates Courses, Departments, and Designations in order to fetch the correct and appropriate question paper for that course and department.

Course Details

 It is created by the Admin and it consists of Details of specific courses like BCA, BBA, BCOM, and more. The professor sends the Question paper on the basis of the Course.

Department Details

 It is created by the Admin and it consists of Details about the entire department which is created. The Department section consists of the Department name and Address of that Department.

Designation Details

  It is created by the Admin and it consists of Details about the Designation of a particular professor. This section consists of  Designation names like Ass-professor, HOD, and so on, it also has a description section under the Designation name which helps us to know which particular department the professor’s designation is from. 

Professor’s Signup

 In this section, any professor can sign up. But the request is only approved by the Admin. This section consists of the Login name, name of the professor, password and confirms password to confirm, phone number of that particular professor-main ID, and at last the address of that professor.

Examiner’s Signup

 In this section, any Examiner can sign up. But the request is only approved by the Admin. This section consists of the Login name, name of the examiner, password, and confirm password to confirm, and here it consists of designation and department where the examiner can select any of the given designations and department. At last, it asks for the Address and a photograph of that particular Examiner.

Approval for both Professor & Examiner

 This action is performed by the Admin. He approves both professor and Examiner. 

Login for professor & Examiner

 A Professor who has been approved by the Admin can now log in to the Login section and the same for the Examiner too.

Details of Question paper

 Every Question Paper must be sent with appropriate details so as to know more about the paper at a single glance.

View and Edit the Question Paper

 It is viewed and Edited by the Examiner and it is submitted to the University.

Final Reports

It creates and shows all the database records of this project.

Screenshots of Online Question Paper Submission System:

  • Home Page
  • Admin Login Page
  • Admin Main Screen Lists Section
  • Admin Main Screen Create Section
  • Admin Main Screen Approval Section
  • Admin Department list
  • Admin Designation List
  • Course Creation Section
  • Department Creation Section
  • Designation Creation Section
  • Home Screen Signup Section
  • Professor Signup
  • Professor Approve Section
  • Professor Main Screen
  • Examiner Signup Section
  • Examiner Approve Screen
  • Examiner Approve Page
  • User Login Page
  • Examiner Main Screen
  • Examiner Document Viewing Screen
  • Professor New Question Paper Screen
  • Examiner Acknowledgment Screen

Conclusion

It is believed that in the future Online Question Paper Submission centralized document system with the concept of cloud technology will recede in importance as a strategic application to become a competitive necessity that must be adopted by most government departments.

India is striding smoothly towards integrated E-Governance.  In the next five years, situation will be entirely different.  Most companies are adopted cloud technology for the maintenance of documents.

Online Question Paper Submission creates a new trend in maintaining and verifying documents online and it reduces the workload. 

Future Enhancements

  • The news feed is essential for our day-to-day purpose; hence we will add a section about the news. There, we are going to display the news about examination dates, deadlines for submitting papers, etc.
  • We are going to add some more security to our system like an OTP number for verification of the Professor’s and Examiner’s Phone numbers.
  • Authentication of Professor and Examiner is also important, thereby uploading the College Approval Letter by Principal (Signed and Sealed), makes it Admin easy to verify them.
  • We will add a few more Image File Formats such as TIFF, GIF, PNG, JPEG, etc. in order to make Professor and Examiner upload photocopies easily.
  • To make a question paper, Professor has to be experienced; therefore we will add a new section while signing up called Years of Experience. In that section, the professor has to enter how many years of experience he/she has in the teaching profession.
  • Live communication between Professor and Examiner makes it easy to fix the problems; therefore we will add live messaging on the portal.

Download the complete asp.net, vb.net project code, and SQL database on the Question Paper Submission project.

Mini Project on Student Profile Management System using Java

Develop a java based application using GUI to maintain student records. This Student Profile Management application should have a login page. The Student Profile Management should take student details like name, address, branch, previous year scores, and curricular and extra-curricular activities, and all the entered data should be displayed at the end for confirmation.

Project Programming Details –

1) LoginFrame :

Login Frame is GUI based window that is displayed when the user first executes the program. It is the welcome page through which the user will move on to the next frame.
It contains a button with an ActionListener() which on pressing opens Frame2.

2) Frame2 :

Frame2 is the login page. This page takes the user id and password as input and only after successful verification of user the user is allowed to move to the next page.
The default user id password is
User id:- admin
Password:- admin1234

3) Frame3 :

Frame3 is where the user is given the option to enter their details such as name, age, branch, and address and select their gender from the drop-down menu. Each detail to be entered is stored using JTextField() and JRadioButton is used to display the drop-down menu for the gender selection. Finally, there is the submit details button which on pressing triggers ActionListener() and checks whether the user-given input is legitimate or not, if it is not then it pops an alert message that reminds the user to enter the correct details. Once the correct input is given, we pass this information on to Frame4.

4) Frame4 :

Frame4 is where the user is given the option to enter their details such as their previous academic achievements, their 10th, and 12th scores, their average pointer, and their extra-curricular and co-curricular activities. Each detail to be entered is stored using JTextField() and JRadioButton is used to display the drop-down menu for the gender selection. Finally, there is the submit details button which on pressing triggers ActionListener() and checks whether the user-given input is legitimate or not, if it is not then it pops an alert message that reminds the user to enter the correct details. Once the correct input is given, we pass this information on to Frame5.

5) Frame5 :

Frame5 class is where we receive the user input taken in Frame3 and Frame4 and using JLabel()’s we display it on our Java application windows. There are two buttons to either make a new entry or exit. On clicking on the first button, ActionListener() is triggered which calls Frame3(), and thus we can enter details of another entry.

6) Student Details :

This is the final class that contains the main method, which calls the LoginFrame().

The output Results of the project will be:

  • Welcome page
  • Login Frame
  • Credential verification
  • User input
  • User input verification
  • Additional inputs
  • User input verification
  • Displaying user details
  • Making new entry

Thus, using a GUI-based java application we have successfully created Student Profile Management application with a welcome page, and login verification page, which takes various student details as input, verifies them and displays it in the end.
A major advantage of GUI is that it makes computer operations more intuitive and thus easier to learn and use.
Icons are more user-friendly than long command lines. GUIs provide the user with immediate, visual feedback about the effect of each action.

Download the complete project source code on Student Profile Management System.

Employee Data Base Management Project using Data Structures with Java

We are doing a project which is about storing the data (details) of employees of a company or any other industry.

In this project, we are providing many functions to store and manipulate the data of employees such as

  • Storing the details like name of the employee,  ID, salary, date of joining, etc.
  • Adding new employee details to the existing list.
  • Providing the report of required employees.
  • To provide details of a specific employee.
  • To give the sorted list of employees based on name, ID, salary, and date of joining.
  • This project also gives the report of employees with certain specifications.

For this project, we are using a data structure-linked list to store the details of employees, and also we can add details of a new employee to the existing list. We are implementing the method to search for an employee and give details provided his name or ID. In this project, we also have a method to sort the list of employees based on name, ID, salary, and date of joining using different data structures. This project allows users to get the details of a certain number of employees from the list. We can also use this project to get the list of employees with certain specifications like the number of employees whose salary is in the given range.

INTRODUCTION

Our project “Employee Data Base Management”  is an application that we have created that helps to manage the details of employees associated with the company.  Since in a company, there are many employees who have worked or are working, to manage all their details such as their name, ID, date of joining and salary, etc., so to manage these data by conventional methods is cumbersome so we have developed this small application which is very helpful nowadays. This application will reduce the workload in generating the report, maintaining the data, and updating it as per the user’s requirement.

In our project, we have provided two user modes. First is the administrator and guest mode.

In our project, the administrator mode gives the user the ability to

  • Add a new employee’s details.
  • Update the details of an existing employee.
  • Delete (fired from the company) the details of a specific employee from the database.
  • Search for the details of an employee based on name or his/her ID in both working and nonworking categories.
  • Display the list of all employees either in the working or nonworking category.

In our project, the guest mode gives the user the  to 

  • Search for the details of an employee based on name or his/her ID in both working and nonworking categories.
  • Generate a report as the guest user desires for example generating the report in a sorted manner based on name, and ID.

OBJECTIVE

The main objective behind the development of this project is to create software with the following features:

  1. Highly user-friendly
  2. Enterprise independent
  3. Cross-platform
  4. Easy-to-use
  5. Tested system to track unnoticed error
  6. Data entry is restricted to valid domains to avoid errors

We are using the node ENode to form a doubly linked list and in each node, we are storing the details of one employee.

In each node, we are having different fields as follows

  • Left- Address of the previous node
  • Name-Name of the employee
  • ID-Employee’s ID
  • Position-Employee’s position in the company/firm
  • Gender-Gender of the employee
  • Salary-Employee’s annual income
  • Date of join-Date on which employee joined the company
  • Right-Address of the next node

Flow Chart:

IMPLEMENTATION

Class ENode

In this class, we have fields to store the details of employees. In each node, we are having different fields as follows

  • Left- Address of the previous node
  • Name-Name of the employee
  • ID-Employee’s ID
  • Position-Employee’s position in the company/firm
  • Gender-Gender of the employee
  • Salary-Employee’s annual income
  • Date of join-Date on which employee joined the company
  • Right-Address of the next node

Class EList

In this class, we have implemented the following methods

  • addEmp : this method does the job of adding the ENode node of employee details to the list-elist. And also this method is used to add ENode read from the file(“employee.dat”) again to the elist.
  • delEmp : this method does the job of deleting the node ENode from the working employees list elist and calls the method naddEmp and passes the deleted node as a parameter.
  • naddEmp : this method does the job of adding the ENode node of employee details which is deleted from elist to the list-nlist. And also this method is used to add ENode read from a file (“nemployee.dat”) again the nlist.
  • update : this method allows to edit and resave the details of an employee asked by the user.
  • fread : this method reads the data from both files “employee.dat” and “nemployee.dat” which creates a node and calls addEmp method to form the doubly linked list.
  • display : this method displays the list of employees in a display window

Class ESearch

      In this class we have implemented the following method

  • nsearch : this method searches for the entered name and displays the details of that employee. If the name is not found in the list then an error message “The name you entered not found” is printed.
  • idsearch: this method searches for the entered ID and displays the details of that employee. If the ID is not found in the list then an error message “The ID you entered not found” is printed.
  • Salsearch : this method gives the list of employees who all have salaries in the given range. If no employees in the database are having salary within the entered range then an error message “The salary range you entered not found” is printed
  • dojsearch : this method gives the list of employees who joined the company in the specified range of date. If no employees in the database have joined within the entered range then an error message ”No employees joined during this time” is printed.

Class ESort :

      In this class, we have implemented the following methods

  • nsort : this method gives a sorted list of employees based on their names. If there the list is empty then the message “NO DATA EXISTS” is printed.
  • idsort : this method gives the sorted list of employees based on ID. If there the list is empty then the message “NO DATA EXISTS” is printed.

Class EFile :

     In this class, we have implemented the following methods

  • fwrite1 : this method writes the data of list-elist the list into the file “employee.dat” whenever the list is edited. We are using @ as delimiter.
  • Fwrite2 : this method writes the data of list-nlist the list into the file “nmployee.dat” whenever the list is edited. We are using @ as a delimiter.

CONCLUSION

This was our project based on an Employee database management System. We think this system will give a better way for a shopkeeper to maintain his shop. Though every task is never said to be perfect in this development field even more improvements are possible in this system which we have mentioned below and some more improvements can also be done to give a more user-friendly system that can help the shopkeeper more efficiently. This project has contributed a lot to my knowledge that has proved to be a valuable addition for me.

SCOPE FOR IMPROVEMENT

  • All frame objects are created as static hence when we move to the next frame and return back to the previous frame the content of the frame will be stored. Therefore we are using the reset button everywhere.
  • In our project in some of the frames, we have a button PRINT to get the printout of the report generated but we have not given any action to that button.

Download the complete project on Employee Data Base Management.

College Campus Students and Faculty Activities Tracker Java Project

College Campus Activities Tracker deals with the tracking of both student and faculty performance and the activities done by them in and out of the college. This project can help us to know all the activities happening in the college campus area and even get to know who has scheduled the activity. Different certificates of the students based on their performance are generated department-wise and academic year-wise.

Our Students and Faculty Activities Tracker system has two users, faculty and student.

The student will upload their certificates that they have participated in other colleges and the faculty will schedule the activity and upload the respective student’s certificates to those who have participated in the activity.

College Activities Tracker is a java web application that will allow the users (both faculty and students) to upload their documents and intimating each activity (hackathon, workshops, competitions) that they participate in and out of the college with certifications as proof.

And it should also allow the user to register for ongoing or upcoming events through the form and after registration, A successfully registered message should be sent to the user to their corresponding phone number. The faculty must be allowed to check or keep track of student and faculty performance and previews the data student-wise, faculty, wise, section-wise, department-wise, event-wise, and duration wise. And faculty should be allowed to add/update the upcoming event happening in the college.

Results Page of College Activities Tracker

INTRODUCTION

College Campus Students and Faculty Activities Tracker is an application that will aid users in uploading their Documents and intimating each activity that they perform in and out of the college with Certifications as proof.

This is a centralized system that keeps track of students and faculty activities and previews the data student-wise, faculty-wise, section-wise, Department wise, Event wise, and Duration wise. It is mainly used to maintain the data for Department’s weekly report.

Modules of the Project

We have three modules in our Activities Tracker Java Project.

● Admin
● Student
● Faculty

SOFTWARE SPECIFICATION:

Software Requirement:

1. Language – Java (JDK 1.7)
2. OS – Windows 7- 32bit
3. MySql Server
4. JDBC
5. JSP

COVID-19 Data Analysis And Cases Prediction Using CNN Project

ABSTRACT:

Coronavirus ( COVID-19 ) is creating panic all over the world with fast-growing cases. There are various datasets available that provide information on the world affected information. Covid has affected all counties with a large number of cases with a variety of numbers under death, survived, and affected. In this project, we are using a data set that has county-wise details of cases with various combined features and labels.

Covid data analysis and case prediction project provide solutions for data analysis of various counties on various time and data factors and creating models for survival and death cases and prediction cases in the future. Machine learning provides deep learning methods like Convolution neural network which is used for model creation and prediction for the next few months done using this project.  

PROBLEM STATEMENT:

With the increase of COVID-19 cases all over the world daily predictions and analysis are required for effective control of pandemic all over the world

OBJECTIVE:

By collecting data from Kaggle and new York datasets data preprocessing is performed and data analysis is performed on the dataset and a machine learning model is generated for future prediction of cases.

EXISTING SYSTEM:

  • The prediction was performed on COVID-19 cases based on different machine learning techniques which are based on an x-ray data set collected from COVID-19 patients.
  • Disease prediction from x-ray images is done using deep-learning techniques.

Disadvantages:

  • The data set used for predicting disease is different compared to the one we are using for this project.
  • Image processing techniques are used.

PROPOSED SYSTEM:

Using the data set pre-processing is performed on the collected data set and various steps for the deep learning model are performed and prediction of cases is done then data analysis is done on various factors.

Advantages:

  • Data analysis and prediction are performed on textual data
  • Deep learning models are generated for predicting future cases.
  • Data analysis is performed for various factors.

SOFTWARE REQUIREMENTS

  • Operating system:  Windows XP/7/10
  • Coding Language:  python
  • Development Kit:  anaconda 
  • Programming language: Python
  • IDE : Anaconda prompt

Student Feedback System .Net Project

This project is a .net based website which is getting all the feedback from the student through online.

Modules included in the project are below:

  • Admin
  • Coordinator
  • Faculty
  • Student

Output Snapshots and description for the admin, Student and Faculty Modules:

Admin page:

Admin Login Page:

ADMIN HOME PAGE:

ADMIN -> STUDENT REGISTRATION FORM

ADMIN FACULTY REGISTRATION FORM:

ADMIN NO. OF USER LIST:

ADMIN FEEDBACK REPORT AT EVERY MONTH

The percentage is calculated by taking the reference from the no. of students.

ADMIN CHANGE PASSWORD :

Coordinator

  • Homepage:
  • Coordinator Adding subject :
  • Coordinator adding feedback questions:
  • Coordinator View added the subject :
  • Coordinator assign subject to the lecturer

Faculty

Homepage:

Faculty add the student

• Student list who all registered for there course and a particular subject. That should automatically come to the student name in their form.

• And they should select the student who opted for the subject and gives them rights to them to give the feedback.

• The student who are regularly attending the classes they should only give it.

Added student list will be displayed on another page.

  • Student home page
  • Student change password
  • Student feedback form

This questions should automatically come from the coordinator added question list.

If this student doesn’t have permission to give feedback on this subject that should disable those rows automatically.

This complete Student Feedback System project front-end developed using visual studio 2010 backend SQL server database.

Download this Student Staff Feedback System .Net Project Code, Database Files, Attached the latest updated code with all feedback functionalities.

Mechanical Questionnaire System Java Project

Statement of the project

To maintain the questions in the database and develop an Auto Questionnaire to conduct promotional exams for the employees.

Existing System:

  • It is time-consuming and difficult to conduct for every section.
  • At present to conduct any exam question paper is being set manually.

Proposed System:

Questions are generated randomly with the proposed system if we mention the details.

Software Requirements:

Windows OS, JDK, Net Beans with Apache Tomcat web server,  Oracle, Internet Explorer with the latest available Adobe flash plug-in, Rational rose for modeling.

Project Modules:

  • Question Bank maintenance
  • Default Templates
  • Creating a new Template
  • Generating Reports

UML Diagrams:

Class diagram for the System:

Use Case Diagram showing the actions of the administrator:

Sequence diagram for login to the system:

Sequence Diagram for Question bank:

Sequence Diagram for Question Paper:

State Chart Diagram for admin object:

Activity diagram of the system:

Other Output Screenshots:

  • When user login to QB
  • Displaying QB
  • Viewing Questions from QB
  • Selecting to add Questions.
  • Adding Questions.
  • Deleting Questions.
  • Default Templates
  • Open/Save Q.paper in MS-Word
  • Question Paper Generator
  • Open/Save Question paper in MS-Word
  • Question Paper in MS-Word
  • Reports

Download Mechanical Questionnaire System Java Project Source Code

Electrical and Mechanical Shed Planning and Work Distribution System

This Shed Planning and Work Distribution System project have got the scope to develop in other departments of Electrical and Mechanical Shed, like Spares department where information regarding the available spares can be stored in a computer database for faster information retrieval.

Also, there is scope to automate the process of issuing tenders to the unavailable parts of the Electrical and Mechanical Shed through online which is currently being done manually.

We can further enhance the work notification system that has been implemented in the current project through color coding by generating alert boxes in addition to the color coding.

UML DIAGRAMS

CLASS DIAGRAM

Figure 1: Relationships among the classes of Electrical and Mechanical Shed

 Description

The class diagram of the electric loco shed shows the major classes, their attributes and the operations of each class. The operation of each class has the effective utilization of the attributes.

USE CASE DIAGRAM

Figure 2: Behavior of PPO User

Description 

Actors: PPO User

Relationships: Simple Association

USE CASE DIAGRAM

Figure 3: Behavior of Other Users 

DESCRIPTION 

Actors: Other Users 

Relationships: Simple Association

The above diagram shows the behavior of other users. These other users include ADEE, Senior DEE i.e., the administrative people. Other users can Log in, Log out, can view staff attendance, view loco position which includes viewing forenoon position and the afternoon positions, view schedule.

USE CASE DIAGRAM

Figure 4: Behavior of Department Users 

DESCRIPTION 

Actors: Department Users

Relationships: Simple Association

The above diagram shows the behavior of the department users. They can Log in, Log out, can view staff attendance, view loco position, view staff attendance which includes viewing yearly/monthly/daily attendance of a particular individual, creating staff members of the particular department, deleting staff, view loco schedule, change status of the work to completed if the work is completed and to In progress when work is going on, check if there are any works given by the PPO.

SEQUENCE DIAGRAM

Figure 5: PPO Users and Other Users Login

DESCRIPTION

In the above diagram the user’s needs to log in. Users first enter the details and then the corresponding information is retrieved from the database. And when the database sends the corresponding information validation is performed and if the information is available then the user’s logins successfully.

SEQUENCE DIAGRAM

Figure 6: Scheduling Locos 

Description

In the above diagram the PPO user’s needs to schedule the locos. So the PPO users first schedule the locos and the information is stored in the database after which the database is updated. The PPO users then send the schedule to the department. Then the database is updated and scheduling the locos is successfully done. 

SEQUENCE DIAGRAM

Figure 7: Viewing Loco Position 

Description

In the above diagram, the PPO user’s needs to view the loco position. So the PPO users first enter the loco position and the information is stored in the database after which the database is updated. The PPO users then send then can view the loco information.

SEQUENCE DIAGRAM

Figure 8: Viewing Staff Attendance 

Description

In the above diagram, the department user’s needs to view the attendance of the staff. So for this, he first needs to update that information. The Department users first enter the staff attendance details which is stored in the database and then updated. He can then view the attendance successfully when requested.

SEQUENCE DIAGRAM

Figure 9: Departments Reporting the Completion of Work to PPO 

Description

In the above diagram, the department users need to report to the PPO department after completing the work assigned by PPO about the loco. The department user first completes the work given by the PPO and stores it in the database. This is then sent to the PPO department and then the database is updated.

Database Tables 

S.No Field Name Constraint Type
1 Token Not Null Varchar2(20)
2 Name Varchar2(30)
3 Jdate Varchar2(40)
4 Desig Varchar2(11)
5 Dept Varchar2(5)

 Table 1: Staff Table 

S.No Field Name Constraint Type
1 Cdate Not Null Varchar2(11)
2 Token Not Null Varchar2(20)
3 Attendance Varchar2(10)

 Table 2: Attendance Table 

S.No Field Name Constraint Type
1 Cdate Varchar2(11)
2 Locono Varchar2(7)
3 Type Varchar2(1)
4 Pg Varchar2(1)
5 Base Varchar2(50)
6 Comdate Varchar2(11)
7 Age Number(3)
8 Rcdate Varchar2(11)
9 Schedule Varchar2(20)
10 Lsdate Varchar2(11)
11 Place Varchar2(25)
12 Remarks Varchar2(1024)

 Table 3: Locosch Table 

S.No Field Name Constraint Type
1 Id Not Null Varchar2(11)
2 Password Varchar2(15)
3 Dept Varchar2(11)

 Table 4: Login Table 

Source code pages description:

Validate.java
For Validating user authentication based on his user id and password

DailyPos.java
For updating forenoon schedule details

Afternoon.java
For updating the afternoon schedule

Schedule.java
For updating loco schedule information

PLocoInfo.java
For Updating Loco Information and its Important Parts

WorkAllotment.java
PPO Department Allots works with various departments

UpdateWork.java
Departments Updating the work status and reporting to PPO

CreateStaff.java
For Departments Creating their Staff members

DeleteStaff.java
For deleting corresponding staff members by each department

DeleteWork.java
PPO Department deleting allotted works

SecDailyAtt.java
Updating Staff members daily attendance of each department

Search.jsp
Searching for the information of a Loco

Schedule.jsp
Forenoon and Afternoon Schedule Display

GenViewInfo.jsp
Viewing the work being carried out in all the departments

Sections.java
Department wise work display
SecViewWork.jsp
To view the particular work of a particular department
SecShowAttI.java
Department wise generating Reports for Individual Staff members

Download Electrical and Mechanical Shed Planning and Work Distribution System Java Project Source Code and Database.