Category: Php Projects

CSE engineering students can select php project topic from given list.Students can download php project topics for beginners with source code.This category consists of Php Projects for CSE final year students,1000 projects in PHP, PHP projects with source code free download,Final year PHP projects.

Posted on

Design & Development of Student Database Management System PHP Project

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

The goals achieved by this project are:

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

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

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

Output Results:

  • Welcome Page with Register and Login Page

Teacher View

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

Student View

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

SOFTWARE REQUIREMENTS

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

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

 

Posted on

Hospital Database Management System Project using PHP & MySQL

Description of Project:

Hospital Database Management System Project using PHP & MySQL developed under the Database Management System Course study, It is DBMS based application that can handle different workflows related to a hospital using MySQL and PHP. The main aim of developing this project is to develop an online web-based system that registers, stores, and alters the data related to the day-to-day hospital operations to have some meaningful conclusions.

System Requirement Specification:

We have used Netbeans IDE 8.2 software to configure PHP/HTML/CSS scripts on our localhost webserver. The operating system was Windows 10 / macOS Catalina. The web browser is Chrome with PhpMyAdmin as Front-end and Back-end Integration. We deployed our web server on localhost using Apache(built-in server) using MAMP/WAMP (MacOS/Windows Apache MySQL PHP. At Least 8MB of disk space is required. We can implement Hospital Database Management in modern browsers like IE7+, Firefox, Safari, Google Chrome, and Opera that support CSS and HTML frameworks.

Functionalities:

1) Managing Patients Information:

  • For deriving the age of a patient, given the DOB, we have created a function followed by a procedure 
  • To get an overview related to the blood groups of all the patients present in the database
  • To get the details of the patient who has the maximum number of appointments in this hospital
  • To display the patients who took appointments on the weekends
  • To get information about the patients who took an appointment during the current month
  • In our database, we have a table for all the patients in the hospital, and then a separate table for indoor patients. However, we do not have a table that shows the details of outdoor patients.
  • At last, we have generated a bill for a visit of a patient, which includes a patient’s visit charge, doctor charge, medicine charge, etc. And generates the total amount to be paid.

2) Managing Doctors’ Information:

  • To get information about the most famous doctor/s among the patients

3) Managing Appointment Related Information:

  • To get the trend of appointments for each weekday
  • To display patient-wise appointment details
  • To display year-wise appointment details

4) Managing Department wise HODs:

  • For identifying a HOD of a department

5) Managing Staff, Rooms, and Medicines related to Information:

6) Managing Admin/Login Details:

  • We have created a simple login and user registration system using authentication from Admin User Table.
  • There are some functionalities like creating a new administrator, logging out, and password change.
  • As a matter of Privacy Policy we don’t save ‘password’ directly but instead, store the HashCode corresponding to it

7) Managing other information:

  • If Contact no. is not a 10-digit number then a trigger will display an error message
  • For managing patient log details

Visit Here and Download the Complete PHP & MySQL Database Management System Project Code, Report on Hospital Database Management System

Posted on

Online Student Project Report Submission and Evaluation System PHP Project

Project Overview

The online project report submission and evaluation system enables the student to submit their project report online without submitting any physical file. Before the submission, the student needs to update their progress to the system and the lecturer can view their progress and give comments online.

The online project report submission and evaluation system is providing an online discussion and document sharing for students and lecturers. The pre-existing systems didn’t have the functionalities such as notifying the student when he/she is being added to the project group, online automatic generation of the certificate after the completion of the entire project, and many more which are being implemented in this version of the system.

The proposed system will take away the biggest risk out of the picture i.e. the manual transmission of all the tasks related to the project report and also the design is formulated in such a way that the impersonation will be reduced to a greater level. With the increase in technology, the need for systems is constantly increasing.

What is new today will be old tomorrow. Our system at present will help to overcome the drawbacks of the previous versions of the system as per mentioned in the literature survey. Smooth access and a more user-friendly UI will help the users to get a home-like environment.

A special feature has been inculcated into the system as a result of which the notifications will be received by the faculty as well as the students on their respective registered mobile numbers. The faculty who will be added to the portal as well as the students who will be allotted to them will all get an individual notification that they have been allotted under which group and to which project they have been entitled. No submission is permitted by the system after the deadline has been crossed. The upload report button will be automatically disabled by the system itself so that no reports can be uploaded once the deadline has been crossed.

Objectives

  • The system provides online processing of the reports.
  • Accurate results can be obtained.
  • The proposed system is used to reduce chaos and manual errors.
  • By viewing the reports the management can improve the institutional facilities.

Motivation

  • As society is developing and new trends are emerging in the education sector every coming day.
  • The ‘Online project report submission and evaluation system’ approach is all about managing project reports online for institutional and educational practices
  • Intelligence is used for the automatic generation of the certificates once the project report has been finalized or the deadline is crossed.
  • The motivation is to propose an intelligent system that can be implemented in any organization.

Use Case Diagram for the Proposed System:

Conclusion:

With the increase in technology, the need for systems is constantly increasing. What is new today will be old tomorrow. The proposed system at present will help to overcome the drawbacks of the previous versions of the system as per mentioned in the literature survey. Smooth access and a more user-friendly UI will help the users to get a home-like environment. The electronic marking of student project reports will save a lot of time, effort, and energy as well as expenses. It will also be more accurate and reliable for both the students and their instructions. In all, it will be a great help at the institutional level.

This application can be implemented in various situations. New features can be added as and when required. Reusability is possible as and when required in the proposed system. All modules are flexible. A very useful functionality from which the students could benefit would be if the system had a forum where any discussion could be opened that is related to the project. In the future, a useful feature that can be added is a platform to upload the student’s projects (like applications) to their instructors by the students.

Software Requirements

  • Front-end Design: JS, CSS, HTML
  • Back-end Coding: PHP, MySQL
  • Web Browser: Mozilla Firefox, Google Chrome, or later.
  • Operating System: Linux, Ubuntu, Windows 10.
  • Application Server: XAMPP Server

Download the complete Online Project Report Submission and Evaluation System for College students with HTML, CSS, JavaScript, PHP & MySQL Source code, and Full report documentation.

Posted on

Attendance Tracking Management System PHP & MySQL Project

The Attendance Tracking Management System maintains the information about the attendance of the students in primary school. The system also maintains the record of all the students and faculty in the school. The records are maintained to maintain the attendance of students. The Attendance Tracking Management System shall be developed using client/server architecture and will be compatible with any Operating System. The front end of the system will be developed using HTML and CSS, and the back end will be developed using PHP and MySQL.

INTRODUCTION AND PROBLEM STATEMENT

With the increasing number of students and the courses, the departments, faculties, and the students are facing issues like:

  • The attendance is taken manually by the faculty.
  • Data in the attendance list might be inaccurate due to deception.
  • Faculty needs to manually analyze the number of absentees and the percentage.
  • It is very time-consuming and the result of the calculation might be inaccurate.
  • Data loss may happen and the whole attendance process is prone to human mistakes.

The proposed software would allow the following functionalities:

  • It enhances the speed of performing attendance task easily.
  • The entire student’s attendance data will be stored and managed properly and effectively.
  • The system enables the lecturer to add, view, delete or make changes accordingly.
  • The system enhances the calculation process to be more accurate and fast.
  • The system will help to analyze all the data inserted and then verified whether every student is following the university attendance policy or not.
  • The attendance will be marked period wise and the reports of the students will be generated.

Introduction

The Attendance Tracking Management System for students is to be developed. The system would allow the following functionalities:

  • It enhances the speed of performing attendance task easily.
  • The entire student’s attendance data will be stored and managed properly and effectively.
  • The system enables the faculty to add, view, delete or make changes accordingly.
  • The system enhances the calculation process to be more accurate and faster.
  • The system will help to analyze all the data inserted and then verified whether every student is following the attendance policy or not.
  • The attendance will be marked date wise and the reports of the students will be generated.

Overall Description

• The ATMS maintains records of attendance of students and details of students, faculty and courses in the school.
• It is assumed that the students have already admitted in the school.
• It is assumed that the students are already enrolled in the courses.
• The system administrator will receive the lists of the admitted students (course wise) from the academic section.
• The establishment section will provide the list of faculty appointed and courses offered in the school.
• The ATMS maintains and views the attendance of students enrolled in the course offered by the school.
• It allows the faculty to mark the attendance of the students in his class.
• It allows the student to view his attendance.

The administrator/DEO will have to maintain the following information:

  1. Attendance details (only admin)
  2. Student details
  3. Faculty details
  4. Course details

Download the complete project on Attendance Tracking Management System project PHP & MySQL code, project report.

Posted on

Daily College Class Work Report Book PHP Project Code

INTRODUCTION

Problem Definition

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

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

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

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

Modules

Login Module:

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

Academic In-charge Module:

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

Class Representative Module:

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

Reporting Module:

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

UML Diagrams

Activity Diagram

ER Diagram

Output Results will be below:

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

Posted on

Snippet Visualization System PHP Project Code Report PPT

this web-based Snippet Visualization System is to provide a visualization-based technique for web search results based on textual snippets. This project was developed with PHP, javascript, Ajax, and MySQL Database. Here Students can download the complete project code, and report PPT.

Introduction

Many internet users search for some query and as a result, they get a ranked list of URLs.
The user could get disappointed with this related search.
Hence, we are developing a system that is focusing on retrieving search results in thumbnail form.
Users can interact with more results in a single view.
It affords easy navigation and is straightforward to interpret with the user.

Objectives:

To perform pre-processing of collected data.
To perform similarity identification and ranking of the snippets using the k means algorithm.
To perform optimization of the snippets for visualization purposes.
To analyze the performance of the proposed system via experimental evaluation of results.

System Architecture

System Architecture

Modules

1. Collecting information:

It is the first step where the system will collect data from a custom search engine and store it in a database for further processing. Data is stored in the form of text, URLs, and descriptions displayed on each web page.

2. Pre-processing:

It is the second step where each entry returned from a textual query is processed and its term frequency vector extracted. 

3. Similarity Identification:

Multidimensional projection techniques may be employed to generate visualizations that favor the perception of groups of similar documents. Such methods typically represent documents as points in a two-dimensional visual space, where neighboring points correspond to documents with similar content. However, points only convey information on neighborhood relations.

4. Ranking:

Snippets collected in similarity are then ranked in this module using the following algorithm.
• Text-based ranking algorithm.
• Weighted page ranking algorithm.

5 . Optimization:

This module Optimizes the placement of the snippets to avoid overlapping while preserving data neighborhoods as computed by the projection.

Implementation

For the implementation we have used different web technology ie., PHP, javascript, ajax, and open-source databases i.e., MySQL

Conclusion:

We introduced the Snippet visualization technique to visualize the collection of the textual result returned from the webpage.
The system collects URLs from webpages displayed as a result of a search query and stores them in the database.
After storing the data in the database it will display all collected text, URLs, and descriptions on the server side.
Then it starts preprocessing the collected URL. Hence it is useful to the system to do further task. Finally, preprocessed data as output is displayed.

Snippet Visualization System Home Page

Download Snippet Visualization System Code Report PPT

Posted on

Sales Management System for Hypermarkets PHP & MySQL Project

ABOUT THE PROJECT

A sales management system for hypermarkets is a web project developed with PHP & MySQL Database. It is a DBMS-based Project,  Supermarket store is an Indian retail store operating as a chain of hypermarkets. It is one of the largest and oldest hypermarkets in India, with more than 150 stores in more than 60 cities and towns across the country. It includes food, clothing and fashion, furniture, electronics, stationery, cosmetics, kitchen and kitchen utensils, and many other categories.

OBJECTIVES

  • Sales Details by Store / Region / State
  • Revenue/sales analysis
  • Details of the store, ie numbers, area, address
  • List of undelivered orders
  • List of payments made or expected to be distributed to distributors
  • Calculation of benefits by date/month/season
  • Maintains detailed inventory.
  • Track store order shipments
  • Purchased stock, if the number is less than a certain number and calculate the income for a month

ER Diagram:

FEATURES

  • Sales management
  • Income analysis
  • inventory management
  • Delivery management
  • Analytics by category
  • Advanced magazine search
  • Improved reports

PREREQUISITES

  • xampp installation
  • Cloning this repository within xampp / htdocs
  • Read the superstore.sql file to configure the database

MODULES

  • ADMINISTRATORS: Responsible for centralized management of stores and distributors
  • DISTRIBUTORS: Distributors are responsible for store orders.
  • STORE: Located in different parts of the country.
  • STORE ADMINISTRATOR: Participates in-store management and sales

APPLICATIONS

  • It can be used in a centralized management department for large pages.
  • Reseller Dashboard helps you manage store orders and update store order details such as invoices, deliveries, and payments.
  • The Store Manager dashboard contains basic apps for managing your store’s inventory while maintaining customer interaction.
  • The administration panel helps the management team of large stores to keep all stores in the region in one central interface.

CONCLUSION

In developing this Sales Management System for Hypermarkets PHP & MySQL Project, we learned a lot about working with HTML / CSS / JS / PHP / MySQL and database management, as well as how to make the app user-friendly (easy to use and manage) by hiding its complex parts.
During the development process, we carefully studied and understood the criteria for creating the required software, as well as the importance of maintaining a minimum error rate.

Download the complete Hypermarket Sales Management System PHP & MySQL Project Source code, Report.

For more details about the project visit this page

Posted on

Gym Management System Project Using PHP & MySQL

About the project:

The gym management system developed by PHP is an excellent solution for gyms that are increasing the number of members or serving elite customers. This solution helps to identify users and manage their membership in a timely manner.
In its operation, each member is issued a membership card valid for a certain number of gym sessions or for a certain period of time or a combination of both, depending on the payment policy. Upon expiration of the period or number of sessions, the machine will notify the member of the renewal fee.
Thus, the system reduces inconvenience and disputes between members and the management of the gym. You can also create multiple monthly, weekly, daily, and session reports.

The main characteristics are:

1. Gym management
2. Gym membership management
3. Payment management
4. Coach management

Objectives:

1. Add different gyms.
2. Add payment areas.
3. Add members to the gym.
4. Add different gyms.
5. Look at different gyms.
6. See payment areas.
7. Look at the members in the gym.
8. Look at different gyms.
9. Update and delete any gym valuables, fees paid, gym details, and coach information.

ER Diagram:

Output Screens:

PREREQUISITES

  • install xampp
  • clone this repository into xampp/htdocs
  • read gym.sql file to setup the database

Download the Complete Gym Management System Project Using PHP & MySQL Source Code, Project Report.

For more details regarding the project – Click here

Posted on

Restaurant Management System Database Project using PHP, MySQL/MS Access

The aim of this project is to create a Restaurant Management Database (RMD) is an online application for restaurant management. This system wakes to provide service facilities to restaurants and to the customer. The services which are provided are food ordering, reservation of the table by the customer through the system online, menu information management, and report.

The main goal of this project is to make the customers satisfied to get the food from anywhere

  • To develop the online ordering and reservation system in restaurants.
  • To develop a user interface for an online restaurant management system to provide online menu information for customers to order

Project requirement

The basic requirement is to make the customers log in and order their favorite food online. To do so they need to look at the menu. Thus, there must be a menu with quantity and price options. Thus, these basic requirements are addressed for now.

Mission statement

The objective is to help the customer to order food online and get them delivered through an interactive application.

Objectives

  • The application should support customer registration
  • Registered customers should gain access through username and password
  • There must be an interactive menu with all details
  • Customers should be allowed to browse the menu
  • Customers can place an order by adding the menu item to the cart.

Interview Questions

  • What tables are needed for the system?
  • How will we ensure that there are no duplicate records in the database?
  • How will the customer know whether the item is available or not?
  • What navigational options are good for customers?
  • How do secure customer payment information and personal information?

ER Diagram

Tables

Product ID

Product name

Details

Status

Price

Int

char

char

char

Currency

 

user_id

username

password

address

mobileno

email id

int

char

varchar

varchar

number

varchar

 

cart_id

user_id

product details

product_id

quantity

price

int

int

char

int

int

currency

 

delivery_id

user_id

delviery status

duedate & time

int

int

varchar

date  time

 

Reservation_id

User_id

Name

date

table choice

time

int

int

Varchar

date

int

time

Output Results:

Admin Dashboard:

All Orders Details Page:

Restaurant Management Table booking Admin Page:

Popular Dishes Page:

Here you can freely download the complete Restaurant Management System project Source code with both MySQL and MSAccess database code, User Manual Report.

Posted on

Library Management System Database Project using PHP & MySQL/MS Access

EXECUTIVE SUMMARY

Libraries are popular places where there are numerous books to keep track of. Not only books but the librarian is also required to keep track of users, books that were taken, due dates, etc. Making manual entries and keeping track of due dates is not easy when the user’s size is more. It becomes complex when there are numerous books and when the members of the library are increasing. Tracking members and books details become time-consuming and are prone to error. Thus, the objective of the project is to come up with easy to use and user-friendly database management application that helps the librarian with all the tasks related to efficient library management.

The application is expected to be a secure, user-friendly, and easy-to-use database application for library management, that is capable of performing library tasks like adding books, searching books, issuing books, returning books, and generating fines and reports. The application is expected to simplify the librarian tasks, reduce errors in bookkeeping, and make the task interactive and interesting.  

The project management and development shall be iterative and shall employ the RAD application development methodology. The rapid Application Development methodology is a fast way of completing a project prototype with more emphasis on the design phase and application development. With RAD in use, the application development shall be broken down into smaller tasks that are easily manageable and monitored.

At the end of the project, there shall be a live web-based application with an easy-to-use and rich navigational front end designed with JavaScript and PHP and a back end with My SQL. Both platforms are open-free and thus making applications cost-effective.

PROJECT PROPOSAL

1.     Statement of Work

1.1  Project Background

Database management systems have become vital for organizations to manage large databases and to perform transactions upon such large data. These database applications not only store data, but also manage them, synchronize them, and help in information retrieval without errors. They reduce manual efforts and enhance the quality of information retrieval services. Due to this reason, they are widely used in almost all sectors. Libraries are popular places where there are numerous books to keep track of. Not only books but the librarian is also required to keep track of users, books that were taken, due dates, etc. Making manual entries and keeping track of due dates is not easy when the user’s size is more. Thus, this work implements a library management system database application that helps the librarian manage all tasks in an efficient and user-friendly manner.

1.2  Vision

The project vision is to come up with a library management system database application that does the jobs of the librarian like maintaining book records, maintaining user records, due dates, fines, etc. efficiently and in a quick time without errors.

1.3  Project Objective

The objective of the project is to come up with easy to use and user-friendly database management application that helps the librarian with all the tasks related to efficient library management.

1.4  Project Scope

The project scope is:

  • To have a user-friendly and easy-to-use database application for library management.
  • To have an application that secures data records.
  • To have an application that generates reports on books, due reports, fine reports, etc. easily.
  • To have an application that can track the user activities and their records easily.
  • To have an application that reduces the errors and efforts of the librarian.
  • The application shall have a login and password for allowing only authorized users to access the application.

1.5  Value proposition

This application shall reduce the manual errors and efforts of the librarian. It shall provide the end-user with the abstraction of all the database details and thus simplify the task as a set of small activities. It shall enhance the quality of the services of the library. It shall keep better track of book availability, dues, fines, etc., and enhance the quality of response to the user by the librarian. 

1.6  Technical details

Existing system:

Currently, the library system in use is a mixture of both file-based and manual-based work. Excel files are used to keep records of books, library users, and library user transactions. With such a system the key challenges are

  • More duplicate records as there is no control on duplicity.
  • inconsistent records are more as there is no referential integrity control
  • Time-consuming tasks as a simple tasks may require extensive search and a lot of entries.
  • such a system is prone to errors due to inconsistencies in data
  • Lack of user-friendly GUI: the system lacks a GUI that facilitates the end-user by providing an abstraction of the back end. This abstraction of the backend makes the end-user efficiently do his or her job without worrying about other details.
  • Data loss risk: if the data is lost it becomes impossible to recover the data from excel files.
  • Generating reports of books or users with fines becomes difficult and time-consuming as it requires multiple worksheets to be navigated and used. Due to the cumbersome job, the accuracy of the reports is low.

Thus, it is proposed to come up with an efficient, user-friendly, library management system that makes end-user tasks easy, error-free, and fast. The system shall follow the norms of a database management system ensuring integrity, consistency, and no duplicates of data.

Thus, the system shall have a simple to use GUI as the front end. Database application shall be developed using My SQL. The front-end JavaScript & PHP. The operating system is Microsoft Windows 7 and above with either 32 or 63 bits configuration.

1.7  Challenges

The Key challenges the project development may face are as follows:

  • The existing data from excel can be imported to MY SQL database. But to ensure referential integrity of the data it is essential that the database follows norms of having the primary key, removing duplicates ensuring consistency, etc. Thus, it may require the excel data to pre-process, convert and then migrate it to MY SQL.
  • The end-user may be new to GUI and API usage. Thus, there may be a need to train the end-user with the application.
  • Issues may arise from front-end and back-end connectivity. This can be managed through proper coding.
  • The system development may face hurdles if its development process is not managed and monitored properly. It is essential to have a Gantt chart with proper milestones to monitor the activities.

1.8  Organization of the proposal

This project proposal is divided into sections. The first section was a background of the project giving details on its vision, value proposition, objectives, and scope.

Sections 2 to 6 details are as follows:

  • Section 2: This section gives in detail the project methodology and the implementation plan. In this section the database design principles and methodology employed is elaborated, the way the application is developed is defined and the key areas of the application along with key features and functionalities are explained through various diagrams. It shall also contain the test plans for the application.
  • Section 3: This section defines the key deliverables from this project. It thus gives details on what the project shall give for a specified set of inputs and how the result is used.
  • Section 4: This section defines how the application project management shall be carried out. It shall give details of the milestones to be achieved and details on project monitoring and evaluation.
  • Section 5:This section gives details on the project team and their roles
  • Section 6: This section is about the tools and the supporting platforms that make the application implementation possible.

2.     Methodology and Implementation Plan

The database design and implementation process shall be done on the MySQL database management platform. The project management and development shall be iterative and shall employ the RAD application development methodology. The rapid Application Development methodology is a fast way of completing a project prototype with more emphasis on the design phase and application development. With RAD in use, the application development shall be broken down into smaller tasks that are easily manageable and monitored. With regular communication and feedback among the team, the application development becomes faster and more efficient with RAD. The key phases of application development thus are as follows:

  1. Requirement analysis
  2. Application Design
  3. Rapid construction & Testing
  4. Going live

2.1  Requirements Analysis

This is the first phase of the application development lifecycle. The objective of this phase is to gather the end-user requirements and the expectations of the stakeholders from the library management system. These are listed in the form of functional and non-functional requirements.

Functional requirements

  1. Login/logout: The application should provide user-based login and logout mechanism. Thus authorized users can login into the system.
  2. Add book: This shall allow the librarian to add the book record into the database.
  3. Manage book: This shall allow the librarian to edit or delete any book record in the database.
  4. Search book: This shall allow the user to search for a book through book name, author name, or both.
  5. View book: This shall allow viewing all the books, new books, old books, damaged books, lost books.
  6. Issue Book: This shall make an entry of the member with the books browed and the due to return.
  7. Accept Return book: This shall enter the return date and ensure that the book is successfully returned.
  8. View issued books: This shall list the books that have been borrowed with their member name and due date.
  9. View returned books: This shall consist of lists of returned books.
  10. Add member: This shall help the librarian to add a new member and categorize them.
  11. Manage members: This shall make changes in the member record like deactivating them, deleting them, and editing their information.
  12. Search member: this shall help in searching the library member record
  13. View fine details: This shall generate a fine for those borrowed books with member details that skipped their due dates.
  14. Generate report: this shall allow the system admin to generate user reports, book reports, borrower reports, fine list reports, etc., and download them.

Non-functional requirements

  1. Security: the application should endure data security and user access security.
  2. Navigational requirement: The navigational options of the system should be user-friendly and easy to use.
  3. Database requirements: The database should be accessed by only secure and authorized users. The database should be available, consistent, have no duplicate entries, and should give error-free output.
  4. Performance requirement: the system should be responding with a proper message thus giving an idea to the user of the interactions.

Use case diagram

Following is the use case diagram of the system

Figure 1: Use case diagram

Activity diagram: Consider the process of adding a book record

The steps of adding the book record to the database are as follows:

Figure 2: Activity diagram

1.1  Conceptual Design

ER diagram for the Library Management System

Figure 4: ER Diagram

1.2  DBMS cost/benefit analysis

The technology that shall be used for the proposed system is the MySQL database management system. It is used because it is simple to use, supports a large database system, and has compatibility with various programming languages that can support the front-end design.

The front-end technology relies on JavaScript and PHP. These are selected as they offer good design options, navigational options, making the user interface interactive and more appealing. Thus, with consideration to having a good and user-friendly interface, these technologies are selected.

The other options were to use the Oracle database management system and MS Access database management system. But MS access system was ruled out due to its failure to support large databases and its difficulty in providing front-end connection to programing and scripting languages like PHP. Oracle was ruled out as it is tough to use and is costly when compared to MY SQL which is free and open source.

Product

Cost

Option 1 Oracle

Standard Edition One – $5,800 per unit (sockets)

Option 2 MS Access

$109.99 per license

Option 3 My SQL

Free

 

Front end option 1 Java and swings

Free but requires programming expertise

Front end option 2 PHP and Javascript

Free requires scripting expertise

Front end option 3 ASP.NET

Free requires scripting expertise

 

Based on the above and the available expertise, the project is built using MY SQL, PHP ad Java Scripts is selected.

1.3  Logical Design

The main tables proposed for the system are as follows:

User table:

User_id

Username

password

firstname

Lastname

Primary key int

Varchar(100)

Varchar(100)

Varchar(100)

Varchar(100)

Book table

book_id

Book_title

Author

Book_copies

Book_pub

Publisher_name

Isbn

Copyright_year

status

Category_id

Primary key int

Varchar(100)

Varchar(100)

int

Varchar(100)

Varchar(100)

Varchar(50)

int

Varchar(30)

 

Borrow

borrow_id

Date_borrow

Due_date

Member_id

Primary key int

Date

date

Int

Member

member_id

Firstname

lastname

Gender

contact

address

type

Status

Primary key int

Varchar(100)

Varchar(100)

Varchar(100)

Varchar(100)

Varchar(100)

Varchar(100)

Varchar(100)

Return

Return_id

Book-id

Borrow_id

Borrow_status

Date_return

Fine

Primary key int

int

Int

Varchar(100)

Date

int

1.4  Physical Design

The proposed system shall have a user interface form designed and developed using JavaScript and PHP scripting languages. The key issue in this design is the special emphasis on navigational options, proper usage of arrows and icons so that the user can operate the system without any hurdles. The user navigation should give control freedom to the user. It should not be complex and should be user-friendly.

The database backend is designed and developed using MySQL. It can be problematic to establish front and back-end connectivity while using the application. Thus, in such a case proper commands for the connection must be established.

1.5  Prototype

A sample prototype is as follows:

Front end admin login screen

Front end admin login screen

Back end book table

Adding books

Adding members

1.6  Performance Evaluation

The Project is successful only if it is capable of giving expected results. Thus, the application is to be tested to ensure that it is executing as per expected objectives. The proposed application shall be using black-box testing wherein test cases shall be built and executed. The test cases shall test the user interfaces and each use case. If the expected results are achieved the application shall be assumed to be error-free and ready for launch. Otherwise, the test result recommendations shall be implemented.

2.     Expected Result

At the end of the project completion following things shall be expected:

  • A back end designed and developed in MySQL with tables for users, members, books, return records, borrowing records, searching capabilities, and report generation.
  • A front end that is user-friendly, rich with icons, and is appealing to use. The front end shall be designed so that the user can perform the actions without any issues.
  • A fully functional application with both front end and back end connectivity capable of doing all the said tasks of use cases.
  • An application manual describing the ways to use the application
  • A cost-benefit analysis describing the feasibility of the product in economic terms.
  • A requirement analysis documents and work breakdown structure.
  • A complete coding and scripting file
  • A test project report giving details of project implementation and test results.
  • Final project document

3.     Project Management Approaches & Milestones

The objective of project management is to ensure that the project development is planned well and executed properly to ensure quality and timely delivery.  For proper management of the application development, the project development process is broken down into small tasks. Each task is grouped as milestones. For each milestone, a deadline is assigned and an expected outcome checklist is prepared.

Once a milestone is reached, the checklist is evaluated and the reviews are done with the team members. The outcome of the checklist evaluations and the review are recommended and implemented to ensure that the project is meeting its quality standards.

To ensure the tasks are executed on time a Gantt chart is used. The Gantt chart for the project is as follows:

Figure 4: Gantt Chart

Here you can download the entire project source code, User Manual Report.