Automation of Student Attendance Management Tool Project

Abstract:

The Automation of Student Attendance Management system maintains an analytical record of students, in accordance with the minimum attendance required by the faculty, for allowing students to sit for the examination. The front end of the project is being made using Netbeans IDE 8.2, in Java language; whereas the backend is being created and managed using MySQL 5.6 and WAMP Server. The project is being made by keeping in mind the problems faced while keeping attendance records on paper, or on spreadsheets, where the authority or faculty has to use formulae and decide which student matches the criteria and which student doesn’t.

All the tables are in a hierarchy. There is a view that holds the data of every student and their attendance table for the rows. We can only insert new data if we are logged in as a Faculty. But if we are logged in as students then we can only view our attendance. The front end is designed using Eclipse and the back end is built on MySQL and the connectivity between the two is done using JDBC Drivers.

Introduction:

It automatically calculates attendance percentage, total classes attended, and unattended classes for a particular student.
It enables performing some key administrative functions such as tracking absences, getting debar lists, etc.

The system maintains an analytical record of students, in accordance with the minimum attendance required by the faculty, for allowing students to sit for the examination.
The front end of the project is being made using Netbeans IDE 8.2, in Java language;

whereas the backend is being created and managed using MySQL 5.6 and WAMP Server.

Homepage of attendance manager

Homepage of Attendance Manager

The project helps the teachers upload their records to the system, and accordingly keeps track of each individual, and his attendance in classes. Even the students can access their records and maintain their attendance as per the criteria suggested.
It solves a big problem for teachers and saves time as well, which can be utilized in helping students in their box endeavors.
The project uses color coding and data assessment tools to manage attendance records. The attendance management software enables college and school students to improve the lecturer’s performance and productivity. The faculty does not have to expend their time in manual computation to obtain the student attendance percentage.
This system can help lecturers to take attendance easily. Manipulation and management of attendance data have to be taken care of, by the system so that the manual intervention can be removed.

You can also visit & download the Application project on Daily Student Classroom Attendance Management System Project

Overview of the Project

WHY DATABASE?

Record keeping is an essential part of every industry, it allows us to manipulate historic data and use that data to make decisions. Attendance is an important part of school and colleges it allows the faculty to know which student is coming regularly to classes and also helps in creating good students. It is also useful for the administrative authority to check for the late comers to work. Database tools like MySQL and Oracle are available for record-keeping purposes and are easily adaptable by nearly every industry. These records can be accessed later, and analyzed for further calculations, as needed by the user.

Advantages of database

• Single validated database throughout college/school.
• Current dataflow into Web-based access.
• Compliance of academic standards & best practices.
• Providing fast access to quality data to users.

This Attendance Tracking Management System is related to the Attendance Manager .Net Project. You can also visit & download the web application project on Attendance Tracking Management System PHP & MySQL Project

SCOPE OF THE PROJECT

The Scope of the proposed system is to develop a system for attendance marking and viewing using a database management system that can be accessed by the users through LAN/WAN. Respective departments of an organization can access the data easily from this proposed system.

ER Diagram:

ER Diagram of Attendance Management System

The present system handles data related to:

1) Attendance marking (For faculties).
2) Making calculations to check for debarred.
3) Viewing of attendance. (For students).
4) Subject-wise debarred list.

The developer is responsible for developing the proposed software i.e. he should analyze, design, and implement the proposed project.

The proposed system aims to manage the attendance of the students on the desktop and to insert/ update/ delete data in the attendance database.

The proposed system has the following objectives:

In the backend MySQL is used, the overview of tables is given below:

1. Faculty
2. Course
3. Subject
4. Class(Class name)

SYSTEM REQUIREMENT SPECIFICATION

Software Requirement :

  1. Operation System: Windows XP/7/8/10, Linux.

Programming Environment:

  1. Front End: Java (Eclipse)
  2. Back End: Wamp (MySQL)

Some output Pages of the Project

all the classes of the faculty for the system.
all the attendance records of the students for the system.
all the records of the subjects for the course.
all the attendance records of a class for the system.
users (Faculty/Students) can log in to the system.
the admin or the registered users to log in to the system.
the faculty to record the attendance of the student and then submit it.
show the attendance of the logged-in student and also show in which subject he is debarred.

Also, Read this Employee Attendance Monitoring System Java Project

Online Shopping Web Application BCA Project Using PHP

EXISTING SYSTEM:-

Current system customers have placed orders through phone calls, messages, or face-to-face communication. In the current system, the customer does not think about whether products are available or not.

PROBLEM WITH THE EXISTING SYSTEM:-

  • The current system totally works manually.
  • The existing system is based on a phone call or face-to-face communication.
  • The current system is very hard to operate and maintain.
  • The paper-based work so the records are lost sometimes.

PROPOSED SYSTEM (NEW SYSTEM):-

The Online shopping web application is easy for customers because customer purchase items in stay in the home on their computers. In this new system customer view, a variety of products and what’s products are unavailable(finished), and what products are available. You can also visit & download the Java Console Application project on Online Shopping Management System.

ADVANTAGES OF THE NEW SYSTEM:-

  • Effective communication between admin and customer.
  • Payment systems are available.
  • Home delivery is available.
  • Customers are aware of products and see what’s products available or not.
  • The product is nice or not given feedback.
  • View a product review.

TOOLS AND TECHNOLOGY:-

1) TECHNOLOGY:-

1. Frontend

  • PHP
  • Html, Css, js, Boostrap

2. Backend

  • My SQL

2) TOOLS:-

  • Sublime Text
  • Visual Studio Code
  • Draw.io
  • Microsoft PowerPoint
  • Microsoft Word
  • SQL Server

Project Functionalities:

  • Registration Page
  • Login Page
  • Admin Add Product Page
  • Admin Update Product Page
  • Admin Remove Product Page
  • Search Product Page
  • Buy Product Page
  • Payment Page
  • Cancel Order Page
  • Forgot Password Page
  • Change Password Page

Database tables:

  • Admin Table
  • Customer Table
  • Cart Table
  • Order Table
  • Product Table
  • Category Table
  • Payment Table
  • Feedback Table

Also, Read this Development of an Online Shopping Bot using IBM Watson

Also, Read this Analyzing Online Shopping Data QlikView Project

Acknowledgment

We express our heart gratitude to a number of people who extended their full support and cooperation in developing this project first, We would like to take this opportunity to thank our College for giving us this opportunity and a platform for discovering and developing our potential, This kind of experience that we have received while making this project report is so immense the narrating that in few words is difficult.

After putting in such hard work we have realized that takes to work in the shop and do a project. Our Institute and colleagues have been great sources of help without them we were unable to do this project.
Therefore, our project is a small drop in the water sea. We have learned many things from being a part of the concept of family.

After that our heartiest thank is to our internal guide as well as respected faculty for entrusting us with responsible and acting as a ray of light in the darkness. We find ourselves self-short of the world to describe our feeling for the role he played as a friend, a philosopher, and a guide, whenever we were in need.

Lastly, we are thankful to our parents for their blessing, Love, and Support. We are unable to traverse through this most significant stage of life and also, and we would Like to take this opportunity to express our regards to all our friends and faculties who have helped us directly or indirectly during the execution of the project. We are privileged and thankful to all for bringing our errors and shortcoming. This Online Shopping Store C# and SQL Website is related to the Online Shopping PHP Web Application Project.

QR Code based Customer Billing System for Supermarket Shopping Project

ABSTRACT

The objective of this project is to propose a real-time capturing system that helps consumer billing for hypermart shopping using Quick Response (QR) code in Android smartphones.

EXISTING SYSTEM

Nowadays in most hypermart shops, customers have to take a long queue for billing after shopping and it’s a time-consuming process. Also, users will not be aware of the total bill amount at the time of purchase. Increase time spent at the billing counter and reduces customer satisfaction.

PROPOSED SYSTEM

When a customer entered a shopping mall or a hypermart for shopping, his smartphone will be connected to the hypermart’s server. After the successful connection with the server, he can start purchasing. At the time of shopping, the QR code should be read for bill generation. QR code pattern can be read by android smartphones at the time of adding an item to the cart. The QR code will identify the price of the product and it will automatically calculate the total price according to the quantity of the product in the cart. So QR code verifies products by capturing them through a smartphone, then decodes them and sends them to the server for authentication. When the user finishes his shopping, the total amount will be displayed on his phone as well as the cashier’s monitor. You can also visit & download the PHP, My SQL Application project on Supermarket Inventory Management System.

 This will avoid huge queues and waste of time for billing after shopping. The customer can plan his shopping whether to continue or not by viewing the purchase bills so that he can manage the bill and shopping effectively.

The project consists of two main modules.

Admin module

Admin will add the products with their price, manufacturing details, and quantity information. He can view the billing and purchase details of customers and generate daily, weekly, and monthly billing reports. Admin can add the products with their price, manufacturing details, and stock information without any duplication. Based on the arrival of new stock and purchasing the product from the stock, the stock quantity will be updated. He then generates a QR code for each product. He can view the billing and purchase details of customers. Accordingly, he can generate daily, weekly, and monthly billing reports.

User module

User can plan their shopping using this app. The user can register with the app. When he enters a hypermart, he can scan the QR code of the product and can view the corresponding product details. Then submit the quantity to be taken. He can finally submit his items in the cart to generate the bill and also have the facility to cancel items from the cart. 

This Supermarket Management and Billing System are related to the Customer Billing System for Supermarket Shopping Project. You can also visit & download the Java Application project on Supermarket Management and Billing System

SOFTWARE  REQUIREMENTS

  • Operating system:   Microsoft Windows XP/above, Android
  • Platform:   Net Beans, Eclipse
  • Front End:   JSP, Android
  • Back End:   MySQL

TABLES        

Table 1: Login

Primary key: username

Purpose: To store login details

Column

Type

Description

Username

varchar(50)

 Primary Key, Email id

Password

varchar(50)

 Password, unique password

User type

varchar(50)

 user type

Status

varchar(50)

 Status

Table 2: Customer

Primary key: customer_id

Foreign key: emailid

Purpose: To store customer details

Column

Type

Description

customer_id

int(50)

 Primary Key, customer id

customer_name

varchar(50)

Name of customer

emailid

varchar(50)

 Foreign Key , Email id

Phone_number

bigint(50)

 Phone Number of Customer

address

Text

 Address of Customer

appcode

varchar(50)

 App code

 

Table 3: Category

Primary key: category_id

Purpose: To store category details

Column

Type

Description

category_id

int(50)

 Primary Key, Category id

Categoryname

varchar(50)

 Category Name

 Table 4: stock

Primary key: stock_id

Foreign key: product_id

Purpose: To store stock details

Column

Type

Description

stock_id

int(50)

 Primary Key, Stock id

product_id

int(50)

 Foreign Key, Product id

Stockqty

bigint(50)

Quantity of Stock

Stockdate

date

Stock Added Date

Status

varchar(50)

Status

Table 5: product

Primary key: product_id

Foreign key: category_id

Purpose: To store product details 

Column

Type

Description

product_id

int(50)

 Primary Key, Product id

productname

varchar(50)

Product Name

category_id

int(50)

Foreign key, Category id

Quantity

bigint(50)

Quantity of product

manufacturingdate

date

Manufacturing Date

Expirydate

date

Expiry Date

Price

double

Price of Product

manufacturer

varchar(50)

Manufacturing company

Description

text

About the product

Madein

varchar(50)

Country name

Image

varchar(50)

Image of product

Qrcode

varchar(50)

Quick Response code

Status

varchar(50)

Status

Table 6: cart

Primary key: Cartid

Foreign key: Email

Purpose: To store cart details

Column

Type

Description

Cartid

int(11)

 Primary Key, Cart id

Email

varchar(50)

 Foreign Key, Email

Cdate

date

 

Flag

int(11)

 

Table 7: cart_item

Primary key: cart_item_id

Foreign key: Cartid , product_id

Purpose: To store cart item details

Column

Type

Description

cart_item_id

int(8)

 Primary Key, Cart item id

Cartid

int(8)

 Foreign Key, Cart id

product_id

int(8)

 Foreign Key, Product id

no_of_quantity

int(8)

 Quantity of product

 Table 8: purchase

Primary key: purchase_id

Foreign key: bill_no, Emailed, product_id

Purpose: To store  purchase details

Column

Type

Description

purchase_id

int(8)

 Primary Key, Purchase id

bill_no

int(8)

 Foreign Key, Bill No

Emailed

varchar(50)

 Foreign Key, Emailed

product_id

int(8)

 Foreign Key, Product id

purchase_date

date

 Product Purchased Date

Quantity

bigint(15)

 Quantity of product

Table 9: bill

Primary key: bill_no

Foreign key: Emailed

Purpose: To store bill details

Column

Type

Description

bill_no

int(50)

 Primary Key, Bill No

Emailed

varchar(50)

  Foreign Key, Emailed

Amount

int(50)

 Total Amount

bill_generate_date

date

Date of bill generated

Status

varchar(50)

 Status

Table 10: feedback

Primary key: feedback_id

Purpose: To store feedback details

Column

Type

Description

feedback_id

int(8)

 Primary key, Feedback id

from_id

varchar(50)

 Sender’s id

Message

varchar(50)

 Message

send_date

date

 Feedback send date

Download the complete Android app project on QR Code based Customer Billing System for Supermarket Shopping Project.

Also, Read this Sales Management System for Hypermarkets PHP & MySQL Web Application Project.

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.

Online Food Ordering System Project Synopsis using PHP

About the Project:

The reason behind Online Food Ordering System is that there is a lot of information to be maintained and has to be kept in mind while running the business. For the reason we have provided the features present system is partially automated actually the existing system is laborious as one has to enter the same information at three different places.

Motivation:

The records were never used to be lots of difficulties in associating any particular transaction with the particular context.
If any information was found to be it was required to go through the different registers, document there would never exist anything like report generation. With the help of this system, people can easily order food. It can also ensure that. People don’t waste their precious time and use their time productively in other works.
This system proves to be more effective and reliable than other traditional systems. however one needs to take care of small parameters like server breakdown while this system is implemented.

Basic Structure:

Technology Used:

a) Hardware:

  • 1 TB storage
  • 8 GB RAM desktop

b) Software:

  • Notepad++ (for code)
  • Web browser
  • Operating System (Windows, Linux)

c) Language Used:

  • HTML
  • CSS
  • PHP
  • JAVASCRIPT

Choice of programming language:-

So many programming languages were put into consideration in the cause of designing this software. A lot of factors were also considered which include online database access, data transmission via networks, online database retrieval, online data capture, multi-user network access database security, etc.

Features

Take Away Ordering. Takeaway ordering is a win-win solution for restaurant owners and customers.

  • Pre-Orders
  • Catering Orders
  • Scan & Order
  • Unique Webpage
  • Social Media Sharing
  • Search Engine Optimization
  • Combo Deals

Available Applications

  • Foodpanda
  • Zomato
  • Faasos
  • Deliveroo
  • Dunzo
  • Grubhub
  • Swiggy
  • User Interface

Advantages

  • Makes the ordering process easier
  • Efficient customer ordering management
  • No-cost marketing.
  • Better customer data
  • The convenience of mobile ordering
  • Greater reach

Disadvantages

  • Deliverymen put themselves in danger
  • Disguised increased expense
  • Juggling with your health
  • Unsuccessful payment resulting in delayed food delivery

RESULTS:

Basically, the users targeted:

  • There will be a lesser requirement for staff at the back counter.
  • The system will help in the reduction of labor costs involved and also reduce the space required to set up a place like a cafeteria in restricted areas.
  • As it is an automated system is less probable to make any mistakes.
  • The customers can avoid the long queue a the counter, with a reasonable speed of execution and maximum throughput.

METHODOLOGY:

The simulation first starts with the customer entering his/her credentials(name, ID, and password). Once that has been verified the customer can place an order specifying the quantity of ordering food requirement. Now we get a window that displays the order number, customer ID, price, food name, and quantity. Once the customer finalizes his/her order they are redirected to the payment window where the total price is displayed and the customer can choose the payment option. The customer will get the confirmation message.

The above-mentioned simulation will flow with respect to the customer’s overview. Now if you are an admin you can select the normal login option and can enter the admin portal. Once you enter the admin portal you can add or reduce the food or update food or their price. Once the selected option is carried out to the end result that added item list will be displayed and if you have deleted the food the particular food will disappear.

CONCLUSION:

The online food ordering system is developed so that customers can order food and avoid the hassles of waiting for the order taken by the waiter. Using the application, the end user registers online and reads the E-menu card to order food online. Once the customers select the required food item the chef will be able to see the results on the screen and start processing the food. This application nullifies the need for a waiter or reduces the workload of the waiter.
The advantage is that the in a crowded restaurant there will be chances that the waiters are overloaded with orders and are unable to meet the requirement of customers at a time. Therefore by using this application users can directly order their food online.

System Analysis and Design for Student Hostel Management System Project

Introduction

PURPOSE

The purpose of this SRS & System Analysis and Design document is to build a Hostel Management System Site to help students book hostel rooms at their own convenience, file complaints, and write reviews about the room.

INTENDED AUDIENCE AND READING SUGGESTIONS

The Hostel Management System project is useful for both students and hostel committee members.

PROJECT SCOPE

The purpose of this Hostel Management System is to ease hostel management and to create a convenient and easy-to-use application for students. The system is based on a relational database with room allotment, review, and complaint features.

The Application will be able to perform the following operations:

  1. Allot Rooms: Students will be able to choose hostel rooms according to their convenience and pay for the same.
  2. File a complaint: Students will be able to file a complaint regarding any of the facilities and if the complaint could not be resolved within the specified time, it would be sent to the higher authorities.
  3. Review the rooms– Seniors who have already stayed in the room will get an option to review a room in which they can upload the room pictures and write about the problems(if they had faced any).

Mess: Students will be able to pay the hostel fees, see their past payments and write reviews about the food and management.

ANALYSIS

Specific requirements

External Interface Requirements

User Interfaces

The goal of this Hostel Management System is to design the web application that will be used for the proper management of hostels. The user types are listed below-

  • Students
  • Hostel Committee
  • Mess Committee

ER Model

Hostel Management System ER Diagram

DESIGN

RELATIONAL SCHEMA

  1. Users
  2. Reviews
  3. Writes rev
  4. Rooms
  5. Complaints
  6. Writes com
  7. Student

USER INTERFACE DESIGN

GOAL

MAKE INTERFACE

  1. Pleasing to the eye.
  2. Simple to Use.
  3. Minimize the effort it takes for users to accomplish the work.

PRINCIPLES OF USER INTERFACE

  1. Layout
  2. Content Awareness
  3. User experience
  4. Consistency
  5. Minimize user effort

VARIOUS USER INTERFACES

  • HOME– It includes navigation among different pages. Starting with registration and login and address of other pages.
  • REGISTRATION/log in If you are a new user you have to register and if already a user only login is sufficient. After registration and login user will be redirected to the home page.
  • ROOM ALLOTMENT– After logging in it is necessary for the user to fill room allotment form if the room is already booked user will be redirected to the allotment form.
  • DASHBOARD– After booking the room user can see the status in the dashboard including username, scholar no and room booked.
  • REVIEW A ROOM – The user can review the room he is allowed only after login. This page is accessible only when the room is allocated. The review includes the description and the photo of the room. After the submission page is directed to another page from where the user can view his review and even delete it.
  • VIEW YOUR REVIEW– It keeps the track of the user’s reviews.
  • REVIEWS OF ROOMS– Before booking the room the user can view the review of various rooms.
  • COMPLAINTS– After room allotment, if the user requires to file any complaint he can register his complaint.
  • YOUR COMPLAINTS– It keeps a record of all the complaints filed by the user.

FLOWCHART

Hostel Management System Flow Chart Diagram

CONCLUSION

Till now, room allotment is done manually and physical presence is also required for the same. Students have to come a few days prior to the beginning of classes in order to select rooms. Hence this particular project deals with the problems of managing a hostel and avoids the hecticness of carrying out tasks manually.

Students Solution an E-learning-based platform Project

The project Students Solution is a website that is an E-learning-based platform project and it will help the first-year students of B.Tech (All Branches). In this, we will build a Students Solution site. After creating the Students Solution site, you will be able to take notes for your corresponding subjects which were provided by the developers, and you are also able to practice your basic knowledge with the help of a quiz Which was in this website we also provide some blogs which were helpful to motivate students for deeper knowledge and extracurricular activities.

This technology helps you to provide the best notes on your subject bases and gives extra knowledge along with your course.

It provides a convenient solution to the traditional notes-making system. We follow a modular approach to learning through our website.

About the Project

This Students Solution project aims to make a website for first-year students of our university. This is an e-learning website where first-year students of our university will get ready-made notes. Our website “Students Solution” is to automate the existing manual system with help of ready-made notes, fulfilling first-year students’ requirements so that they can receive a valuable education. This means no need to worry about making handwritten notes. And they can utilize their time up to the maximum. It is a need for time to switch to e-learning.

Motivation

When we joined the university we faced a lot in our very first year due to a lack of proper subject material and guidance after class. So we are thinking of developing a “Students Solution” website where first-year students of our university will get all the subject notes and materials.

To help the first-year students we are working on this project “Students Solution” so that they can feel free and study well.

Objective

The main objectives of creating the Students Solution, We will provide all the notes regarding your subject and quizzes regarding that particular subject which provide you the basic knowledge of that particular subject and we will also give vlogs to fresher’s to motivate themselves for extracurricular activities.

The main objectives are :

  • To provide a quality-based education.
  • To provide ready-made notes.
  • I-Q Test

Implementation Details

Part 1: To build a Backend of the website in which notes are to be attached.
Part 2: Develop a site for quizzes regarding that particular subject.
Part 3: To build the information of developers.
Part 4: Provide vlogs to motivate students for extracurricular activities.

FUTURE PROSPECTS

  • We will add video lectures.
  • Live classes would be there.
  • We provide all the material for different disciplines.
  • The test series will be there.
  • Gaming will be there for entertainment.

Requirements

Software Requirements (Minimum):

  • Windows 10
  • Visual Code Studio
  • Xampp

TECHNOLOGY USED

  • HTML
  • CSS
  • JAVASCRIPT
  • PHP
  • MYSQL

Fresh Online Grocery Ordering Website Project

Project Overview

Fresh Online Grocery Ordering Website is an online web application for automating the process of ordering grocery products from suppliers and paying for them in advance. Therefore, there is no need for the suppliers to wait for a long time and pay in cash at the time of delivery. This system also helps farmers to sell their products through this system.

The current Grocery Ordering system is not much efficient and can lead to a major waste of time as the supplier needs to wait for a long period. The main purpose to design this Online Grocery Ordering application is to provide an environment where the users will be able to order products from a supplier and pay in advance.

To what extent the system is proposed?

The proposed Grocery Ordering system automates the manual process of users the shop owners which can be used for ordering products from suppliers online and farmers visiting the shop with their products for selling and physically paying for the products with cash by introducing an online automated system that sends product requests online. The current system is not much efficient and can lead to a major waste of time as the supplier needs to wait for a long period. The main purpose to design this application is to provide an environment where users will be able to order products from a supplier and pay in advance.

Specify the Viewers/Public who is to be involved in the System?

The Viewers/Public that are mainly involved in this system include staff, suppliers, and farmers. The staff, suppliers, and farmers can also register to this system with valid information. They can buy/sell products and also include payments

List the Modules included in your Grocery Ordering System?

The system includes 4 modules. They are:

• Admin Module

Admin is the one who does the staff and supplier registration and approves or rejects the leave request of staff and farmer’s product request, publishing notifications to the users, fulfilling staff and farmer’s product requests, and can view and block and unblocking of existing users. Admin can do a secure payment for their products through the online payment system. Admin can also view their request status from Suppliers and notifications from the Staff. Admin can approve or reject the leave requests as well as admin can view the existing products and order the products and view the status of the ordered products.

• Staff Module

The staff can view the current stock and update the stock. After product stock reaches a critical value the staff can issue a notification to the admin. Staff can send leave requests and see the status of the requested leave and also
able to update their profile.

• Supplier Module

The suppliers can view and update their profile as well as their stock.
Suppliers can add new products and can view product requests send by shop owner/admin and process orders. Suppliers can get a secure payment for their products through the online payment system.

• Farmer Module

The farmer can send a request for selling their products through that shop.

Farmers can see the status of product requests send to the admin as well as can view and update their profile. Farmers also can get a secure payment for their products through the online payment systems and can also view their
request status and notifications from the admin.

Sequence Diagrams for the Project:

Farmer Supplier Sequence Diagram Online Grocery Ordering system Online Grocery Ordering Farmer Admin Sequence Diagram

Identify the users in your project?

The main users of this project include:

  • Admin who controls and coordinates the entire activities of the system including provisioning users to buy/sell their products and responding to requests from farmers.
  • Staff who manages the day-to-day activities of a grocery shop including updating seller stock and logging and maintaining transactions to and from the grocery shop.
  • A supplier who processes the order that was made by the admin.
  • The farmer who requests products online.

Who owns the system?

The owner of Online Grocery Ordering is the grocery shop in which the system is implemented. A system administrator is appointed by the organization for managing and coordinating the system activities.

The system is related to which firm/industry/organization?

Online Grocery Ordering is a grocery shop management system and it is associated with a grocery shop in which the system is implemented.

Details of the person that you have contacted for data collection?

Questionnaire to collect details about the project? (min 10 questions, include descriptive answers, attach additional docs (e.g. Bill receipts, certificate models) if any?)

1. Is there any discount streams available?
Several discounts are available for a range of products if the customers purchase products in a bulk range.

2. Is there any products available in your shop other than grocery items?
Yes, we also sell products including vegetables and fruits as well as sweets.

3. Is there any wholesale products in your shop available?
Yes, we provide products for wholesale.

4. Which among the products are most frequently sold out?
Sugar, cerials, vegetables.

5. How do you maintain the records of day-to-day transactions? What all features do you expect if this system gets automated?

6. How do you keep track of inventory?

7. How do you transport your groceries?

We use paper bags for the transportation of products.

8. What are the pricing strategies that you follow for selling your products?

It depends on the market value/price.

9. Is your supplier responsible for restocking?

Yes, our supplier is responsible for restocking, if the products meet their time limit.

10. How do the details and contacts of suppliers maintained?

The details and contact of suppliers are maintained in records physically.

Download the complete Grocery Inventory Management System PHP & MySQL Project.

Women Security Band – Smart and Handy Security Device for Women Project

Objective :

  • To design and develop a smart and handy security device for Women.
  • To alert people in its vicinity and relatives of the victim about the attack and also get help from emergency services.
  • To track the user using google maps under crucial situations.
  • The module developed should be capable to work automatically under crucial situations.

Introduction :

Women Security device is a device that will help women to walk freely in the streets anywhere and at any time. The goal of the women’s security device is to protect women from getting molested in different ways like rape, sexual harassment, abuse, etc. There are existing apps or devices to provide security to women but there are drawbacks to these existing apps or devices. So to overcome such drawbacks and provide security in an enhanced way we are going to propose the women’s security device.

Technical Details :

Following modules/sensors to detect the crucial situation:

1. Pulse rate sensor:

Pulse rate will be the major parameter for the security device because
whenever the person is in danger person’s heartbeat gets increased. So using this parameter we can consider that person can be in danger.

2. Temperature sensor:

This is the second parameter that can be considered when the person is in
danger its temperature starts decreasing so this can be considered as one of the parameters to detect that the person is in danger.

3. Motion sensor:

This is the third parameter we can consider as when the person is in danger due to
fear or anxiety person’s body starts shaking or shivering. So this can be considered as another parameter to send alarm message or call to relatives.

4. Voice Recognition.

We will be using this parameter as well to detect dangerous situations. We will be recording the “HELP” word and when the person shouts when is in danger then by detecting and comparing it with the already recorded word and if it crosses a certain limit of intensity range then we can consider it as a dangerous situation to send alarm message or call to the relatives of the person.

Using the above sensors will provide input to our device
Also to track the user and send emergency messages to listed
contacts and to the nearest police station two modules are used

Problem Statement

To develop an easy-to-carry system that will work automatically without any manual inputs to provide security for women.
Importance of the project.

The expected outcome of the project

A wearable security device that will be user-friendly and feature train the device according to different users. Module to add and remove authorized people for sending alerts to them. Location will be considered while sending alerts.

Functional Requirements:

The user of the Bracelet:-

1. System would Identify the critical situation and normal situation automatically.
2. System would get emergency help automatically when the victim is under attack.
3. System would Blink the LED for 10 secs when a critical situation is detected.
4. Track the nearby victim/friend/relative in an emergency using Google Maps.
5. System would alert the vicinity people.
6. System would get emergency help when the SOS button is pressed manually.
7. Add the contact numbers of friends/relatives on the application to ask help for in an emergency.
8. Login with the already provided unique number using the mobile application.
9. Save the button on the System to write those numbers into GSM.
10. Reset button on the System to reset all previously saved numbers into GSM.

Other than the victim/ User of the Bracelet:-

1.Log in with a verified mobile number.

2. Track the nearby victim/friend/relative in an emergency using Google Maps.

External Interface Specifications:

1. User Interface:-

The user of the Band:-

1. Login.
2. Add the contact numbers of friends/relatives.
3. Tracking the victim using Google Maps.

Other than victim/ User of the Band:-

1. Login.
2. Tracking the victim using Google Maps.

2. Database:-

Firebase Cloud will be used for real-time database storage.

3. Google Maps API will be used for tracking the user.

Technical Specification: There will be one android app and a smart band.

Languages & Technologies:

Languages: C, C++, JAVA, Firebase database
IDE: Arduino, Android Studio

Online Judge – Online Assessment of Programming Assignments Project

Online Judge Objective :

To create an automatic testing system that checks programming assignments/problems wherein teachers add problems and students submit programs.

Abstract :

The online judge will be a system that can be used for the online assessment of programming assignments. The system will have a resemblance with websites such as hackerrank, code forces, etc which provide a platform for competitive programming. A similar system can be deployed in colleges for the submission of practical assignments online. It will be a system where college faculty will have to design the problem statements and prepare test cases that need to be tested on the code submitted by the students and the expected output for each test case. The system will execute the code on all test cases and compare the output generated by the code with the expected output.

Briefs about Contents:

1. Introduction:

Online Judge will be a system that checks for the correct output of a program. As the name suggests the Online Judge will judge the correctness of the programs submitted to it on various parameters like accuracy, time complexity, space complexity, etc.

The purpose of the system is to create a platform where aspiring programmers can improve their coding skills and compete with others and make themselves well-acquainted with the sport of competitive programming. The system also aims at creating the interest of computer science students in competitive programming.

2. Technical Details :

The system will be a web-based interface that will provide a problem setting to faculty and problem description for students and an editor to type his code and submit it. Three languages will be provided. C++, Java, and Python.

3. Working:

The product will check the output of the program submitted by the end-user by comparing it with the sample output already fed to the system by the person who has designed the problem. The sample test cases will be given by the problem designer and the code submitted by the student will be checked on all the test cases.

The time complexity and Space complexity of the program will also be checked by adding a time limit and memory limit. Role of the students: To think of the algorithm for the problem statements. Implement the algorithm using an appropriate programming language. Make a timely submission. Role of the faculties: Faculty will have to give a precise description of the problem statement. They will have to create test cases considering all the scenarios of the problem. Faculty will have to give the format of the input and the output.

4. Applications:

This system can serve as an assignment submission interface as well as a practice site for programming problems thereby improving the programming skills of the students.