CAR SHOWROOM MANAGEMENT SYSTEM

Chapter-1
Introduction
This is software which can be used by a car showroom center for keeping the records of cars.
It helps to show the cars information over the web.

In proposed system we do not have to maintain everything manually. Through this system if
any enquiry occurs it is corresponding entries is done automatically because database
management system gives facility of having relationship between the tables.

In proposed system we do not have to maintain record manually.

Advantages of proposed System

• Easy to generate report for any transaction.

• It is very much faster than manual system.
• Easy and fastest record finding technique.
• It is very much flexible to work.
• Man power required is very less.
• Data can be stored for a longer period.

In this project, we use PHP and MySQL database. It has two modules

1. User

2. Admin

User module:

• user can view the website and checkout the information about cars and they can also
enquiry about the car.

Admin module:

• Admin is the super user of the website who can manage everything on the website.
Admin can log in through the login page
• Dashboard: In this section, admin can see all detail in brief like the total car company,
Total Enquiry, and Total Car Listed
• Company Info: In this section, admin can mange car company information
(add/update).
• Car info. In this section, admin can manage car information(add/update). Enquiry: In
this section, admin can view and maintain the enquiry.
• Search Enquiry: In this section, admin can search enquiry with the help of enquiry
number.
• Pages: n this section, admin can manage about us and contact us pages.
• Admin can also update his profile, change the password and recover the password

Dept of CSE,GITAM Bengaluru Page 1

CAR SHOWROOM MANAGEMENT SYSTEM

Chapter-2
Objectives
Easy to generate report for any transaction.

It is very much faster than manual system.

Easy and fastest record finding technique.

It is very much flexible to work.

Man power required is very less.

Data can be stored for a longer record.

2.1 System Requirements

Hardware requirement:-

This software requires following minimum hardware configuration:

• Processor: Pentium-iv and above

• RAM: 256 MB
• Hard Disk: 4.3GB
• Floppy Disk: 1.44 MB
• CD Drive
• Monitor-15” Color Monitor

Software Requirement:-

1. OS : Windows XP

2.PHP Triad (PHP, MySQL, Apache, and PHPMyAdmin)

Dept of CSE,GITAM Bengaluru Page 2

CAR SHOWROOM MANAGEMENT SYSTEM

Chapter-3
Software Features

3.1 PHP TRIAD

• PHPTriad installs a complete working PHP/MySQL server environment on Windows

platforms (9x/ NT). Installs PHP, MySQL, Apache, and PHPMyAdmin.

3.2 PHP
PHP is a scripting language originally designed for producing dynamic web pages. It has
evolved to include a command line interface capability and can be used in standalone
graphical applications. While PHP was originally created by Rasmus Lerdorf in 1995, the
main implementation of PHP is now produced by The PHP Group and serves as the de facto
standard for PHP as there is no formal specification. PHP is free software released under the
PHP License, however it is incompatible with the GNU General Public License (GPL), due to
restrictions on the usage of the term PHP. It is a widely-used general-purpose scripting
language that is especially suited for web development and can be embedded into HTML. It
generally runs on a web server, taking PHP code as its input and creating web pages as
output. It can be deployed on most web servers and on almost every operating system and
platform free of charge. PHP is installed on more than 20 million websites and 1 million web
servers.

PHP originally stood for Personal Home Page. It began in 1994 as a set of Common Gateway
Interface binaries written in the C programming language by the Danish/Greenlandic
programmer Rasmus Lerdorf. Lerdorf initially created these Personal Home Page Tools to
replace a small set of Perl scripts he had been using to maintain his personal homepage. The
tools were used to perform tasks such as displaying his résumé and recording how much
traffic his page was receiving. He combined these binaries with his Form Interpreter to create
PHP/FI, which had more functionality. PHP/FI included a larger implementation for the C
programming language and could communicate with databases, enabling the building of
simple, dynamic web applications.

Lerdorf released PHP publicly on June 8, 1995 to accelerate bug location and improve the
code. This release was named PHP version 2 and already had the basic functionality that PHP
has today. This included Perl-like variables, form handling, and the ability to embed HTML.
The syntax was similar to Perl but was more limited, simpler, and less consistent. Zeev
Suraski and Andi Gutmans, two Israeli developers at the Technion IIT, rewrote the parser in
1997 and formed the base of PHP 3, changing the language’s name to the recursive initialism
PHP: Hypertext Preprocessor. The development team officially released PHP/FI 2 in
November 1997 after months of beta testing. Afterwards, public testing of PHP 3 began, and
the official launch came in June 1998. Suraski and Gutmans then started a new rewrite of

Dept of CSE,GITAM Bengaluru Page 3

CAR SHOWROOM MANAGEMENT SYSTEM

PHP’s core, producing the Zend Engine in 1999. They also founded Zend Technologies in
Ramat Gan, Israel.

On May 22, 2000, PHP 4, powered by the Zend Engine 1.0, was released. On July 13, 2004,
PHP 5 was released, powered by the new Zend Engine II. PHP 5 included new features such
as improved support for object-oriented programming, the PHP Data Objects extension
(which defines a lightweight and consistent interface for accessing databases), and numerous
performance enhancements. The most recent update released by The PHP Group is for the
older PHP version 4 code branch.

In 2008, PHP 5 became the only stable version under development. Late static binding has
been missing from PHP and will be added in version 5.3. PHP 6 is under

development alongside PHP 5. Major changes include the removal of register_globals, magic
quotes, and safe mode. The reason for the removals was because register_globals had given
way to security holes, and magic quotes had an unpredictable nature, and was best avoided.
Instead, to escape characters, Magic quotes may be substituted with the addslashes() function,
or more appropriately an escape mechanism specific to the database vendor itself like
mysqli_real_escape_string() for MySQL.

PHP does not have complete native support for Unicode or multibyte strings; Unicode
support will be included in PHP 6. Many high profile open source projects ceased to support
PHP 4 in new code as of February 5, 2008, due to the GoPHP5 initiative, provided by a
consortium of PHP developers promoting the transition from PHP 4 to PHP 5. It runs in both
32-bit and 64-bit environments, but on Windows the only official distribution is 32-bit,
requiring Windows 32-bit compatibility mode to be enabled while using IIS in a 64-bit
Windows environment. There is a third-party distribution available for 64-bit Windows.

syntax
<html>

<head>

<title>PHP Test</title>

</head>

<body>

<?php echo “<p> Hello World </p>”; ?>

</body></html>

PHP only parses code within its delimiters. Anything outside its delimiters is sent directly to
the output and is not parsed by PHP. The most common delimiters are <?php and ?>, which
are open and close delimiters respectively. <script language=”php”> and </script> delimiters

Dept of CSE,GITAM Bengaluru Page 4

CAR SHOWROOM MANAGEMENT SYSTEM

are also available. Short tags can be used to start PHP code, <? or <?= (which is used to echo
back a string or variable) and the tag to end PHP code, ?>. These tags are commonly used,
but like ASP-style tags (<% or <%= and %>), they are less portable as they can be disabled in
the PHP configuration. For this reason, the use of short tags and ASP-style tags is
discouraged. The purpose of these delimiters is to separate PHP code from non-PHP code,
including HTML.

Variables are prefixed with a dollar symbol and a type does not need to be specified in
advance. Unlike function and class names, variable names are case sensitive. Both double-
quoted (“”) and heredoc strings allow the ability to embed a variable’s value into the string.
PHP treats newlines as whitespace in the manner of a free-form language (except when inside
string quotes), and statements are terminated by a semicolon. PHP has three types of
comment syntax: /* */ serves as block comments, and // as well as # are used for inline
comments. The echo statement is one of several facilities PHP provides to output text (e.g. to
a web browser). In terms of keywords and language syntax, PHP is similar to most high level
languages that follow the C style syntax. If conditions, for and while loops, and function
returns are similar in syntax to languages such as C, C++, Java and Perl.

Dept of CSE,GITAM Bengaluru Page 5

CAR SHOWROOM MANAGEMENT SYSTEM

Chapter-4
MySQL
What is a database?

Quite simply, it’s an organized collection of data. A database management system (DBMS)
such as Access, FileMaker Pro, Oracle or SQL Server provides you with the software tools
you need to organize that data in a flexible manner. It includes facilities to add, modify or
delete data from the database, ask questions (or queries) about the data stored in the database
and produce reports summarizing selected contents.

MySQL is a multithreaded,multi-user SQL database management system(DBMS). The basic

program runs as a server providing multi-user access to a number of databases.Originally
financed in a similar fashion to the JBoss model, MySQL was owned and sponsored by a
single for-profit firm, the Swedish company MySQLAB now a subsidiary of Sun
Microsystem , which holds the copyright to most of the codebase. The project’s source code
is available under terms of the GNU General Public Licence, as well as under a variety of
proprietory agreements.

MySQL is a database.The data in MySQL is stored in database objects called tables.A table is
a collections of related data entries and it consists of columns and rows.Databases are useful
when storing information categorically. A company may have a database with the following
tables: “Employees”, “Products”, “Customers” and “Orders”. Database Tables

A database most often contains one or more tables. Each table is identified by a name (e.g.
“Customers” or “Orders”). Tables contain records (rows) with data.

Queries:
A query is a question or a request. With MySQL, we can query a database for specific
information and have a record set returned.

Create a connection to a database

Before you can access data in a database, you must create a connection to the database. In
PHP, this is done with the mysqli_connect() function.

Dept of CSE,GITAM Bengaluru Page 6

CAR SHOWROOM MANAGEMENT SYSTEM

Example

In the following example we store the connection in a variable ($con) for later use in the
script. The “die” part will be executed if the connection fails

Dept of CSE,GITAM Bengaluru Page 7

CAR SHOWROOM MANAGEMENT SYSTEM

Chapter-5
phpMyAdmin
phpMyAdmin is an open source tool written in PHP intended to handle the administration of
MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with
MySQL.Currently it can create and drop databases, create/drop/alter tables, delete/edit/add
fields, execute any SQL statement, manage users and permissions, and manage keys on
fields. while you still have the ability to directly execute any SQL statement. phpMyAdmin
can manage a whole MySQL server (needs a super-user) as well as a single database. To
accomplish the latter you’ll need a properly set up MySQL user who can read/write only the
desired database. It’s up to you to look up the appropriate part in the MySQL manual.

phpMyAdmin can:

•browse and drop databases, tables, views, fields and indexes

•create, copy, drop, rename and alter databases, tables, fields and indexes

•maintenance server, databases and tables, with proposals on server configuration

•execute, edit and bookmark any SQL-statement, even batch-queries

•load text files into tables

•create and read dumps of tables•export data to various formats: CSV, XML, PDF, ISO/IEC
26300 - OpenDocument Text and Spreadsheet, Word, Excel and LATEX formats

•administer multiple servers

•manage MySQL users and privileges

•check referential integrity in MyISAM tables

•using Query-by-example (QBE), create complex queries automatically connecting required

tables

•create PDF graphics of your Database layout • search globally in a database or a subset
of it

•transform stored data into any format using a set of predefined functions, like displaying
BLOB-data as image or download-link

•support InnoDB tables and foreign keys

•support mysqli, the improved MySQL extension

Dept of CSE,GITAM Bengaluru Page 8

CAR SHOWROOM MANAGEMENT SYSTEM

5.1 Apache Web server

Often referred to as simply Apache, a public-domain open source Web server developed by a
loosely-knit group of programmers. The first version of Apache, based on the NCSA httpd
Web server, was developed in 1995.

Core development of the Apache Web server is performed by a group of about 20 volunteer
programmers, called the Apache Group. However, because the source code is freely
available, anyone can adapt the server for specific needs, and there is a large public library of
Apache add-ons. In many respects, development of Apache is similar to development of the
Linux operating system.

The original version of Apache was written for UNIX, but there are now versions that run
under OS/ 2, Windows and other platforms. The name is a tribute to the Native American
Apache Indian tribe, a tribe well known for its endurance and skill in warfare. A common
misunderstanding is that it was called Apache because it was developed from existing NCSA
code plus various patches, hence the name a patchy server, or Apache server. Apache
consistently rates as the world’s most popular Web server according to analyst surveys.
Apache has attracted so much interest because it is full-featured, reliable, and free. Originally
developed for UNIX™ operating systems, Apache has been updated to run on Windows,
OS/2, and other platforms. One aspect of Apache that some site administrators find confusing
— especially those unfamiliar with UNIX-style software — is its configuration scheme.
Instead of using a point-and-click graphic user interface (GUI) or Windows Registry keys as
most other modern software packages, Apache generally relies on simple text files for its
configuration settings.

Dept of CSE,GITAM Bengaluru Page 9

CAR SHOWROOM MANAGEMENT SYSTEM

Chapter-6
System Analysis and Design
6.1 Feasibility study
A feasibility analysis is undertaken to determine the possibility or probability of either
improving the existing system or developing a completely new system.

It helps to obtain an overview of the problem and to get rough assessment of

whether feasible solution exists.

There are three aspects in feasibility study portion of the preliminary investigation.

1) Operational feasibility

2) Technical feasibility

3) Economical feasibility

6.2 Operational feasibility

It is a measure of how well a proposed system solves the problems, and takes advantages of
the opportunities identified during scope definition and how it satisfies the requirements
identified in the requirements analysis phase of system development.

Operational feasibility covers two aspects. One is the technical performance aspect and other
is the acceptance within the organization. Operational feasibility determines how the
proposed system will fit the current operations and what, if any job restructuring and
retraining may be needed to implement the system.

In the system operational feasibility checks, whether the user who is going to use the system
is able to work with the software with which the system id coded and also the mind of the
user going to use system. If the user does not understand or is able to work on the system
further development is waste.

The system is easy to learn and it will require a vary short time to learn the operation of the
system for a person having knowledge in accounting. So that system was operationally
feasible

6.3Technical feasibility :
This involves questions such as whether the technology needed for the system exists, how
difficult it will be to build, and whether the firm has enough experience using that
technology. The assessment is based on an outline design of system requirements in terms of
Input, Processes, Output, Fields, Programs, and Procedures. This can be quantified in terms
of volumes of data, trends, frequency of updating, etc. in order to estimate whether the new
system will perform adequately or not.

Dept of CSE,GITAM Bengaluru Page 10

CAR SHOWROOM MANAGEMENT SYSTEM

The technical feasibility in the proposed system deals with the technology used in the system.
It deals with the hardware and software used in the system whether they are of latest
technology or not. It happens that after a system is prepared a new technology arises and the
user wants the system based on that technology. Thus it is important to check the system to
be technically feasible.The minimum memory requirement is 32MB of RAM while 64MB is
better to have for better performance. As far as software is concerned, MySQL and PHP
should be installed on the server.

6.4 Economic feasibility :

Economic analysis is the most frequently used method for evaluating the effectiveness of a
new system. More commonly known as cost/benefit analysis, the procedure is to determine
the benefits and savings that are expected from a candidate system and compare them with
costs. If benefits outweigh costs, then the decision is made to design and implement the
system.

Implementation of this system will be a lifetime investment, which will ensure returns to the
store of good services and market value throughout the future. So the system is found
economically feasible.

Dept of CSE,GITAM Bengaluru Page 11

CAR SHOWROOM MANAGEMENT SYSTEM

Chapter-7
Project Designing
7.1 Design Document
•The entire system is projected with a physical diagram which specifics the actual storage
parameters that are physically necessary for any database to be stored on to the disk. The
overall systems existential idea is derived from this diagram.

•The relation upon the system is structure through a conceptual ER-Diagram, which not only
specifics the existential entities but also the standard relations through which the system
exists and the cardinalities that are necessary for the system state to continue.

•The content level DFD is provided to have an idea of the functional inputs and outputs that
are achieved through the system. The system depicts the input and output standards at the
high level of the systems existence.

user flow chart

Dept of CSE,GITAM Bengaluru Page 12

CAR SHOWROOM MANAGEMENT SYSTEM

Admin Flow Chart

7.2 Unified Modeling Language Diagrams(UML)

•The unified modeling language allows the software engineer to express an analysis model
using the modeling notation that is governed by a set of syntactic semantic and pragmatic
rules.

•A UML system is represented using five different views that describe the system from
distinctly different perspective. Each view is defined by a set of diagram, which is as follows.

User Model View

i.This view represents the system from the users perspective.

ii.The analysis representation describes a usage scenario from the end-users perspective.

Structural model view

In this model the data and functionality are arrived from inside the system.

This model view models the static structures.

Dept of CSE,GITAM Bengaluru Page 13

CAR SHOWROOM MANAGEMENT SYSTEM

Behavioral Model View

• It represents the dynamic of behavioral as parts of the system, depicting the

interactions of collection between various structural elements described in the user
model and structural model view.

Implementation Model View

• In this the structural and behavioral as parts of the system are represented as they are
to be built.

Environmental Model View In this the structural and behavioral aspects of the environment
in which the system is to be implemented are represented.

UML is specifically constructed through two different domains they are

• UML Analysis modeling, which focuses on the user model and structural model
views of the system?
• UML design modeling, which focuses on the behavioral modeling, implementation
modeling and environmental model views.
1) Use Case Diagrams user

Dept of CSE,GITAM Bengaluru Page 14

CAR SHOWROOM MANAGEMENT SYSTEM

1) Use Case Diagrams Admin

7.3 Entity-relationship diagrams

E-R (Entity-Relationship) Diagram is used to represents the relationship between entities in
the table.

Structured analysis is a set of tools and techniques that the analyst.

To develop a new kind of a system:

The traditional approach focuses on the cost benefit and feasibility analysis, Project
management, and hardware and software selection a personal considerations.

Dept of CSE,GITAM Bengaluru Page 15

CAR SHOWROOM MANAGEMENT SYSTEM

Dept of CSE,GITAM Bengaluru Page 16

CAR SHOWROOM MANAGEMENT SYSTEM

Chapter-8
Database design
The data in the system has to be stored and retrieved from database. Designing the database is
part of system design. Data elements and data structures to be stored have been identified at
analysis stage. They are structured and put together to design the data storage and retrieval
system.

A database is a collection of interrelated data stored with minimum redundancy to serve

many users quickly and efficiently. The general objective is to make database access easy,
quick, inexpensive and flexible for the user. Relationships are established between the data
items and unnecessary data items are removed. Normalization is done to get an internal
consistency of data and to have minimum redundancy and maximum stability. This ensures
minimizing data storage required, minimizing chances of data inconsistencies and optimizing
for updates. The MS Access database has been chosen for developing the relevant databases.

Car Showroom Management System (csms) contains 5 MySQL tables :

tbladmin table Structure : This table store the login details of admin.

tblcompany table structure : This table store car company info.

Dept of CSE,GITAM Bengaluru Page 17

CAR SHOWROOM MANAGEMENT SYSTEM

tblcars table structure : This table store full car details.

tblenquiry table structure : This table store car enquiry details.

tblpages table structure : This table store car pages details.

Dept of CSE,GITAM Bengaluru Page 18

CAR SHOWROOM MANAGEMENT SYSTEM

Class Diagram:

The class diagram shows a set of classes, interfaces, collaborations and their relationships.

Dept of CSE,GITAM Bengaluru Page 19

CAR SHOWROOM MANAGEMENT SYSTEM

8.1 Testing
System testing is a series of different test whose primary purpose is to fully exercise
computer based system.

We can say that it will run according to its specifications and in the way users expect. Special
test data are input for processing, and the results examined. A limited number of users may be
allowed to use the system so that analyst can see whether they try to use it in unforeseen
ways. It is desirable to discover any surprises before the organization implements the system
and depends on it.

• We follow Black Box testing.

• Black box testing attempts to find errors in following
• Incorrect or missing function
• Interface errors
• Errors in data structure
• Initialization and termination errors

Dept of CSE,GITAM Bengaluru Page 20

CAR SHOWROOM MANAGEMENT SYSTEM

Chapter-9
Conclusion

• The project titled as Car Showroom Management System was deeply studied and
analyzed to design the code and implement. It was done under the guidance of the
experienced project guide. All the current requirements and possibilities have been
taken care during the project time.
•
• Car Showroom management system is used for daily operations in any organization
to maintain or access employee related information for internal administration
purposes.

Dept of CSE,GITAM Bengaluru Page 21