Project Designing
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
CSMS
View Car Details
Enquiry for Car
Submit
Admin Flow Chart
CSMS
Login
Manage Car Companies /
Manage Car Details
Manage Car Enquiries
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.
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
Visit Website
View Car details
Enquire for cars
View Showroom
Details
1) Use Case Diagrams Admin
Dashboard
Manage company
Info (Add /update)
Manage Cars
(Add / update)
Manage Enquiries
Manage Website
Pages
Update Profile
Change Password
ENTITY-RELATIONSHIP Diagrams
E-R (Entity-Relationship) Diagram is used to represents the relationship
between entities in the table.
The symbols used in E-R diagrams are:
SYMBOL PURPOSE
Represents Entity sets.
Represent attributes.
Represent Relationship Sets.
Line represents flow
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.
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.
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.
Class Diagram:
The class diagram shows a set of classes, interfaces, collaborations and their
relationships.
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
Output Screen of Project
Home Page
Search Car Page
Car Detail Page
Car Listing Page
About US Page
Car Company
Contact Us
Admin Login Page
Admin Dashboard
Add Company
Manage Company
Add Car
Manage Car
Enquiry Page
Search Enquiry
About Us
Contact Us
Admin Profile
Change Password
Forget Password
Reset Password
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.
Biblography
For PHP
[Link]
[Link]
[Link]
For MySQL
[Link]
[Link]
For XAMPP
[Link]