E-Learning System Web Portal Java Project

Objective:

e-Learning” is an educational-based java web application; this web portal helps college students to get all the resources & study materials of every course available on the online portal. All the students can access this website portal anytime and from anywhere on the internet. E-Learning System is a very good online e-learning portal compared to all web links given by Google, Bing, Yahoo, ChatGPT, or any website while searching for student course materials.

Contents

Existing System:

In Present Educational based E-learning system, students can get information from books or study materials provided by professors manually. But in this system, students may not get the related and sufficient information according to their syllabus. The above resources do not provide discussion forums between students and professors to clarify their doubts. There is no proper guidance for the students.

Proposed System

The main aim of this E-Learning system is to provide sufficient study materials to the academic students according to their syllabus from which students can easily download study materials of their relevant course. The first step is to register in order to access this website. In this system, we are providing discussion forums between students and professors where students can easily clarify their doubts. Modules of this website are Admin, professor, student, and mentor.

Modules:

Admin:

  • Admin can view all member’s details like professors/asst. professors, mentors, and students. Here each user (student/mentor/professor) can upload material.
  • The uploaded material can be verified by the admin. The admin can validate the material if the material is related to the subject. The validated materials are only visible to the students.
  • The admin can view the queries which are sent by the students to the mentors. The admin can also check how many solved queries and unsolved queries.

Student:

  • Each student must and should be registered before login. Here we have user authentication every time. Students can upload material, view material, and send queries. The upload materials first verify by the admin and then visible in the view material tab.
  • The student view uploaded material by all the users which is validated by the admin and he can download materials.
  • The student can send a query to the mentor if he/she has any doubts regarding academic subjects.

Mentor:

  • Mentor registration and login.
  • Mentors can upload material, view material, forward queries, and reply to queries. The upload materials first verify by the admin and then visible in the view material tab.
  • The Mentor view uploaded the material by all the users which is validated by the admin and he can download materials.
  • The Mentor can solve a query if he/she is unable to solve queries forward it to Asst.Professor/Professor.

Professor:

  • Professor registration and login.
  • Professor can upload material, view material, and reply to queries. The upload materials first verify by the admin and then visible in the view material tab.
  • The Professor view uploaded the material by all the users which are validated by an admin.
  • The Professor can solve a query and send it back to the mentors.

Software Requirements:

           Operating System: Windows 10/11

           Web Technologies: HTML, CSS, JavaScript

           Programming Language: Java, JSP, Servlets

           Backend Database: MySQL /Oracle 10G

           IDE / Work Bench: Eclipse/ Netbeans

Hackathon the Code Festival Java Project

Abstract:

Hackathon is a Java web application used for hackathons.  In this web application Project, the Hackathon conducts code fests. The contestants must register to participate in the code fest. The Hackathon announces code festival schedules with desired skill sets. Those eligible for the hackathon can register themselves by using their login credentials. For registered contestants can participate in code fest by using this application. The Hackathon can announce the winner of that particular event and the results also. The contestant can view the results. This Application is very useful for users and the code fests are useful to improve their skills.

Implementation:

This Hackathon the Code Festival project is divided into four implementation modules. Those are

  • Admin
  • Mentor
  • Contestant

Admin:

The admin will maintain all the information about the website and enables contestant to register for a particular hackathon. Then the admin for that particular hackathon enables the contestant to participate in that contest and he is also responsible for displaying the list of contestants for that hackathon. Then the admin is responsible for deciding the winner of that particular hackathon. The admin can give privileges to the contestants to send invites for their friends to participate in the contest.

Mentor:

The mentor is also having the same responsibilities as the admin. The mentor can view the no. of registered contestants and no. of participants. The mentor is responsible for displaying all the contestant’s scores in that hackathon. The mentor can also display the winner of each particular hackathon.

Contestant:

Contestants can choose a particular hackathon in which they are interested from the list of hackathons. To access this application Contestants must and should register. Each every time the contestants should log in by using the given credentials.  Contestants can view the list of Hackathons. The Contestants can participate in hackathons by giving their details about that particular hackathon. The Contests can view the result and winner of the Hackathon.

Software Requirements:

Java, MySQL, HTML, CSS, JavaScript

Beauty Parlour Management System PHP SQLite Project

The aim of the project is to permit customers to service their desired cosmetics. Beauty provides an online way of reservation cosmetic services and also provides a window for customers for their selected services. The Beauty parlour management System processes manage the various task related to the system.

This system is used to parlour details like service detail, orders detail, customer information, etc. This system helps to make the customer easy for online services system. 

The Beauty parlor provides an interactive display to the customers with all the facilities. This website will be useful to all those customers who is wishing to make an appointment best online.

Interface:

There are two types of interface found in the Beauty parlor management  System as follows.

User Interface

The users are able to view the home page of the Beauty parlor management system, add any number of services, save information, look for information about any services, increase or decrease the quantity of any services,  user can see all the order details.

Admin Interface

The Administrator is able to view the customer information, can complete the customer services orders of the users, and can update the services information, price, etc.

Hardware Requirements:

The Beauty parlour management system shall provide minimum hardware requirements. The following hardware configurations are required for the PC for use in the Beauty parlor management system.

  • Hard Disk: 2GB or more of free space.
  • RAM:2 GB / 4 GB / 8 GB RAM.
  • Processor: Any mobile and computer processor.

 Software Requirements

  • This section lists the requirements that are needed to run the system efficiently. The operating system needed for the system to run effectively, the interface to run the application, the integrated development environment to develop the environment and the other tools used for editing purposes are as follows:
  • Operating System: Windows 10, MAC OS, or Linux
  • Database: SQLite.
  • Platform Used: Php
  • Editor Used: Notepad/Notped++.
  • Browser Supported: Google Chrome, Internet Explorer, Safari, Microsoft Edge.

System Function

The Beauty parlor management system would have the following basic functions:

  • Display all the related information about the system’s main page.
  • Display all the categories on the services information page.
  • Allow the administrator to add new services to the existing list of available services.
  • Allow the administrator to modify the price of each service.
  • Users can add or remove services from the customer list.
  • Allow the administrator to remove services.
  • Allow the administrator to complete the customer orders of the users.

User Characteristics

  • The users of the Beauty parlor management system, based on their roles, are customers (users) and administrators (owners). 

Admin

  • The administrator is the owner of the Beauty parlor management system. One must have a basic understanding of computers and the internet as well as prior knowledge of operating eclipse and the PHP programming language. The administrator is responsible for all the training documents required for the system.
  • Assign or change the price of the services, update the services lists and delete the services.
  • Can add new services to the system.

Users

  • The users of the Beauty parlor management system are all customers who would serve to test the system. These users are anyone with service experience and the know-how to browse through a   They must have a basic understanding of computers and how to parlor offline. The users should be able to perform the following functions using this system:
  • Can view or select the services from the home page.
  • Check out the services.
  • reservation by providing the required information.

Specific Requirement

  • This section contains the detail about the system that are required for the designer to create a system to satisfy the user’s requirements and for the testers to test the given requirements. This section contains the interface description for each GUI for the different system users. These sections also give a description of all the system inputs, and all the functions performed by the system output (responses).

Functional Requirements

  • This section contains the requirements for the Beauty parlor management system.
  • The functional requirements, as collected from users, have been categorized as follows to support the types of user interactions that the system shall have.
  • There are two types of modules:
    • User Module
    • Admin Module

User Module

The following are the functions that users are able to perform

  • Reservation user.
  • Able to view the services from a list of services page.
  • Can view the home page, services page, about page, contact page
  • Users are able to view the make an appointment on the tanks you page,
  • Users are able to checkout services when there are services in the make an appointment.
  • Users shall be able to continue services after the checkout process.
  • Users are able to view the customer order details.

Admin Module

The admin is able to perform the following functions:

  • The administration shall be able to view all the user information, and completes the user orders.
  • The administrator shall be able to add new services to the list of services page.
  • The administrator shall be able to modify or update the item’s price and description.
  • The administrator shall be able to delete the services from the services page of the Beauty parlor management system.
  • The administrator shall be able to view the entire history of checkout services.
  • The administrator shall be able to view the entire history of the users who successfully completed the checkout process.

Conclusion

  • With the rapid growth of beauty parlour Services and people will overtake in-parlor.  The main goal of “Beauty Parlour Management System” is to provide the best customer services and helps admin for day-to-day complementation of orders and transaction. Also, an admin can manage customers, keeps records of customer services, etc.

Limitation

  • Well-educated people can visit or understand the content of this site. A non-educated person may not visit this site easily. So, this is the common limitation of this system.
  • As of now, this system does not have the facility of making payments for their services, which will be applied in the future.

Future Scope of system

  • This system will try and be able to add new more feature.
  • We will try to add a bill generate after parlour.
  • The main feature is an online payment which will be applicable and implemented in the future.
  • We will try to provide a more user-friendly interface in the future.
  • We will try to provide more beauty parlour Services so that user gets what they need.

Download the complete Beauty Parlour Management System source code, Project Report, and PPT.

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

Campaign Management System Platform for Women PHP Project

Project Problem Statement:

Women all over the world are disadvantaged when it comes to having access to knowledge/capital for starting a business, crowdfunding, political campaigning, and more. 

Women are limited by several factors at different times in their careers, including disadvantaged economic status, discrimination and restrictive gender norms, and lack of access to knowledge on how to start a business or traditional fundraising networks.

Home Page:

The objective of the Task

The main objective of the Campaign Management System project is to build a web-based platform for women so that they can overcome the economic and social barriers that prevent their access to political decision-making through training, mentoring, and technology.

Database Schema:

Pages:

  • Registration page, Login page, welcome page, backend of profile
  • Home page, Dashboard Page
  • Profile page

Technologies used:

1.HTML

2.CSS

3.PHP

4. MYSQL

5. BOOTSTRAP

6. JAVASCRIPT

Download the Project on Campaign Management System Web application using PHP & MySQL.

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 E-Commerce System Project Using HTML 5, CSS 3, NodeJS and ExpressJS

Purpose

  1. To develop an online e-commerce system that will provide a platform for customers and sellers to meet and sell and purchase items. The Online e-commerce system shall accomplish the following as of achieving the major goal:
  1. To build a user-friendly business website, where users will be able to search for any product which is available nearby or anywhere in the world. By using an Online e-commerce system, it will be easy for sellers to sell products and save time and money. Doing business through this application will help to reach a maximum of customers and sellers. Creating a panel where a seller is able to upload their product’s full details and a customer can view and make a purchase as per their wish.
  1. To implement the system and check if it actually is able to provide benefit to the people.

Scope

The scope of this application is to build a user-friendly e-commerce website, where users will be able to purchase any product which is available on the website. By using the e-commerce system, it will be easy for sellers to make a sale and save time and money. Doing business through this application will help us reach a maximum of sellers and customers globally.

General Objective

To develop an online e-commerce system that will provide a forum for sellers and customers to interact with each other, and sell and purchase items.

Specific Objectives

  1. Create an online platform where sellers post items for sale through the online system.
  1. Create a panel where a customer can view products from a seller and make purchases and do payments through online payment systems, and later submit reviews about the service.

ER Diagram:

Data Flow Diagram:

UML Diagram:

Modules Description

Sign Up

1. It is used to register or to create a new account for a particular website.
2. It also allows the user to be a part of the website and also provides all the services of the website.

Log in

1. It is used to open a session with an account that is already created.
2. It is successful when your credentials (i.e., username and password) match with what is already stored in a database. This is called authentication.
3. It makes the site personalized for you.

About

1. This module gives an overview of the website.
2. It shows the website’s business, values, and commitments and its management.

Contact

This module allows the users to ask any queries related to their property or anything.

Search

This module is used for searching the posted auctions

Add Product

This module helps in posting Auctions

Product Function

1. Enable the customers to view posted products in their locality and also globally.
2. Enable the creation of accounts and logging in to the accounts
3. Enable users to log out of their accounts
4. Provide an interface for the seller to view the transactions, and add sellers and products to the system.
5. The seller should also have accounts where they will receive customer orders and respond to them.

Modules 

  • Login and new registration
  • Search: The search page will help users to search for the desired items using the search box.
  • Contact: This module will help users to contact the seller in case of any queries or issues that arise.
  • Add Product: This module will help the seller to add new products to the system

Summary

This NodeJS-based website is a reliable web application that saves time and money. This must be implemented in most of the information technology industries. It is user-friendly software, through which users can easily interact and easy to search for and buy products. This turns out to be great usage.

With the rapid growth of the internet and the world wide web, everything is going online. This website is developed by keeping in mind the easiness of interaction by the users so that they get a very user-friendly environment while surfing the website. Such compatibility of this website enables it to attract users to visit the website more frequently

The system is capable of maintaining details of various users, sellers, and products and storing all day-to-day transactions. The central concept of the application is to allow customers to search, compare and purchase products using the internet. The information pertaining to the products is stored on a NoSQL database on the server side. The Server process the customers and the orders and stores them in the database. 

Future involvement with the project

We will keep on improving our project in the future by adding more and more modules in the system as per the needs of the users. 

Limitations

Our project was limited in time and cost which is a limitation. If provided with more time and cost, we would have done better using the better infrastructure.

We developed the project on a local offline server, though we could have used an online one if provided with more cost.

Hardware & Software Used

Hardware

1. HP Notebook
2. i5 10th Gen CPU
3. 8GB RAM
4. 512GB SSD

Software

1. Visual Studio Code
2. Postman
3. NodeJS
4. ExpressJS
5. Google Firebase
6. AWS
7. HTML 5, CSS 3 & Javascript.

Library Management System BCA 4th Semester Minor Project using SQL and PHP

ACKNOWLEDGEMENT

We truly resolve to acknowledge the opportunity provided to us by the Institution, respected teachers, and family.

We intend to show our gratitude for all the support and guidance we got from our teachers, classmates, and all individuals who helped us at any point in this project.

This whole process we went through in bringing out this project was a great source of knowledge and valuable experience, which would for sure, come in handy for us in any future we will have to bring out another such project.

This has been a period of time over which we learned about technological and logical aspects of the field where we are going to land soon, we feel indebted for being so well equipped with all the knowledge and experience we gathered here.

Introduction 

Surface details:

Our project entitled “Library Management System” is designed to bring ease to both the library staff and the students seeking for issuing books.

It is designed with features that reduce the effort for the staff and increase convenience for the readers, Being a Web Based application, it is easy to Run and adapt in almost all conventional environments.

Any moderate user can easily learn and operate this system 

Scope:

This System can work fine for all most every library, where desired,

This cuts off a lot of human resources required to maintain the library, hence saving money too.

It has fluid UI and UX which can be learned and adapted quite quickly by any category of user.

This system extends its use outside the library with is easy to adapt interfaces for readers

Objective

The Objective of this System is to reduce effort and increase convenience in the management of libraries.

It allows users to hold a book for 24 hours so that no one can get it issued before they reach the library.

It will save time in the calculation of fine

Students will always stay notified about generated fines via their online accounts which they can access from anywhere.

  • It will make it easier to search for books.
  • It will help keep track of bookholders.
  • It will keep Libraries less crowded.
  • It will save money as fewer human resources will be required.

About the existing system

Currently, libraries need to maintain bulky files to record books and the individuals occupying them.

Fines are calculated manually by going through bundles of records.

Need to manually check for availability of books in the library

The process of issuing a book involves designated officials making entries in registers manually, which takes plenty of time.

Disadvantages of the Present System:

The current system is full of flaws:

  • A lot of Human Resources is required to maintain such a system much cost and hard to operate and maintain.
  • A lot of money is wasted in maintaining these records
  • Paper is wasted
  • A lot of time is consumed in the process of searching a book, making its entry, and retrieving any previous record.
  • Availability of books cannot be assured without physically searching the library
  • People need to travel to the library to know whether a book is available. 

Proposed System

The System we developed comes with all solutions to the drawback of the previous system.

Some of them are listed below:

  • Search books from anywhere.
  • Put the book on hold for 24 hours so that no one else can take it before you
  • Release the book if you don’t want to hold it anymore
  • A panel for users to check their hold and issued books
  • Easy login and registration System.
  • Automated Fine System
  • One-click book Issue
  • Easily return book
  • List of trending books.

Feasibility Study

This document enables proper decisions to be made over the progress of the project, by studying various aspects of feasibility associated with it

Such are listed below:

  • Cost: as it is a web-based project it needs to be hosted over the server to be accessed by users, but the efficiency which comes with the product shadows this cost, as it reduces money being spent on human resources
  • Time: The time invested in this project is also justifiable as keeping the yield into consideration.
  • Technical: All technological tools used to make this project are conventional easy-to-use ones, and they are easy to maintain too.

This project can be easily upgraded and maintained as it is designed in a standard manner and is easy to understand. 

Hardware and software information 

HARDWARE CONFIGURATION

  • System: Multimedia PC
  • Processor:  Pentium 4 or above
  • Memory: 512MB RAM or above
  • Hard Disk:  500GB
  • Keyboard: 104 standards
  • Monitor: SVGA          

SOFTWARE CONFIGURATION

  • Front end: HTML, CSS, JavaScript
  • Back end: SQL, PHP
  • Operating System: Windows/Linux

Design Phase:

ER Diagram:

Context Level Diagram:

First Level Data Flow Diagram:

Second Level Data Flow Diagram for User:

Second Level Data Flow Diagram for Admin:

 

DATA DICTIONARY 

Users Table:

Name

Type

Field-Size

Description

Example

Uid

INT

100

Unique ID for Users

0

name

VARCHAR

100

Name of user

XYZ

password

varchar

100

Password

XYZ

credit

INT

100

No.of books currently Occupied

0-5

U_type

varchar

100

Reader/admin

admin

Pic

varchar

100

photograph

Xyx.jpg

Email

Varchar

100

Email for identification

[email protected]

 

Books Table:

Name

Type

Field-Size

Description

Example

bookid

INT

100

Unique id of book

1

bname

Varchar

100

Name of book

Life of pie

stock

INT

100

Available copies

66

Author

Varchar

100

Name of author

ABC

Publication

Varchar

100

Publication name

BBC

Edition

Varchar

100

Year of publication

2013

Price

Int

100

Price of the book

2000

 Transactions Table:

Name

Type

Field-Size

Description

Example

Tid

INT

100

Unique id of the transaction

1

bid

INT

100

The ID of User Involved

1

uid

INT

100

The ID of Book Involved

1

Time

timestamp

100

Time of transaction

2018-07-02 19:55:11

Returned

INT

100

State(returned or not)

0

T_type

Varchar

100

Hold or issue

issued

Download the complete project on College Library Management System using SQL and PHP.

IOT Solution for Vehicle Maintenance and Report Generation System

INTRODUCTION

  • Many automotive manufacturers are now moving towards an IoT platform for manufacturing and for service purposes.
  • The main advantages of using IoT in cars are Optimized maintenance and logistics.
  • Our idea is to monitor vehicle status (fuel, efficiency/Km, battery, oil levels, etc..,.) to the customer as well as the manufacturer.

CONCEPT

  • The main aim of every car manufacturer is to increase the life of the car and it’s crucial to maintain the car in a good condition to achieve it.
  • Many problems in vehicles arise due to improper maintenance. Many lose track of their service status and it’s a tiring process to keep in touch with every customer in a large automotive industry.
  • If we maintain a system, that automatically updates the vehicle’s conditions periodically to a specified server, and the system will generate a report, that will be forwarded to the customer and the service team, a lot of manual work will be removed.
  • We as a team provide an IoT solution for vehicle maintenance and report generation system.

FLOW DIAGRAM-FUNCTIONAL DECOMPOSITION

  • Our Vehicle Maintenance and Report Generation system collects data from the sensors available in the car itself and reports it to a transceiver module(ESP8266) which is connected to a database in the cloud.
  • when new data is updated/inserted into the table an event is triggered. This event updates the information in the dashboard, which will be displayed to the customer and manufacturer.
  • Then a weekly/monthly/yearly report generation event is triggered, which will mail the report to the specified recipient.

FUNCTIONAL DECOMPOSITION

Data collection:

The data is collected from the sensor stream of the car. This data is redirected to the ESP8266 module. The ESP8266 is connected to the server, that is allotted to the car. The ESP8266, when all data is collected, converts it into a JSON file. Then the server sends a post request to the server.

Event trigger:

Many database servers provide pl/SQL-based triggers. Here an Update and Insert trigger is created for the table. Oracle server provides a wide range of PL/SQL functions. The IP of ESP8266 is connected to the oracle server, which on periodic updates in the table triggers an event.

Dashboard:

The dashboard is created using HTML and CSS and deployed in the cloud using the NODE JS framework.

FUNCTIONAL SPECIFICATION

Hardware:

ESP8266 CP2101 module(CAR)
ESP8266 CP2101 module(HOME)

Programming Language:

SQL
Javascript (Node JS)
C++(Arduino .ino)
HTML CSS

Dashboard

The Vehicle Maintenance and Report Generation System dashboard are developed using Adafruit.io. This website provides dashboard development for MQTT-based devices

University Leave and Outing Pass Automated System Application

Purpose of the Project:

This Project is a leave/outing pass automated system designed for Educational Universities. This system is an end-to-end module that enables a user (Student) to raise a request and an admin (Mentor) to approve/decline it. This is a robust system where Parent Verification, In-Out Time recording, and Data Security have been taken care of. This Project is built to be a secure, flexible, unique, transparent, and user-friendly environment that aims to digitize the whole process thus removing fake paper trails.

Feasibility Study:

The project has been undertaken after the feasibility study, which paves the way for deployment, and phase development.

Scope of the Project:

The scope of the Automated System is designed to run on the University server and to allow students to raise requests for their leave, trace the request status, and modify them. On the Mentor Dashboard, the software also allows the Mentor/ Mentor Coordinator to view requests, and approve/decline requests. Whereas on the Hostel Dashboard, the Warden/ Deputy Warden and Hostel Supervisors will be able to view and grant leave passes to the students.

This Automated System will provide ease to all the actors – students, mentors, hostel authorities, and security services in regard to leaving/outpassing sanctions and will ultimately eliminate the paperwork.

Overall Product Description:

Product Perspective:

It will provide a way in which existing paper-based work can be supplemented with the end-to-end robust leave management system. The system can be used independently of the platform and device, be it on a smartphone, tablet, or computer.

Product Functionality:

The server will be responsible for storing each request generated, generating one-time passwords, generating QR Codes E-Pass for authorized requests, receiving and authenticating requests, generating statistics at the needs of each audit, and maintaining and verifying security and user privacy. This server can also potentially contact all authorized students by email to give them username information, passwords, server address, OTP code, updates to the users from the Mentors/ Hostel Services, etc.

Process Flow – Student:

  • depicts how the student raises the request and the activity which is continued after the review from the mentor.
  • depicts how the Mentor/Warden/Supervisor approves/declines the requests.
  • depicts how the Security guard can verify the leave request the student displays.

Upper Classes and Characteristics:

It is anticipated that three types of users will use the Licensed Software defined in this SRS.

  1. IT staff/ Software Development Cells are expected to deploy and configure the System using the defined system interfaces. This will include running the whole system and maintaining software after the handover and deployment of the project.
  2. The second type of user of the Hostel Warden/ Deputy Wardens / Hostel Supervisors and Managers is expected to understand and use correctly the software interfaces defined with the appropriate design documentation.
  3. Finally, it is expected that any student accorded with Hostel Services within the domain of Vellore Institute of Technology may access all of the leave request information such that the request is independently verifiable. This will include a web application presented using Hyper Text Markup Language (HTML) to allow a user to raise their request that has been registered under review including the previous requests history.

Working Environment:

The Automated System software is directly made as a web application, so the computer hosting must be capable of running HTML and should have internet. The system will be uploaded to the University server, in order to make it accessible for all the students, faculty mentors, and wardens.

Design and Implementation Constraints:

The Application provides an end-to-end leave management system that copes with malicious attacks provided certain constraints are met. Principally, all necessary steps should be taken to protect the System from unguarded attacks by using physical, network, storage, and user security protection. These safeguards should be penetration tested by the SDC to ensure viability.

User Documentation:

The users are the students or faculty/staff of the university who are authorized by SDC, they will be able to raise/ view/ approve/ disapprove requests on the server. The application client will be available free of charge, and any purchase of the server software will be authorized to distribute it to their users.

Assumptions and Dependencies:

 This software in its initial phases of development depends on a few third-party commercial applications or any assumption. Student Development Team will take care of all the assumptions and dependencies. It will be the responsibility of SDC to purchase/ develop the dependency as per the University IT norms.

System Features:

Login:

This is used to login and maintain security by authenticating the users

1. Should accept the user name password
2. A case-insensitive comparison is done for a user name and a case-sensitive comparison is done for a password
3. If the correct user id and password are supplied then, Main Menu should be displayed
4. If an invalid user id or password is entered then the system should display the error message “Invalid ID or password” and should quit the application.
5. Username – Students – Registration Id Faculty – Employee Id Staff – Employee Id
6. VTop Login Credentials can be used in the further enhancements

Mentor’s Portal:

This feature allows mentors to work out the leave/vacation requests.

1. Can approve a request.
2. Can decline a request.
3. Can edit the request.
4. Can verify the request.

Warden’s Portal:

This feature allows the warden to authenticate the requests

1. Is able to view all requests for outpass.
2. Can reconsider requests

Hostel Supervisor’s Portal:

This feature allows supervisors to issue outpasses to the students

1. Can issue outpasses to students.
2. Can deny the issue of an outpass.
3. Can send a request for reconsideration to the warden.

Student Portal:

This feature will allow students to raise a request for an outing/extended outing/leave.

1. Can raise requests of respective categories.
2. Would receive a system-generated outpass

External Interface Requirement:

User Interfaces:

Login Interface – The login interface consists of the student username and password fields, Students can log in with the same VTop Credentials.

The login interface for the faculty and staff consists of the faculty/ staff employee id and password. Their credentials will also be the same as those of VTop.

Hardware Interfaces – Hardware requirements include a laptop or a desktop or a smartphone with proper connectivity to access the system. Other than above mentioned, no hardware is required.

Software Interfaces – The software is based on an application interface. The Application will interact with the University Server with regard to user verification and information retrieval.

Operating System

Ubuntu

Programming Language

HTML, PHP, CSS, JavaScript

IDE

Visual Studio Code

Database

InnoDB

Hosting Base

Amazon Web Services

Communication Interfaces – This software would be functional on an ethernet connection or a wireless connection.

Cost Calculation:

SOFTWARE COST ESTIMATION:

For any software project under development, it is indispensable to know how much it will cost to develop and how much development time will it take. The project scope must be established in advance and software metrics are used as a support from which evaluation is made. The project is broken into small PCs which are estimated individually. Several estimation procedures have been developed to monitor the project’s progress, so developers and product managers can assess whether the project is progressing according to the procedure and take corrective actions, if necessary.

STATIC, MULTIVARIABLE MODELS:

Static, multivariable models depend on several variables describing various aspects of the software development environment. In some models, several variables are needed to describe the software development process, and the selected equation combines these variables to give an estimate of time and cost.

WALSTON and FELIX developed the models at IBM to provide equations to give a relationship between lines of source code with effort and duration of development.

For our software project, the lines of code (LOC) sum up to 5223, which becomes 5.223 KLOC.

So, according to the WALSTON-FELIX model, we need to hire 24 engineers per month and require 7 and half months to develop our project.