Design & Implementation of Library Management System Java Project

Abstract

In every institute or city, there are libraries. A lot of software’s are being made in the past to manage the library system so that easy and proper functioning of the library can be there. This project aims at building such a project by implementing some of the functionalities that have been present in the older software’s using the content and the knowledge.

Giving a brief overview of the project is that this will be a core java project. The information regarding the books and members of the library is stored in the database. Very basic and user-friendly screens will be there for a good user experience and for the most part it will be implementing some easy and necessary features of the library management system.

functionalities :

  • Very friendly user interface.
  • Easy to issue and return books.
  • Easy to search books.
  • Adding and deleting members will be easy.
  • Adding and deleting books will be easy.
  • Can view all the members of the library
  • View all the books in the library

For accomplishing these functionalities very easy screens will be provided. Complex features of the general library management system will not be implemented but this system will be very useful for the staff in the library rather than the students. This will be small software implementing some easy features of the library management system in practice.

Introduction

The software Library Management System has the following main modules.

Insertion to Database Module  – Easy insert of books and members
Search Facility system  – search for the book
Deletion to Database Module – Easy to delete books and members
Issue Books  – Easy to issue books
Return Books  – Easy to return books and  charge fine on members and other basic operations

ER Diagram

ER Diagram

System Requirement and Specifications

Purpose:

This specification document describes the capabilities that will be provided by the software application ‘‘Library Management System’.

The system aims at providing the Library of an institute with better functioning and easy to issue the books and return books and many other facilities that can reduce the human work to an extent.

Scope:

 The software product ‘Library Management System’ will be an application that will provide information regarding the current situation and presence of books in the library and also very specific details of the library. Various functions can be performed like updating the number of books, issuing the books and adding and deleting members, etc.

References:

The details about the books and the members are provided by the Library head.

Overall Description:

The ‘Library Management System’ will have the capability to maintain information about the library regarding issues of books members of the library and fine and the students and many other things.

Product Perspective:

The application will be window-based. Very easy to use and good searching methods are provided to make it easy to search books and members.

System Interfaces:

The system has a very friendly interface and the java language provides the ease with which anyone can use it.

User Interface:

As the system will start there will be a menu where there will be some choices for the user about the management.
Each screen will have a title describing the things that can be done there. Most of the screens have an admin password box where an admin password is needed to fill. For general users, there is the option of searching the books only.

Product Description:

Normal users and students, cannot do the changes in the database. Only the admin using its password can change the contents of the database. Most things required a password. So it is designed for the admin to keep track of the records of books issued and other things.

User characteristics:

Educational level: He should be comfortable with the English language.
Technical Expertise: Should be comfortable using the general-purpose application on the computer.
Constraints: The whole system is user-driven. There are no warnings in the system if there is a decrease in copies of a book. The searching of the books and members is also very limited and no partial searching is there. The admin password can be changed only after doing changes in the code. As it is just a prototype so it lacks many features of the exact library management system.

Future Scope

As the project lacks many features like good searching of members and books, partial searching, and searching regarding many other fields. The details of the members are also very less. So this project can be extended very easily in the near future to make it more efficient and with more user-friendly frames and screens. Icons can be added to this project to look more attractive and very friendly. More modules can be added to make it do more work. More admin IDs and passwords can be added so that more Admins can use them and each admin can be provided with a different set of authority to change the contents of the database. More functions can be provided to the admin like changing passwords and fine to the library members. 

Supermarket Management and Billing System Java Project

The project is on Supermarket Management and Billing systems. The supermarket is a huge shop where we all can find a lot and lots of products may whether grocery or fashion or utensils etc. in the various categories in different departments. Also, there is a huge number of staff in different positions. It has to keep all the records of its staff so that the employee management would be effective. So, to make such problems easier to handle we have developed this system that not only keeps authentic data may that be of transactions into and out of the supermarket or that be the information of its employee.

The manager module in the software helps to keep information of employees and the cashier and the data entry operator module helps to keep records of transactions inside and out of the supermarket.  The barcode scanning system in the software help to run the transaction process fast and effectively.

INTRODUCTION

The Supermarket Management and Billing System, a desktop application, is developed to provide all the facilities and services required in various shops like shopping centers, mini-mart, fancy shops, etc. The main objective of the system is to provide efficient transactions with minimal error.  Bar code scanning technology helps cashiers with faster and more efficient billing. Cashier, manager, and data entry operator are provided with their own authorization account so that only the authorized person can perform their respective jobs. Users in the system: –

  • Cashier: a – person who handles the transaction
  • Data entry operator- enter the products imported into the store as well as update the details.
  • Manager- supervise all the activities going on in the shop

Statement of Problems

  • Manual data entry takes much more time than the barcode method.
  • The manual calculation can generate errors while buying or selling goods.
  • More time consumption for any transaction and findings of the products.

Objective and Scopes

  • To provide an efficient and effective billing methodology.
  • To keep a record of every business transaction
  • Maintain the stock management and the billing system
  • Reduce the time consumption for every process in the buying and selling of goods.

Database ER Diagram:

Database ER Diagram

METHODOLOGY

The project is to do with the concept of OOP (Object Oriented Programming) with Java and relational database with MYSQL and for the excess printer for the billing process we use Visual Basic Script (VBScript).  Taking into account the statements of the problem, we developed a system that not only helps in maintaining precise transactions but also keeps track of every business that has been done. There is the provision of a login module for individual employees as per their job title after which they will be provided with their respective job functions. With the help of the software, they can achieve a better working experience along with consistent precision.

There are various organized tables which makes the software very effective. The shop assistant module is the symbol of modern business techniques. It is a customer-friendly module. The manager has an organized manner of employee management such as addition or removal of cashier or data entry operator or shop walker. S/he has access to the profile of every employee in his hand at any time of necessity. Logs module helps him/her to analyze the customer’s choice. Furthermore, the automation in the billing system helps the cashier in their transaction in a very precise manner. The use of barcodes makes it easier for making bills and the automatic calculation prevents them from simple mistakes.

CONCLUSION

Supermarket Management and Billing System are developed for the professional handling of the supermarket’s sales and buying as well as the management of the whole supermarket. It is very easy and useful application software that increases the productivity of the business.

Our project on Supermarket Management and Billing systems has been implemented successfully. We take this opportunity to express our sense of indebtedness and gratitude to all those people who helped us in completing this project.

Student Results Generation through their Mobile Number Project

Abstract

Results are a very exciting topic among the students and they want to keep those results secret for that purpose we build a Web Application called Student Exam Results Generation System which provides the latest Results with 3 Login Forms. Those are accessed by using the 1st bluemix feature DATABASE. 3 Logins are ADMIN, STAFF, STUDENT.

Admin Module

Admin Login means, he is an authorized person who can add a new student or staff and can upload the latest results and update the marks whenever he wants. He is the person who can update results up to date.

These given credentials are original, you can use these credentials to access this Admin login to check whether the project is working or not.

After logging in, you will have the following access

  • Admin can add a new student
  • Admin can add new staff
  • Admin can also add new admin
  • Admin can edit both staff and student profiles
  • He will upload results up-to-date

Staff Module

Staff Login means, a staff member can update the internal marks of the student and he can edit their profile or behalf of the admin he can also upgrade the marks.

These given credentials are original, you can use these credentials to access this Staff log in to check whether the project is working or not.

After logging in, you can see the following access

  • Faculty can edit his profile
  • He can upload internal marks
  • He can see the results of their students

Student Module

Student Login means, a student can log in to his account and he can see only his marks not others, so it can be kept private for at least 2 days. If the Latest Results are not updated, then he can send a request to the admin, and later he can receive marks to his mobile number which is registered in the student profile. It is done by using the 2nd bluemix feature i.e Twilio Programmable SMS.

These given credentials are original, you can use these credentials to access this student login to check whether the project is working or not.

After logging in, you can Access following

  • Student can see their results
  • Students can request results, when they are updated, they will get results on their mobile number.
  • The student can edit his profile

With this project, we can get results instantly Without any connection problems and these results will get through a mobile number.

  • In the above Information, all Given Credentials are the Original ones.
  • Since this is an Authorized site we have already provided all details in the database.
  • So, use those credentials to check the Project.

Here College is an Organization so there is no Registration Procedure. To test the Application we can use the following Credentials.

Credit Card Application Portal Java MySQL DBMS Mini Project

Problem Statement:

The credit Card Application Portal provides a platform for Users to avail of a credit card by filling in the relevant details. Further, it enables them to manage card services in the application portal.

Description:

The Credit Card Application Portal not only enables users to avail of a credit card but also allows them to manage services related to it too.

The DBMS Project works in the following way:

• It initially checks whether a user is pre-registered at the application portal. If so, then he or she is directed to the services menu. If not, then it allows users to sign up as first-time users at the application portal.

• Upon completion of the above sign-up process, a confirmation email is sent to the user’s registered email id which he or she had provided during the sign-up process. The confirmation email also contains the user’s login credentials as well as his or her form number.

• Once the user receives the email, he or she is redirected to the initial login page of the application portal. Here, he or she can use the credentials that had been sent earlier to his or her email id to login into the services menu. Once the credentials are verified, the user is directed to the services menu.

• In the services menu, the user can avail of four major services i.e., he or she can update the pin or view his/her application details or view the type of card he/she would be issued with, or view the set of FAQs which he or she can refer to.

E-R Diagram:

ER Diagram Credit Card Application Portal

Tool to be used:

1. IntelliJ / Eclipse / NetBeans
2. WampServer / Xampp
3. Internet Browser (Microsoft Edge, Google Chrome, etc.)
4. PDF Viewer (Adobe Acrobat, Nitro Pro, etc.)

Modules in Credit Card Application Portal

This Java & MySQL Project is aimed at taking a step forward towards digitalizing the entire process of applying for a credit card as well as managing the same.

• Login
• Signup1
• Signup2
• Signup3
• CardType

LOGIN:

Credit Card Application Portal initially checks whether a user is pre-registered at the application portal.

• If so, then he or she is directed to the services menu. In the services menu, the user can avail of four major services i.e., he or she can update the pin or view his/her application details or view the type of card he/she would be issued with, or view the set of FAQs which he or she can refer to.

• If not, then it allows users to sign up as first-time users at the application portal.

SIGNUP1:

This module basically deals with inserting values into the database. Relevant details such as the User’s name, father’s name, date of birth, e-mail id, gender type, marital status, and his/their complete residential address are requested to be filled by the user in order to process the user’s application for availing a credit card. Upon filling in the above-mentioned details, a unique form number is generated which is associated with the user who has filled up the relevant details

SIGNUP2:

This module also deals with inserting values into the database. The user’s application is processed based on the form number generated in the previous module. Details such as Aadhar number, PAN number, educational details, salary, category, etc. are to be filled in by the user. Credit Card Application Portal Department of CSE, Sai Vidya Institute of Technology

SIGNUP3:

Being directed to this module from SIGNUP2, the user is further supposed to fill in details that would be stored in the database. Here, s/he is required to fill in the desired cash withdrawal limit, credit limit, monthly cycle, and the services which they wish to avail. Upon completion of the above-mentioned signup process, a confirmation email is sent to the user’s registered email id which he or she had provided in the SIGNUP1 module.

The confirmation email also contains the user’s login credentials as well as his or her form number. Once the user receives the email upon successful signup as a first-time user, he or she can use the credentials that had been sent earlier to his or her email id in order to login into the services menu.

Card Type

This module tells the user the type of card s/he would be granted. The type of card to be granted to the user is decided upon his/her income.

View Here and Download the Complete Credit Card Application Portal Java MySQL DBMS Mini Project Standalone Desktop application Source Code, Project Synopsis, Report, How to setup files, etc

Software Requirements

Programming language: Java, MYSQL
Operating system: Any OS (Recommended: Windows 10,
Windows Vista, Windows XP)
Application required: Standalone desktop application & Wamp Coding
language: Core Java

Related Projects on Credit Card Management System:

Java and MySQL Project on Credit Card Approval System
Credit Card Approval System Project in Java
Credit Card Approval System Project
Analysis on Credit Card Fraud Detection Methods CSE Project Abstract
Credit Card Fraud Detection Using Hidden Markov Model .Net Project Report
Credit Card Fraud Detection Using Hidden Markov Model Project Report
Analysis on Credit Card Fraud Detection Methods
Cyber Credit Card System Project Source Code In Java And Report
Petro Credit Card Management System Project with Source code
Cyber Credit Card System Java Project with Source Code
Credit Card Fraud Detection Using Hidden Markov Model Project Source Code
Credit Card Management System
Credit Card Approval System Java Project
Analysis on Credit Card Fraud Detection Methods Project
Credit Card Management System

Development of Medical Store Management System Java Project

Project Aim:

The main goal of the development of this project on the Medical Store Management System is to manage the details of Medical Shop, Medicines and its stocks and price, Supplier details. This project manages all the info about Medical shops, Sells, Products, and Inventory. It tracks all the details about the Suppliers, Medicines, Sales, and Stocks. This is a Java web application that used database management concepts.

Project Scope:

It helps in current all works relative to Medical Store Management System. The first subsystem is a Supplier which has all the details of all the suppliers of a particular Medical Shop. The second subsystem is Medicines. The third subsystem is Reports which generates reports for all suppliers and the pharmacists. This Medical Store Java project aims at Business process automation, i.e. I have tried to computerize the various process of the Medical Store Management System.

IMPLEMENTATION

This Medical Store project implementation is done in java language which consists of several classes as mentioned below to perform several operations.

Medical Store Management System Home Screen

CLASSES:

Login

Allows the administrator to login into the Medical Store Management System software with a valid user id and password

Main Menu

Allows the administrator to add a new supplier and medicine, update or search or delete the suppliers, view the supplier’s list, view the stock of medicines, view supplier-wise medicine report, to view the daily purchase report.

Add New Supplier

Allows the administrator to add a new supplier

Add New Medicines

Allows the administrator to add the new medicines

Search Supplier

Allows the administrator to search the suppliers with the supplier id or supplier name

Search Medicine

Allows the administrator to search the medicines with the Medicine batch number or Medicine name

Delete Supplier

Allows the administrator to delete the record of the existing supplier

Delete Medicine

Allows the administrator to delete the record of the existing medicines

Update Supplier

Allows the administrator to update the record of the existing suppliers

Update Medicines

Allows the administrator to update the record of the existing medicines

Supplier List

Allows the administrator to view the records of the existing suppliers

Medicine List

Allows the administrator to view the records of the medicines

Supplier Wise Medicine List

Allows the administrator to view the records of the Medicines by entering the Supplier name

Daily Purchase Report

Allows the administrator to view the records of the medicines by entering the Medicine Purchase Date

About

Allows the administrator to view the details of the Medical Store Management System

Download the Complete project code, Project Report, and Paper Presentation on Medical Store Management System on Github

Related projects on Medical Store Management System Projects

Medical Store Management Project Windows Application using C#.Net
Online Medical Store or Pharmacy Shop Java Project with code
Online Ayurvedic Medical Store System Project
Online Medical Booking Store Project Source Code In Java
Medical Emergency Caller Android App Project
Medical Image Compression Algorithm CSE Project Abstract
Virtual Medical Home Project Report
Medical Diagnostic System Java Project Report and Source Code
A Project on Medical Shop Management
Medical Billing System Project Abstract
Online Medicine Search Web Application .Net Project
Emergency Alarm And Health Care Management System

Interactive Hostel Management System Java and MySQL Project

Objective

The main objective of this Java and MySQL-based project is to create an interactive Hostel management GUI application that helps in the management of Hostel records about registration of students and employees, and fee and salary management. Through this application, the admin can register & manage students & employees of the hostel.

MODULES IN HOSTEL MANAGEMENT SYSTEM:

Admin:

Admin can log in to the software using the Username and password provided by the developers. After login, he can register students and employees. He has to update the data of all the participants of the system i.e., Students and employees. He can Insert, update and as well as delete records from the system.

Student:

This module is about the residents of the hostel. It holds the data of the students residing in the hostel eg. Names, addresses, USN, RoomNo & Phone. The complete information about a particular student can be obtained by referring to this module.

Fee Payment (Insert):

This module is necessary to hold the information related to the Fees of the residents of the hostel. It has fields for Name, total fees, the amount paid, mode of payment, and balance amount remaining to be paid by every individual student. The individual student details can be accessed by providing a unique USN.

Employee:

This module is related to the employees of the hostel. It holds the data of the employees like Name, Age, Eid, Designation & Salary. The complete information of a particular employee can be obtained by the unique employee ID.

Salary Payment (Insert & Update):

This module is necessary to hold the information related to the salary of the employees of the hostel. It has fields for Name, Eid, total salary, the amount paid, and balance amount remaining to be paid for every individual employee. The individual employee details can be accessed by providing a unique Eid.

Features page of the Hostel Management project

Output Pages will be below:

  • Login Page of the project
  • Features page of the project
  • Registration page for new Students
  • Employee registration page
  • Options for employee management
  • Fee update and fetch the page
  • Fetch fee details of individual students
  • Maintain student records of the system
  • Update fee details of a specific student

Download the complete Hostel Management System Project source code and Project report.

College Campus Students and Faculty Activities Tracker Java Project

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

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

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

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

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

Results Page of College Activities Tracker

INTRODUCTION

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

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

Modules of the Project

We have three modules in our Activities Tracker Java Project.

● Admin
● Student
● Faculty

SOFTWARE SPECIFICATION:

Software Requirement:

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

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.

College Student Results Analysis Android App Subject wise and Department wise

Abstract

The College Student results app is an android application. It enables the students to check and get their each semester results within their mobiles by using their College Registration ID/Hall Ticket Number.

This College Student results in mobile app system is developed for students as well as their parents to check both the internal & external examination results.

Currently, the students are using the University website which is displaying only the individual subject marks and is lacking in some other advanced features which we will supplement through our mobile application.

Primarily, by using this result app project we can generate student individual results and analyze subject-wise and department-wise analysis (toppers list, Max marks, Min marks).

Android Project Features:

  • Latest user-friendly interface with a neat layout.
  • The total marks of the student with percentage will be displayed.
  • Push notifications whenever the results are out.
  • The list of toppers in the individual departments.
  • Sharing results on social networking sites.

Hardware Requirements:

Internal Memory: 512MB RAM
External Memory: 1GB
Speed: 1GHz Processor
Device: Mobile or Tablet

Software Requirements:

Operating system: Android
Programming languages: HTML5, XML, java
Database Used: Android SQLite Database
Others: Android Studio SDK

Related Projects on Student Exam Results System:

Student Result System Desktop Application in Java
Results Through Emails Java Project

Student Exams Backlog Management System Project using PHP & MySQL

College Classroom Appliances Repair and Maintenance System App

Implementation

This College Electronic items Repair and Maintenance System App has been implemented to accept complaints against damaged fans and lights in the classroom and to show the status of the registered complaint.

The college classroom-specific android mobile app has two sides, the user end, and the admin end. The user end is for the class CRs which allows them to lodge complaints, view the status of the complaint, and see the complaint’s history. Whereas, on the admin end, the admin can view the lodged complaints and can update the status of the complaint.

User end Project development:

First, after opening the Repair and Maintenance System App, a login page appears. The user must log in to the app, with his/her respective login ID and password. If the details match with any of the CR’s details, then the app will be directed to the user side. After logging in, a page with all the room numbers is displayed.

When the respective room is selected, the user is directed to a page where he will be asked to select the fan number or the light number that needs repairs. On clicking the submit button, the complaint will be lodged successfully.

On the home page, there is a menu bar towards the extreme left, which has two options-complaints books and logout. The complaints book has information about all the complaints that have been lodged to date.

The status of the complaint whether it is repaired, or it is still pending, is shown for each complaint. By using the logout option, the user can log out of the app. This is the user side of the app.

Dataflow of the App (User end):

DFD of College Classroom Fan & Lights Repair System App                                         

Working Flow of the App(User end):

Output Workflow results of College Classroom Fan & Lights Repair System App

Admin end project development:

When the given user ID and password match with the details of the admin, then the College items Repair System App will be directed to the admin side. After the admin logs in, he will be directly navigated to the complaints book. Here, he can view all the complaints, old as well as new ones, that have been registered. At the end of each entry, he has the option to update the status of that entry.

Conclusion:

The ultimate goal of this Final year android-based mini or major project is to eliminate the huge loss of man-hours and manual intervention. The goal is to provide an effective platform to lodge complaints and also to maintain a chain of responsibility and efficiently attend to complaints.

The entire academic project has been built according to the requirements stated and can be implemented without errors. The complaints can be stored and can be monitored. The is very useful as it would reduce stress and it is very easy to use. This process is less time-consuming and is highly reliable.

This Repair and Maintenance System App project was developed with HTML, CSS, XML, Java, JavaScript, and MySQL databases. It can be scaled to add even more sophisticated features and be made more flexible.

The application can be integrated by adding several other complaints regarding infrastructure etc. A communication system can be provided where the students can clarify their queries. This would enhance the standard of the application.