A DBMS Project on Fingerprint-based Attendance System

In this Fingerprint-based Attendance System Database management System project, we have tried to use the knowledge that we gained in this course to make a Fingerprint-based Attendance System. Although we had aimed to implement it using hardware due to hardware constraints, we have tried to implement it online. In this DBMS system, the Faculty for a particular course switches ON the system, and the system marks attendance for the students based on their fingerprints.

Features:

This system apart from marking attendance also maintains the student’s records and the faculty members. We have tried to incorporate the following features:

Administrator: For the modification of crucial information we have created an administrator account. The Administrator only has the privilege to add/remove courses and edit profiles of students and faculty members.

Login Page: On this page, the students and faculty members can log in to their accounts and view their information.

Register Page: For students and faculty members who don’t have their accounts can create their accounts by clicking on REGISTER on the login page. The register page asks for data and creates a profile.

Timetable: This page displays the schedule of all the courses.

Attendance: On this page, a list of the currently running courses and their respective faculty is displayed. There is a slot for the faculty fingerprint. Once the faculty fingerprint matches with any one of the faculty members whose name is being displayed on the page the system automatically turns ON the database to be modified. Now the students are required to input their fingerprints and their attendance is marked.

Tools used:

  • Database Management System: MySql
  • Server for hosting the project: Apache Tomcat with port number 8080.
  • Programming scripts: Java Server Pages, Javascript, HTML, CSS.

Relation to the course:

This whole project like many other projects has two ends. The Front end consists of the GUI which has been made using our prior knowledge and the Back end consists of database interaction which we have learned in this course. We have tried to incorporate the following things that we have learned in this course.

ER Model: The basic thing that we did before starting with the project was to make an ER Model and check the feasibility of the project. This helped us in enlisting the various aspects and classify them into entities and relations.

MySql Queries: In this project we have tried to incorporate the different queries such as Insert, Create, Update, and Alter that we learned in this course.

Triggers: To let the student know about his short attendance we have tried to incorporate the concept of triggers.

System Time: We have tried to fetch the system’s current time and have used it to compare it with the time of the lectures stored in the database.

Conclusion:

While working on this project we brushed upon the knowledge we gained in this course and the hardships and problems faced in implementing such a real-time project helped us learn a lot.

Online Restaurant Food Ordering & Management System Python Project

Online Restaurant Food Ordering & Management System works as a restaurant hub where people can browse and order food online easily. Nowadays, many people especially the young generation, often want to order food from restaurants online with a home delivery service. Thus, we built a restaurant management system where all the restaurant’s information and services will be available. We also offer deliverymen will deliver the food as well, in case a restaurant does not have delivery support.

Users of the Project

This Online Restaurant Food Ordering & Management System has four (4) kinds of users. They are:

  • Customers
  • Restaurant Managers
  • Restaurant Branch Managers
  • Deliveryman

Apart from the users, there is a superuser named admin. Anyone can connect to the system as a customer, restaurant manager, or deliveryman. admin will verify the Trade Licence No. and many other details of a restaurant before connecting it to the system. Similarly, a deliveryman will also get checked by the admin about whether s/he is capable enough to work as a deliveryman.

Project Features

Many features are implemented in the project. Among these, the key features of our project are as follows.

  • Dashboard for the restaurant managers
  • Search and filter food items
  • Our delivery module
  • Bi-directional rating system between deliveryman and customer
  • Offers and Discounts
  • Rating and review submission system

User Guide

This is a sample user guide that will work as a walk-through of the major functionalities of the Online Restaurant Food Ordering & Management System website. As mentioned above, there are 4 kinds of users in this system. A user guide is provided for each kind of user below.

Customer User Guide

Restaurant Homepage

Most of the users of the website will be in this category. Initially, a customer will be able to browse through the website even without a login. Thus, every time a customer enters the website, the customer home page will be loaded.

Customer Location Prompt

But when the customer will try to order something from the website, a location prompt will appear.

Customer Registration

After entering the location, the customer will be able to browse the website as before but cannot order until login/register is done.

View Restaurants

While browsing the items, a customer can filter the items via many different search categories. Among these, on the Restaurants page, a user will be able to see only the restaurants that are close to him/her.

Browse Cuisines

Also, on the Browse Cuisines page, a user can browse items based on many filters and search options. For example, a user can filter the items based on ratings on the items, price range, etc.

Branch Unavailability

Depending on the location, restaurant branch availability will be determined and some of the restaurants may not be able to deliver to the intended location of the customer.

Adding food to cart and Checkout

After browsing, customers can order from a nearby restaurant, check out the cart, and then the customer will be taken to the checkout page where delivery details will be asked for.

Payment method

Customers can use either cash on delivery or an online payment method.

Order Placing notification

At this point, an order has been placed. Now it will be approved by the restaurant manager. Usually, the manager approves the order within a short time. By this time a notification will appear stating that the order has been placed and sent to the restaurant authority.

Rate the Deliveryman

By this time the customer can browse through the website and wait. As the order information keeps getting propagated, the customer will be getting notifications for his order. Once the deliveryman arrives with the order, the customer will be able to rate the deliveryman for the service on the homepage.

Rate and Comment Items

Also, a customer can rate a particular item of a restaurant by clicking on View Item in that item while browsing. S/he can also provide feedback as a comment.

Restaurant Manager User Guide

Manager Register

A restaurant manager will need to open up an account as a restaurant manager on the website. The registration form will look like this. When the admin approves the request, an email is sent stating the activation of the account.

Restaurant Manager Homepage

On the restaurant manager’s homepage, there will be a key to identify the restaurant. This key will be used for opening up the restaurant branches.

Restaurant Branch Creation

Opening up a restaurant branch is just the same as opening up a new restaurant. On the restaurant register page, there is also an option to create a restaurant branch. Providing all the relevant fields along with the restaurant key from the restaurant manager homepage (mentioned above), a new branch of the restaurant can be created.

Add Items

A restaurant manager can add items to his restaurant. In the Add Item tab, the manager will be able to introduce a new item in the restaurant.

Manager Dashboard

Also, a manager can see the restaurant statistics on the Dashboard page. The Dashboard page contains many of the common statistics which will help him understand the restaurant sales progress. Outlet revenue, sales trends in different branches, etc. are shown on this page.

Restaurant Branch Manager

A restaurant branch manager will be in charge of a branch of a restaurant. So, his role on this website is also different from a Restaurant Manager. When the restaurant manager sets up the profile for the branch manager, she/he can manage this branch independently.

Item Availability in the branch

The Branch Manager can declare which items are currently available on the homepage.

Add offer

The Branch Manager can add offers on an item by clicking on that item.

Manage and Accept Orders

This is the most important task of a branch manager. Whenever a customer orders something, the order request comes to the branch manager who has to accept it and forward it to the deliveryman.

Deliveryman User Guide

In our system, anyone can become a deliveryman if s/he is willing to be. Anyone can open up a profile on the website as a deliveryman, but it will need approval from the admin.

Deliveryman Register

While opening an account, the delivery man has to assign himself/herself to one of the zones. S/he will be getting deliveries for that zone only.

Deliveryman Homepage

Once logged in, a deliveryman’s homepage will have currently pending requests of orders in his/her zone. To take an order for delivery, the Take Delivery button is to be pressed.

Complete the Delivery Process

Then, that order entry will be updated and will be waiting for the delivery man to pick up and deliver. Once delivered to the customer, the deliveryman needs to press the Mark As Delivered button. This will also prompt the deliveryman to rate the customer for his/her behavior.

Previous Deliveries

For a deliveryman who has been on the website and delivered many orders, s/he can check all his/her past deliveries in the Delivered Order.

Tools and Frameworks

Frontend

HTML, CSS, Bootstrap
Javascript, Angular JS, JQuery, Google Maps API

Backend – Django

Database – Postgresql v10.2

Specifications:

  • Web Framework: Django 2.2
  • Database Server: PostgreSQL 12.3

Visit Here and download the complete Online Restaurant Food Ordering & Management System Python Project

Design & Development of Student Database Management System PHP Project

The purpose of implementing the ‘Student Database Management System’ is for the ease of maintaining student-related data on an institution, our system does serve this purpose and also is a means of communication between the students/parents and teachers during times when physical contact is not possible or when it is necessary to convey an important message quickly, due to this system a lot of paperwork, maintenance, space, time are all reduced for the purpose of handling large student data.

The goals achieved by this project are:

  • Centralized Database.
  • Reduced paper works and Stacking of files.
  • Easier Searching, Updating, and Storing the Details
  • User-Friendly Environment.

Along with the existing features, additional features can be added in the future, Like:

  • Handling admission details in a more detailed manner by Adding a payment feature through our site.
  • Extension of the current system for the entire institution.
  • Better interaction between the parents and the teachers.
  • Storing the records of co-curricular activities.
  • Assigning and reporting the assignments and many more.

Output Results:

  • Welcome Page with Register and Login Page

Teacher View

  • Teacher Home Page
  • Admit, Update Student’s details for a Specific Class
  • Fetch or Search the Student Details Using the Student ID
  • Admit or Add new Student Details to the Specific Class
  • Add or Update the Subject with its Instructor’s Details
  • Announce Upcoming Events and Circulate the Same
  • Update Attendance for each student in the Class
  • Update Internal Assessment Marks for each student
  • Update Exam Marks for each student

Student View

  • Student Home Page
  • View any Recent Announcements made by the specific Subject teacher
  • View Subject Details and Contact information of the subject teachers
  • View Internal Assessment Marks for each Subject
  • View Final Exam Marks for each subject
  • View the Attendance details

SOFTWARE REQUIREMENTS

  • Database Support: MySQL 5.7
  • Web Browser: Google Chrome
  • Coding language: PHP, HTML, CSS, JS.
  • Server Deployment: Apache Server, MySQL Server.

Download & Deploy the complete Student Database Management System Project PHP & MySQL Code, Project Report, and Execution Steps readme file.

 

Design & Development of Tender Management System Project

Abstract:

The Tender Management System was developed to enable the vendors to get all the tender details online and provide a facility to submit the tender. This Tender Management System project was developed & designed with Java & MySQL Database.

Existing System:

  • Contractors need to submit their documents by visiting the office or centers on time.
  • Contractors have to bid for a particular tender on time by applying forms and need to wait for an approval reply.
  • The Admin Needs to post the Projects or contracts as a poster or advertisements regularly.
  • It takes a long time to access tenders or vendors’ data access.

Proposed System:

  • User Needs to Have a Network Connection.
  • New User needs to register a new vendor on the website.
  • Contractors can log in and bid for some existing tenders.
  • They need to log in using their login-id and password which they used while registration
  • To reduce paperwork, and data that are available online, using this final decision can be taken by the administration and can contact directly to such suppliers.
  • Easy to access the tenders and vendors’ data.

Software Requirements:

Language: Java
Web technologies : J2EE (JDBC/Servlets/JSP)
Front-end Design : Html, CSS, JSP, Bootstrap
Database: MYSQL
Scripting: JavaScript , CSS

Application Work Flow

Modules:

Administrator

Uploading advertisement documents
Verifying projects and contractors by using their information
Accepting and Rejecting Bids
Maintaining data and confirmation of the final report.
Update Notice Board
Make some announcement
Block or unblock some vendors or company

Company

The Company needs to get registered to proceed.
The company can log in with a valid username and password.
Apply or releases new tenders and view the status of the tender.
Make Some announcements.
Change the tender details
Documentations

Vendor

Vendors are the key persons or contractors who look for new upcoming tenders on the website
Vendors’ Functionality includes:
New Vendors can register
Login using vendor-id and password
View and update their profile
See the new open tenders and their details
Bid for a tender with an amount greater than its base price
See the bid approval or denial status

After the tender status approval, they can view and submit the documentation
Vendors can look for the important notice in the notice section

Conclusion

Our Project Tender management System Successfully Created a user-friendly environment for the tender management process.
This Project is flexible and changes can be incorporated easily.
Easy for further Modification
Saves a lot of time by doing most of the processes online
It may lead to increase profit and improve the quality of a company.
Assigns the tenders and project in a good manner and optimal way to the contractors in less time with low-cost charges.

Download the complete Design & Development of Tender Management System Project using Java, MySQL, HTML, CSS, JavaScript, Bootstrap, and J2EE.

Design & Development of Online Examination Management System Project

This project is aimed to reduce the manual work involved in data maintenance in Online examinations and automates the Online Examination Management System. This project is developed mainly to simplify the manual work and allows smooth administration of the operations of an Online Examination.

The purpose of the Online Examination project is to computerize the administrative operations of an Online Examination System and to develop software that is user-friendly, simple, fast, and cost-effective. It deals with the collection of, Subject, Test and Exam information, etc. Traditionally, it was done manually. The main function of the system is to conduct exams online and reduce the delay of results.

The Online Examination System is developed using HTML and MySQL fully meets the objectives of the system for which it has been developed.

Modules:

ADMIN: The admin is responsible for Exam conduction.

USER: The USER takes up the test by signing in and login in with his valid Login id and password.

SUBJECT: The user has options to take up a quiz on a particular subject on the list.

TEST: The user gives the examination for the subject he/she has selected. Formal testing often results in a grade or a test score.

QUESTION: The user selects the answers which he/she feels are correct and selects an option.

USER ANSWER: It stores all the correct answers to the questions which will be stored by the admin.

RESULT: It displays all the scoring made by the User after taking up the test.

Output Results:

ADMIN SIDE

  • The admin is required to enter their respective Login id and password for them to login into their respective portals.
  • Has the option to add subjects, add tests, and add questions.
  • Admin is provided an option to add a subject.
  • Admin adds test details.
  • Admin adds the questions.

USER SIDE

  • The student logs in with his valid log in ID and password.
  • The user has to Sign up before he has to log in.
  • The user takes up the quiz.
  • The user has the option to take up a quiz on a particular subject on the list.
  • The user gives the examination.
  • The user gets results based on his performance.
  • Shows the right answer.
  • Result sheet of all users.

Chess Game Project using HTML & Java Script

The objective of the project:

The objective of our Online Chess Game project is to create an online Chess game that enables you to both play with your friends as well as against the computer.

Chess Game Rules:

  • The player with white pieces starts his turn first.
  • The Player has to protect his king and subsequently make strategies to kill the opponent’s king.
  • When the king of one player is checked by the other player’s pieces, he will have to take the king out of that check to a safe place. The player who checks the king has to warn the opponent by saying “CHECK”.
  • The one to lose his king will be the one to lose the game.

Features:

Player vs Computer:

The player will have to start with whites and make her first move, and the computer will take blacks.

Player vs Player:

The player who takes whites should start first and the other player plays alternately.

Main Functions in Player vs Computer code:

1 updateSquarecolor()
This function is used to update the colors of each square after each move.
2 checkBlack(n,values)
This function is used to find all the possible places where a selected white chess piece can be moved in this step.
3 checkWhite(n,values)
This function is used to find all the possible places where a selected black chess piece can be moved in this step.
4 checkmate()
This function is used to check if there would be a danger to your king if you make any move and declares you to have lost.
5 check()
This function is used to make your moves, if possible, and also to warn the player if the king is in check and the player is not trying to protect it, by the use of the checkBlack and check white functions described above.
6 chooseTurn()
This function is helpful for the computer to play its move by moving forward with the best possible move. It also declares the player as a winner if there is no possible move for the computer to make while protecting its king. It basically
helps in the propagation of the game step by step.
7 startTime()
This function is to show the current time and day.
8 maxxTime()
This function is used to check the time limit for each move and warn the player after 45 seconds and stop the game and declare him to have lost after 1 minute.
9 maxxTime2()
This function is used to check and stop the game at a maximum time limit of 45 minutes and the game would be declared drawn.
10 restart()
This function is used to restart the timer after each move.

Main functions in Player vs Player code:

1 updateSquarecolor()
This function is used to update the colors of each square after each move.
2 checkBlack(n,values)
This function is used to find all the possible places where a selected white chess piece can be moved in this step.
3 checkWhite(n,values)
This function is used to find all the possible places where a selected black chess piece can be moved in this step.
4 checkmate()
This function is used to check if there would be a danger to one’s king if they make any move and declares him to have lost.
5 check()
This function is used to make your moves, if possible, and also to warn the player if the king is in check and the player is not trying to protect it, by the use of the checkBlack and check white functions described above.
6 startTime()
This function is to show the current time and day.
7 maxxTime()
This function is used to check the time limit for each move and warn the player after 45 seconds and stop the game and declare him to have lost after 1 minute.
8 maxxTime2()
This function is used to check and stop the game at a maximum time limit of 45 minutes and the game would be declared drawn.
9 restart()
This function is used to restart the timer after each move.

Installation:

Download all our files and put them collectively in a folder named “Chess”.

In Ubuntu:

Now put this folder into the /var/www/HTML/ folder in the other locations on your computer.

In Window:

Download XAMPP on your PC and put this folder into the htdocs folder of XAMPP.
Now go to your web browser and type localhost/Chess/
Best viewed in Google Chrome and Mozilla.
Download the Chess Game HTML project Code & Report

Student Project Portal Website Project

Whether you are a fresher or a senior, you’ll agree that making a project is quite a tedious task. No matter how great an idea you have, till the time you don’t have a proper network, you won’t be able to build a team to execute it efficiently. Communicating with others is one of the most important skills required to build a proper team for your project to be successful. Unfortunately, many people due to their lack of networking skills hit a blockade at this stage itself and are not even able to try their idea.

Target audience

Our target audience for this Student Project Portal project is all the students in VIT Vellore. This application will help students to take part in any project they like or find interesting and can make their team.

This Student Project Portal application will bring students with similar interests and thinking together to work on various ideas and learn from each other.

Introduction

Initially, students create their profiles by signing up for the application. After that, they can either create their projects or apply them to other projects. When someone applies for a project, the project manager of that project can see the profile of the applicant and if he/she has the desired skills they are accepted into the team else their request is declined.

Students can create as many projects as they like and can also apply for as many projects as they want to.

The project manager will receive a list of all the applicants and he/she can see their profiles. According to the skills required for the project they can choose whom to accept into the team and whom to reject.

This Student Project Portal Website project will help many students who have ideas for projects but are not able to execute them due to the lack of a proper team.

Cycle diagram

Sign Up

Sign up for the app using your credentials

Share

Share and present your ideas for projects

Form Team

Form your ideal team according to your requirements.

Apply

Apply for the projects that interest you.

For a Demo of the website you can visit:

https://stormy-springs-31769.herokuapp.com/

Download the complete Student Project Portal Website project on GitHub.

Student Job Placement Management System Project Idea

Introduction:

Student Job Placement Management System project explains Job Placement. This academic project mainly explains the various actions related to students placing to companies online. You can search for various jobs and shuffle according to the role. Our Project Include

Modules:-

  • Admin Module
  • Recruiter Module
  • Student Module

We can develop this application in Java, Spring boot, Hibernate, and MySQL. It’s a web-based project so I have to use HTML, CSS, Thymeleaf, and Bootstrap also.

The main feature of the project is to make Students placed easily. You can access this website from anywhere and everywhere. In the Admin module, the admin can add the Jobs and Manage. He can also view the total number of Students who applied to jobs on the website. And also Recruiters action. Admin can only see the admin page and Job if he wants to Add or delete jobs from the list.

In the Student module, the student can access the website and apply for the job.

In the Recruiter module, a recruiter can post new jobs and maintain the status of students.

Software Requirements:

Front end: Java, Spring Boot, HTML, CSS, JavaScript, Bootstrap, Hibernate, and Thymeleaf.
Back end: MySQL workbench 8.0.23CE.
Middleware/Server: Apache Tomcat v8.5. IDE: Eclipse IDE for Java EE Developers
Browser: Best result on Google Chrome
Operating System: Windows 10

The Pages included in the project:

Home Page
Student – Register page
Recruiter – Register Page

Login Page:

Student – Login page
Recruiter – Login page
Admin – Login page

Student Details

Student – Dashboard
Student – Profile Details
Student – View Jobs
Student – Update Password
Student- Update Details
Student – Upload Resume
Student – Upload Picture
Student – Preview Resume

Recruiter Details

Recruiter – Dashboard
Recruiter – Profile Details
Recruiter – View Jobs
Recruiter – Add New Job Details
Recruiter – Check Applicant Lists
Recruiter – Change Password
Recruiter – Update Details
Recruiter – Search Candidate
Recruiter – Upload your Company Logo

Admin Portal

Admin – Dashboard
Admin – Manage Student
Admin – Manage Recruiter
Admin – View Jobs
Admin – Non-Placed Candidates
Admin – Placed Candidates
Admin-Update Password

Car Showroom Management System JAVA & SQL Project

The Car Showroom Management System consists of four major fields of management i.e. store cars, store Sales Persons, store admins, store customers and store total sales progress. Here the store admin manages all the activities such as viewing and adding car details, salesperson details, and admin details of different stores. Each store has a Manager and the Manager’s task here is to fill in the details of the car, customer, sales, and workers of a particular store.

The main goal of this application is to maintain the records of different stores which are visible only to the admin and can only be updated by him. It helps to achieve ease of access in searching car details of the selected store, salesperson’s details of the selected store, and sales details of the selected store.

CAR Showroom Management System is a software application to maintain day-to-day activities in the store, This JAVA & SQL project helps to maintain the record of the bike, customers, workers, and sales information Admin manages adds, updates, and deletes the cars, salespersons, and admin records. Admin also can add new admins. The software is designed to handle, the daily activities of all the stores. Search the details when required.

PROJECT PURPOSE

Provides a simple way of accessing the database. Allows the admin to make a search and find certain bikes, customers, and sales records that are linked through a TIN of different stores located at different locations. Provides centralized control of store database. Holds complete information about the customer.

PROJECT SCOPE

The Car Showroom Management System application is designed and developed so that there will be the elimination of storing the records and other details in a hardcopy thereby supporting its eco-friendly nature. The Bike Showroom Management System application is quite simple and easy to use. This application has not had many Complications. It has a very simple way of maintaining the store records such as storing the bike Details of a certain store, customers visiting a certain store, and the sales details of the store that the admin chooses to gain access to.

PROJECT GOAL

This CAR Showroom Management System project aims to show the shadow implementation of JAVA & SQL which includes a better storage facility, update, and view of data. The application provides a user-friendly interface so that the admin can access it with ease.

Download Car Showroom Management System JAVA & SQL Project Source Code, Project Report.

Daily College Class Work Report Book PHP Project Code

INTRODUCTION

Problem Definition

To maintain classes throughout the semester, Academic Institutions follow a course/ lesson plan that informs about the order in which classes shall be held. Daily reports are generated and are periodically cross-validated with the lesson plan, such that any inconsistencies can be identified and managed; doing so aids the institutions in reaching course deadlines effectively and in completing curricula without any hurry or stress. This report is known as Daily College Class Work Report Book. A typical Daily Class Work Report requires three candidates, a Report book, and a Lesson-plan document.

A Lesson-plan is created by Academic In-charges, after considering various factors such as potential holidays, with the aim that it must be followed for a stress-free administration.

Each page of a Daily College Class Work Report Book has a table with rows about the hours in a day and columns about the days in a week. Each table cell has two boxes, one for the subject details and another for the topic discussed in that subject; and between table cells, there is an additional space provided for remarks related to the above cell. An additional column is provided for the signature and details of the Class Representative.

These candidates consist of a Class Representative (a student), a Class In-charge (or a mentor), and an Academic In-charge. The CR (Class Representative) notes down the details regarding the classes conducted and the topics discussed on the Daily College Class Work Report Book and forwards it to the CI (Class In-charge). The CI verifies the report for errors and in turn forwards it to the Academic In-Charge. They cross-check the report with the lesson plan and make relevant remarks wherever necessary.

Modules

Login Module:

Authenticates the user details and based on the account type, it redirects to an appropriate module

Academic In-charge Module:

Presents a unique page for the Academic In-charge, wherein they can select a class in their respective departments. During the beginning of a New Year or semester, it allows for Academic In-charges to create and upload new schedules, Lesson plans, and other such data.

Class Representative Module:

Allows Class Representatives to add or modify details relating to classes that have occurred, during the semester.

Reporting Module:

The data, entered by the CR, will be stored in the database and a report will be generated. This report will be displayed to the respective CRs, Class In-charges, and Academic In-charges. The report will have an option for approval and also an option that allows for In-charges to notify lower-level members to make respective changes, in case of any inconsistencies. This module is incorporated in the ‘Home page’, where Class In-charges and Academic In-charges can access other data such as Lesson-plan, and Schedule details.

UML Diagrams

Activity Diagram

ER Diagram

Output Results will be below:

Download the complete PHP & MYSQL project on Daily College Class Work Report Book. Here you can download the project code, and report.