THE PROJECT ENTITLE

“CAR RENTAL MANAGEMENT SYSTEM “

A PROJECT SUBMITTED TO

University of Technology, Jaipur

(Rajasthan)

IN PARTIAL FULFILLMENT FOR THE AWARD OF THE DEGREE OF

Bachelors In Computer Application

Batch = 2020- 2023

Submitted by: submitted to:

1
 TABLE OF CONTENT
SL.NO CONTENTS PAGE NO.

CHAPTER-1 INTRODUCTION TO PROJECT

1.1 ABSTRACT 6
1.2 PROBLEM STATEMENT 7
1.3 MODULE DESCRIPTION 7
CHAPTER-2 SYSTEM ANALYSIS
2.1 REQUIREMENT SPECIFICATION 9
2.2 HARDWARE REQUIREMENTS 9
2.3 SOFTWARE REQUIREMENTS 10
2.3.1 INTRODUCTION TO HTML 10
2.3.2 INTRODUCTION TO CSS 11
2.3.3 INTRODUCTION TO PHP 11
2.3.4 INTRODUCTION TO MYSQL 12
2.3.5 INTRODUCTION TO XAMPP 13
2.4 EXISTING SYSTEM 14
2.5 PROPOSED SYSTEM 14
CHAPTER-3 SYSTEM DESIGN
3.1 TABLE STRUCTURE 15
3.2 DATA FLOW DIAGRAM 18
3.3 FORM DESIGN 19
CHAPTER-4 CODING AND DEVELOPMENT
4.1 SOURCE CODE 22
CHAPTER-5 TESTING AND IMPLEMENTATION
5.1 INTORDUCTION TO TESTING 49
5.2 TYPES OF TESTING 51
CHAPTER-6 CONCLUSION
6.1 FUTURE ENHANCEMENT 52
CHAPTER-7 BIBLIOGRAPHY 53

5
 CHAPTER 1

INTRODUCTION TO PROJECT

1.1 ABSTRACT

The project “Online auction project” is the website aimed at carrying out
bidding. This is like an auction house provided online where in this users
can take part from the comfort of their homes. This site also brings the
auction to the auction to the fingertips of the aspiring bidders and sellers to
a wider section of the product. In this particular website, where buyers and
sellers interact each other to exchange products to get a fair deal.

6
1.2 PROBLEM STATEMENT

ONLINE AUCTION SYSTEM

A online auction system is being designed for the user, so that they can easily take
part in the bidding conducted online. The bidding takes place in a normal form way
the people interested to buying the things placed in auction are supposed to bid for
the particular product in a particular time period. The person placing the highest
bid gets the right to own the item at the end of the bid. Bid is the exact amount of
money offered on an item in auction in the bid by seller. The buyer with the
highest bid is the one who finalizes the purchase of the item with the seller of the
item. Winner is generally the person offering the highest bidding amount is called
the winner of the auction.

1.3 MODULE DESCRIPTION:

1. Login:
The login Module, consists of two sub modules:
 User Login- In this module, user can access this webpage and can
bid for his desired product.
 Admin login-In this module , the admin can login and add the
products for bidding purpose

2. Product:

This module contains two sub modules:

 Current bidding- In this module, the current bidding products are

display.
 Completed bidding- In this module, the products that are
completed for bidding are displayed.

7
3. Profile:

This module contains two sub modules:

 Update: In this module, the users can update their profile.

 Change password: In this module, the users can change their
password.

4. Feedback:

In this module, the users can send their feedback about the
website.

8
 CHAPTER 2

SYSTEM ANALYSIS
2.1 SOFTWARE REQUIREMENT SPECIFICATION

Software requirements specification (SRS) is a description of

a software system to be developed. It is modelled after Amit Singh
Rewets’ business requirements specification (CONOPS), also known as
a stakeholder requirements specification. The software requirements
specification lays out functional and non-functional requirements, and it
may include a set of use cases that describe user interactions that the
software must provide.
Software requirements specification establishes the basis for an agreement
between customers and contractors or suppliers on how the software
product should function (in a market-driven project, these roles may be
played by the marketing and development divisions). Software
requirements specification is a rigorous assessment of requirements before
the more specific system design stages, and its goal is to reduce later
redesign. It should also provide a realistic basis for estimating product
costs, risks, and schedules. Used appropriately, software requirements
specifications can help prevent software project failure.
The software requirements specification document lists sufficient and
necessary requirements for the project development. To derive the
requirements, the developer needs to have clear and thorough
understanding of the products under development. This is achieved
through detailed and continuous communications with the project team and
customer throughout the software development process.
2.2 HARDWARE REQUIREMENTS

 Processor Intel CORE I3

 Main Memory 8GB
 Hard Disk Capacity 1 TB
 Keyboard 101 keys
 Monitor VGA with resolution

9
 2.3 SOFTWARE REQUIREMENT

 Server Scripting Language:PHP 7.2.3

 Client Scripting Language:Javascript
 Web application server:apache 2.4
 Markup Language:HTML 5
 DBMS:MS SQL Server 2014
 Web Browser:Google chrome
 Operating system:windows 10

2.3.1 INTRODUCTION TO HTML

Hypertext Mark-up Language (HTML) is the standard mark-up language
and JavaScript, it forms a triad of cornerstone technologies for the World
Wide Web.
Web browsers receive HTML documents from a web server or from local
storage and render the documents into multimedia web pages. HTML
describes the structure of a web page semantically and originally included
cues for the appearance of the document.
HTML elements are the building blocks of HTML pages. With HTML
constructs, images and other objects such as interactive forms may be
embedded into the rendered page. HTML provides a means to
create structured documents by denoting structural semantics for text such
as headings, paragraphs, lists, links, quotes and other items. HTML
elements are delineated by tags, written using angle brackets.
HTML can embed programs written in a scripting language such
as JavaScript, which affects the behaviour and content of web pages.
Inclusion of CSS defines the look and layout of content. The World Wide
Web Consortium (W3C), maintainer of both the HTML and the CSS
standards, has encouraged the use of CSS over explicit presentational
HTML since 1997.
.

10
2.3.2 INTRODUCTION TO CSS
Cascading Style Sheets (CSS) is a style sheet language used for
describing the presentation of a document written in a markup
language like HTML.CSS is a cornerstone technology of the World Wide
Web, alongside HTML and JavaScript.
CSS is designed to enable the separation of presentation and content,
including layout, colours, and fonts. This separation can improve
content accessibility, provide more flexibility and control in the specification
of presentation characteristics, enable multiple web pages to share
formatting by specifying the relevant CSS in a separate .css file, and
reduce complexity and repetition in the structural content.
Separation of formatting and content also makes it feasible to present the
same markup page in different styles for different rendering methods, such
as on-screen, in print, by voice (via speech-based browser or screen
reader), and on Braille-based tactile devices. CSS also has rules for
alternate formatting if the content is accessed on a mobile device.
The name cascading comes from the specified priority scheme to
determine which style rule applies if more than one rule matches a
particular element. This cascading priority scheme is predictable.
The CSS specifications are maintained by the World Wide Web
Consortium (W3C). Internet media type (MIME type) text/css is
registered for use with CSS by RFC 2318 (March 1998). The W3C
operates a free CSS validation service for CSS documents.

11
2.3.3 INTRODUCTION TO PHP

PHP: Hypertext Preprocessor (or simply PHP) is a server-side

scripting language designed for web development but also used as
a general-purpose programming language. It was originally created
by Rasmus Lerdorf in 1994, the PHP reference implementation is now
produced by The PHP Group.PHP originally stood for Personal Home
Page, but it now stands for the recursive acronym PHP: Hypertext
Preprocessor.
PHP code may be embedded into HTML code, or it can be used in
combination with various web template systems, web content management
systems, and web frameworks. PHP code is usually processed by a
PHP interpreter implemented as a module in the web server or as
a Common Gateway Interface (CGI) executable. The web server combines
the results of the interpreted and executed PHP code, which may be any
type of data, including images, with the generated web page. PHP code
may also be executed with a command-line interface (CLI) and can be
used to implement standalone graphical applications.
The standard PHP interpreter, powered by the Zend Engine, is free
software released under the PHP License. PHP has been widely ported
and can be deployed on most web servers on almost every operating
system and platform, free of charge.
The PHP language evolved without a written formal specification or
standard until 2014, leaving the canonical PHP interpreter as a de
facto standard. Since 2014 work has gone on to create a formal PHP
specification.
During the 2010s there have been increased efforts towards
standardisation and code sharing in PHP applications by projects such
as PHP-FIG in the form of PSR-initiatives as well as Composer
dependency manager and the Packagist repository.

12
2.3.4 INTRODUCTION TO MYSQL

MySQL is an open-source relational database management system. Its

name is a combination of "My”, the name of co-founder Michael Widenius's
daughter, and "SQL", the abbreviation for Structured Query Language. The
MySQL development project has made its source code available under the
terms of the GNU General Public License, as well as under a variety
of proprietary agreements. MySQL was owned and sponsored by a
single for-profit firm, the Swedish company MySQL AB, now owned
by Oracle Corporation. For proprietary use, several paid editions are
available, and offer additional functionality.
MySQL is a central component of the LAMP open-source web application
software stack (and other "AMP" stacks). LAMP is an acronym for
"Linux, Apache, MySQL, Perl/PHP/Python". Applications that use the
MySQL database include: TYPO3, MODx, Joomla, WordPress, Simple
Machines Forum, phpBB, MyBB, and Drupal.
The MySQL server software itself and the client libraries use dual-
licensing distribution. They are offered under GPL version 2, beginning
from 28 June 2000 (which in 2009 has been extended with
a FLOSS License Exception) or to use a proprietary license.
Support can be obtained from the official manual. Free support additionally
is available in different IRC channels and forums. Oracle offers paid
support via its MySQL Enterprise products. They differ in the scope of
services and in price. Additionally, a number of third party organisations
exist to provide support and services, including MariaDB and Percona.

13
2.3.5 INTRODUCTION TO XAMPP

XAMPP is a free and open source cross-platform web server solution

stack package developed by Apache Friends, consisting mainly of
the Apache HTTP Server, MariaDB database, and interpreters for scripts
written in the PHP and Perl programming languages.XAMPP stands for
Cross-Platform (X), Apache (A), MariaDB (M), PHP (P) and Perl (P). It is a
simple, lightweight Apache distribution that makes it extremely easy for
developers to create a local web server for testing and deployment
purposes. Everything needed to set up a web server – server application
(Apache), database (MariaDB), and scripting language (PHP) – is included
in an extractable file. XAMPP is also cross-platform, which means it works
equally well on Linux, Mac and Windows. Since most actual web server
deployments use the same components as XAMPP, it makes transitioning
from a local test server to a live server extremely easy as well.
XAMPP can exist on a single computer, and any given instance can be
copied from one computer to another. XAMPP is offered in both a full and a
standard version (Smaller version).

14
2.3EXISTING SYSTEM

A detailed study of the process must be made by the various techniques like
interviews, questionaries etc. The data collected by the sources must be
scrutinized to arrive to a conclusion. The conclusion is an understanding of how
the system functions. The system is called existing system. Now the existing
system is subjected to case study and problem area are identified. The designer
now functions as a problem solver and tries to sort out the difficulties that the
enterprise faces.

2.5 PROPOSED SYSTEM

The aim of proposed system is to develop a system of improved facilities. The

proposed system can overcome all the limitations of the existing system. The
system provides proper security and reduces the manual work.

 Security of work
 Ensure data accuracy
 Minimize time needed for the various processing
 Greater efficiency
 Better services

15
 CHAPTER 3

SYSTEM DESIGN

3.1 Table Structure

 Login Table

Sl.no Name Datatype Constraints Description

1. Username Varchar Not Null Enter the Username
2. Password Varchar Not Null Enter the Password

 Sign Up Table

Sl,no Name Datatype Constraints Description

1. Fname Varchar NotNull Enter the firstname
2. Lastname Varchar NotNull Enter the lastname
3. Email Varchar NotNull Enter the emai
4. Mob Bigint NotNull Enter the contact
number
5. Uname Varchar NotNull Enter the username
6. Pass Varchar NotNull Enter the password
7. Supervisor Text NotNull To check admin or not
8. SecurityQuestion Varchar NotNull Enter the
securityquestion
9. SecurityAnswer Varchar NotNull Enter the securityanswer

16
  Products Table

Sl.no Name Datatype Constraint Description

s
1. Prod_ID Int Not Null Id for an product
2. Image_id Int Not Null Id for image
3. Username Varchar Not Null Enter the usrname
4. Prodname Varchar Not Null Name of the prduct
5. Description Varchar Not Null Description of the product
6. Price Double Not Null Enter the price of the
product
7. Bid end date Datetime Not null Enter the end date of bid
8. SellerName Varchar Not Null Enter the seller name
9. SellerAddre Varchar Not Null Enter the address of the
ss seller
10. SellerPhone Bigint NotNull Enter the contact number

 FeedBack Table

Sl.No Name Datatype Constraints Description

1. Name varchar NotNull Enter the name
2. EmailID varchar NotNull Enter the emailed
3. Subject Varchar NotNull Enter the subject
4. Message varchar NotNull Enter the message

17
  User Bid

Sl.no. Name Datatype Constraints Description

1. BidID Varchar NotNull Enter the bid id
2. ProdID Varchar NotNull Enter the prodid
3. UserName Varchar Null Enter the username
4. BidAmount Double NotNull Enter the amount
5. Bidwinner Int NotNull Displays the winner

18
3.2 DATA FLOW DIAGRAM

19