Download - VAMS Documentation
-
7/28/2019 VAMS Documentation
1/58
1
CAR SHOWROOM MANAGEMENT SYSTEM
Submitted in partial fulfilment of the requirement for the award of the
Degree of Masters of Computer Application
Name of candidate : Ansan Jose
Register No : 10CIMCA009
Name of specialization : M.C.A
Partner institution : Chinmaya Institute of Management & Technology
Under the guidance of
RESHMI
(Lecturer of Chinmaya institute of management & technology)
Centre for Participatory and Online Programmes
Bharathiar University
Coimbatore-641046
DECEMBER 2012
-
7/28/2019 VAMS Documentation
2/58
2
CERTIFICATE
This is to certify that the project work entitled Car
Showroom Management System submitted to Bharathiar University in partial
fulfilment of the requirements for the award of the Degree of Masters of
Computer Application in is a record of the original work done by ANSAN JOSE
under my supervision and guidance and that this project work has not formed the
basis for the award of any Degree/Diploma/associate ship/Fellowship or similar
title to any candidate of any university.
(Seal) Signature of the guide
Reshmi
(Lecturer of CIMT)
Forwarded by
Director/Principal
Partner institution
Centre for Participatory & online Programmes
Bharathiar University
Coimbatore-46
Submitted for University Examination held on:
Internal Examiner External Examiner
-
7/28/2019 VAMS Documentation
3/58
3
DECLARATION
I hereby declare that this project work titled Car Showroom
management system is a record of original work done by me under the guidance
of Reshmi and that this project work has not formed the basis for the award of
any Degree/Diploma/Associate ship/Fellowship or similar title to any candidate
of any university.
Signature
Name : Ansan Jose
Course with specialization : M.C.A
Result :
Date :
Countersigned By
Signature of guide (with Seal)
-
7/28/2019 VAMS Documentation
4/58
4
ACKNOWLEDGEMENT
If words considered as symbol of approval and tokens of
knowledge, let me use these few words for expressing our gratitude to one and all.
I express my sincere thanks to our honourable principal
Dr.RAVEENDRANATHAN for granting me permission to work on this project.
I also extend my thanks to our department faculty members,
who were always ready to help me to achieve my task. I also express my
heartfelt thanks to my guide Mrs. Reshmi and to my class teacherMrs.Uma
Maheswari , to my beloved parents for their constant support and also would
like to express my mindful thanks to my Friends for their great suggestion for the
completion of my project.
-
7/28/2019 VAMS Documentation
5/58
5
SYNOPSIS
-
7/28/2019 VAMS Documentation
6/58
6
SYNOPSIS
The project entitled Car showroom management system is
developed using VB.net 2005 as front end and MS Access as back end. This Car
showroom management software is general software developed for managing the
car showroom. It is done either by sales the car or by purchasing the car to the
showroom. So this project involves the modules like introduction of products to
customers by catalogue, booking order, customer registration, sales order,
purchase order, sales billing and report .The main goal of this application is to
maintain Record of sales occurring within a production company. So that this
software help them to maintain day to day transaction of companys sales to a
computer. This proposed system help in many ways. According to the nature of
sales, available products can be sold to a customer and prepare sales billing
efficiently.
Hardware requirements:
Processor : Intel core duo 20 GHz or more
RAM : 1GB or more
Hard disk : 80 GB or more
Monitor : 15CRT or LCD monitors
Keyboard : Normal or multimedia
Mouse : Compactable mouse
Software requirements:
OS : Windows XP, Windows 7
Back end : MS Access
Front end : VB.net
-
7/28/2019 VAMS Documentation
7/58
7
TABLE OF CONTENTS
1. Introduction1.1.
Need for the System1.2. Salient Features of the System
2. Background Study2.1. Existing system2.2. Proposed System
3. Problem Formulation3.1. Main Objectives3.2. Methodology3.3. Platform
4. System Analysis and Design4.1. Fact Finding4.2. Review of written Documents4.3. Feasibility Analysis4.4. Economic Feasibility4.5. Technical Feasibility4.6. Behavioural Feasibility4.7. Input Design4.8. Out Design4.9. Database Design4.10. Database Normalization
5. Development of system and Testing5.1. Fundamental Design Concepts for System Development
5.1.1. Conception5.1.2. Initiation5.1.3. Analysis5.1.4. Design5.1.5. Construction5.1.6. Testing5.1.7. Implementation5.1.8. System Testing5.1.9. Black Box Testing5.1.10. White Box Testing
6. Implementation7. Conclusion8. Future Enhancement
-
7/28/2019 VAMS Documentation
8/58
8
INTRODUCTION
-
7/28/2019 VAMS Documentation
9/58
9
INTRODUCTION
In the world, every sales person and manager is looking
for the showroom management software that could make their task easier. They
hope for car showroom management software that will help them to automate
processes, quickly analyse data and reports and share this data when they need to.
There are many options for showroom management tools.
For optimal showroom management process, you need
robust functionality for managing your logistic facilities. Using this software we
can reduce the cost of warehousing, reduces paperwork of company, reduces time,
transportation of companys products, order fulfilment etc...
Showroom management tools are a group of software
or computer applications that help you manage the sales process for your
business. Showroom management tools include functions that help with data
collection, invoice printing, billing, sales and purchasing order and its necessary
processing. Features of showroom management System can vary greatly, so it is
important that you find one that fits the needs of your business.
Need for this system
You can significantly improve inventory turnover,
optimize flow of goods and shorten routes within your warehouse or distribution
centre. Additional benefits of this software include improved cash flow, visibility;
decision making. This software is user friendly and hence easy to use. We can
also manage the nature of sales and purchase of the company who introduces the
available products from warehouse to customers.
As we know manual system are quite tedious, time consuming,
and less efficient and accurate when compared to a computational system.
-
7/28/2019 VAMS Documentation
10/58
10
This system solves the disadvantages like time consuming, less accuracy, less
efficiency, lots of paperwork, slow data processing, not user friendliness, difficult
to maintain records. This system provides user efficient working environment and
more output can be generated through this. This system provides user friendly
interface resulting in knowing each and every usability features of system. This
system completes the work in a very less time resulting in less time consumption
and high level of efficiency. The calculation made very easy and quickly and
records are directly saved into database and that database can be maintained for
long period of time. Also this system provides high level of security. So that only
admin and specified sales representatives of company can login to the sales
department software to access and work with this software.
Salient features of the system
For any software project the primary parameter that should be
taken into account are time, size and effort. So we need a system where we can
deliver the correct results that would ultimately lead to a position where the
overall cost and time will be consolidated.
Hence the organization which implements such a process
can produce better results. Showroom management software is the application of
knowledge, skills and technologies to project activities to meet the project
requirements.
Manual work is reduced. Retrieval and access of information is easy Transactions are processed quickly
Easy tracking of products We can efficiently and effectively handle stock management accurately
-
7/28/2019 VAMS Documentation
11/58
11
BACKGROUND STUDY
-
7/28/2019 VAMS Documentation
12/58
12
BACKGROUND STUDY
Existing System
In competitive business organization the ability to efficiently
align resources and business activities with strategic objectives can mean the
difference between succeeding and just surviving. To achieve strategic alignment,
organization are increasingly managing their activities and processes as projects-
in essence, projecting their business to monitor performance more closely and
make better business decision above their overall work portfolio.
By planning and tracking projects with clarity and precession,
organizations can respond with greater ability to the demands of fast changing
business environment. Making strategic goals or reality requires technology that
is robust enough to support your core business and yet flexible enough to
accommodate your existing processes. The CAR SHOWROOM
MANAGEMENT SOFTWARE is one of the existing tools that are helpful for
car showroom management. The primary purposes of any such tools are to
improve productivity, reduce cycle time, decreases costs by increasing quality
Drawbacks of the Existing System
Manual system uses huge amounts of papers and stores. Difficulty in tracking and retrieving data from the abundant papers is quite
difficult.
It is not easy to recognize the errors occurred. Time consuming process.
-
7/28/2019 VAMS Documentation
13/58
13
Proposed System
The existing tools do not consider all the factors that affect a
project directly. The entire process is built upon using just one or two parameters
which do not give us complete and desired results. So we need a system where
we can deliver the correct results that would ultimately lead to a position where
the overall cost and time will be consolidated.
We can efficiently and effectively handle stock management processaccurately
Manual work can be reduced Retrieval and access of information is easy Transactions are processed quickly Easy tracking of products
-
7/28/2019 VAMS Documentation
14/58
14
PROBLEM FORMATION
-
7/28/2019 VAMS Documentation
15/58
15
PROBLEM FORMULATION
Main objectives
Manual system uses huge amounts of papers and stores: we can reduce thisproblem using Car showroom management system.
Difficulty in tracking and retrieving data from the abundant papers is quitedifficult. This software makes the entire process easy.
Human activities while handling with the books will always be timeconsuming. Showroom Management tool will save the time.
Using this software we can reduce the cost of warehousing, reducespaperwork of company, reduces time, transportation of companys products,
order fulfilment etc...
This system solves the disadvantages like time consuming, less accuracy, lessefficiency, lots of paperwork, slow data processing, not user friendliness,
difficult to maintain records
Methodology
Methodology means a way of doing things in a structured
manner. The Methodology is designed to help to the part consistently, regardless
of nature of the work, to manage the process involved and solve complex
problem in a structured and co-ordinate manner.
For any software project the primary parameters that should
be taken into account are time, size, and effort. The entire process is built upon
using just one or two parameters which do not give us complete and desired
results. So we need a system where we can deliver the correct results that would
ultimately lead to a position where the overall cost and time will be consolidated.
-
7/28/2019 VAMS Documentation
16/58
16
Platform
Introduction To .Net
.NET is a set of technologies designed to allow
applications to work together whether they reside on the users hard drive, the
local network, a remote computer, or the Internet. It is the common code
framework used by nearly all Microsoft applications, such as Windows, Internet
Explores and IIS Web server, and it is also the framework for third party
application development based on Microsoft technology. Microsoft .NET relies
on standards such as XML, SOAP and UDDI to make it easy for networked
objects to discover other networked objects and communicate with
them. Because .NET applies to almost all Microsoft products, the company
divides .NET into several areas including .NET servers and the .NET
Framework.
. NET Framework
The .NET Framework includes the runtime andcompiles time services required to run a .NET application. Compile time is when
the developer is compiling the source. Runtime is when the compiled code is
executing in memory. At the centre of the runtime execution of .NET code is the
Common Language Runtime (CLR).
What Is Microsoft .NET?
Microsoft .NET is software that connects information,
people, systems, and devices. It spans clients, servers, and developer tools, and
consists of:
The .NET Framework 1.1, used for building and running all kinds ofsoftware, including Web-based applications, smart client applications,
and XML Web servicescomponents that facilitate integration by
sharing data and functionality over a network through standard,
-
7/28/2019 VAMS Documentation
17/58
17
platform-independent protocols such as XML (Extensible Markup
Language), SOAP, and HTTP.
Developer tools, such as Microsoft Visual Studio .NET 2003 whichprovides an integrated development environment (IDE) for maximizing
developer productivity with the .NET Framework.
A set of servers, including Microsoft Windows Server 2003,Microsoft SQL Server, and Microsoft BizTalk Server, that
integrates, runs, operates, and manages Web services and Web-based
applications.
Client software, such as Windows XP, Windows CE, and MicrosoftOffice XP, that helps developers deliver a deep and compelling user
experience across a family of devices and existing products.
The .NET Framework is composed of the common language runtime
and a unified set of class libraries.
.NET Supported Languages
Currently .NET supports the following languages:
C# C++ with Managed Extensions VB .NET ASP.NET (although this one is more a subset of VB .NET) Jscript.NET
In short .NET is:
A platform neutral framework. Layer between the operating system and the programminglanguage.
It supports many programming languages, including VB.NET,C# etc.
-
7/28/2019 VAMS Documentation
18/58
18
NET provides a common set of class libraries, which can beaccessed from any .NET based programming language. There will not
be separate set of classes and libraries for each language. If you know
any one .NET language, you can write code in any .NET language!!
In future versions of Windows, .NET will be freely distributed aspart of operating system and users will never have to install .NET
separately.
VB.NET
Visual Basic .NET is a major component of Microsoft
Visual Studio .NET suite. The .NET version of Visual Basic is a new improved
version with more features and additions. After these new additions, VB qualify
to become a full object-oriented language such as C++. In this article, I will try to
introduce you to VB.NET and will cover new additions to the language. I will
also compare VB 6.0 and VB.NET and how to develop simple applications in
VB.NET. VB.NET is the following version of VB 6.0. Microsoft .NET is a new
programming and operating framework introduced by Microsoft. All .NET
supported languages access a common .NET library to develop applications and
share common tools to execute applications. Programming with Visual Basic
using .NET is called VB.NET.
The Imports Statement
Most of the .Net types are defined in namespaces. A
namespace is a scope in which managed types are defined. If you see .NET
Framework Class Library, youll see hundreds of namespace. For example,
System namespace contains types such as Console, Object and so on. If you want
to access Console class, you need to import System namespace in your
application by using Imports directive. For example, if you want to use the
Console class, which is defined in the System namespace, you need to add the
following line in the application: Imports System.
-
7/28/2019 VAMS Documentation
19/58
19
Features of VB.Net are:
Object Oriented ProgrammingAll managed types in VB are derived from the system.
object class. As your requirements dictate, you can choose to use object-oriented
features.
Structured Error HandlingThis has a clean, concise Structured Exception Handling.
Support Server-side programmingVB.Net has simplified server side programming. Server
Explorer, which is included in the Visual Studio IDE, makes it easy to develop
server-side components and web applications.
Supports inheritanceWe can create one form and inherit from it to create
another one that adds to it functionality.
Supports overloadingWe can create one or more sub or function with the same
name but different parameters. This method is beneficial when we want to apply
the same programming logic for different data types.
Dont support control arraysVb.Net doesnt support control arrays because the
architecture of the .Net framework doesnt support control arrays.
-
7/28/2019 VAMS Documentation
20/58
20
Offers an Integrated Development Environment
The Development Environment of VB.Net is integrated
with that of other. Net languages, Visual c# and Visual C++. Net.This has proved
advantages for all Visual Studio.Net Programming languages. Eg:-A developer
using Visual C# will find it easy to switch to VB,Net and vice-versa.
Integrates with CLR
VB.Net integrates with the .Net framework and generates
code that is targeted at the CLR.The classes and data types used in VB.Net are
from the .Net framework.Therefore,VB.Net applications can achieve
interoperability with other Visual Studio.Net applications that also derived
from .Net framework class.
Supports console-based programming
VB.Net provides VBC.Exe compiler compile console
based applications.
Provides advanced controls
VB.Net provides advanced controls for high level
programming. Eg:-FileSystem Watcher control monitors a directory for the
presence of a file or types of files.
-
7/28/2019 VAMS Documentation
21/58
21
MS ACCESS 2003
Introduction to Databases and RDBMS
A database is a collection of files, a Database Management
System (DBMS) is a program (set of programs) that stores and organizes
data. One such organization method is relational where data is organized by
means of related tables called relations and hence the name Relational Database
Management System (RDBMS). RDBMS stores information in related relations
(tables, subjects) which can be related using common fields.
MS Access is a Relational Database Management System (RDBMS). Like all
database systems MS Access stores database information in a database file (MS
Access uses .mdb extension), MS Access .mdb files store information about your
database objects such as tables, queries, forms, macros, reports, access web
pages, and modules. An RDBMS is used to store, retrieve and update data via
facilities and mechanisms that are supported from within the database system,these mechanisms include tools to:
view the data. update the data. facility to store data (Tables). present data (Forms, Reports, Access Web Pages). generate reports from the database dynamically (Wizards). Security utilitiesonly authorized users can access the database. retrieve subset of the data based on a defined selection criteria (Queries). MS
Access uses Structured Query Language (see query section) to support query
services.
backing up and restoring data. Facilities to share the date
-
7/28/2019 VAMS Documentation
22/58
22
MS Access 2003 supports all these features and provide
objects that are used to implement each tool. the relational database objects that
are supported by MS Access 2003 are organized in a database file. A databasefile is a container for organized tables, queries, forms, reports, access web pages.
and modules. A table object is the fundamental structure that is used to store in-
formation about subjects related to your application (Students, Courses, Instruc-
tors, Employees, etc.). A Query object allows retrieving a subset of the records
from a table or tables. A Form object allows you to create Graphical User Inter-
face (GUI) for accessing your information including adding, updating, deleting,and viewing your data. A report object allows you to print information, calcu-
late total among other things. Pagesobject allows us to generate html files that
are ready to be published on the web. Macros object allows us to create individ-
ual macro actions in response to events (close a form, open form, run a module,
etc.). Modules object allows us to store Visual Basic Code (VBA) to carry cer-
tain tasks such as open a form, update data, trap errors. RDBMS uses storage
and retrieval methods that are based on mathematics which makes RDBMS
more reliable than other DBMS systems. RDBMS uses the following languages:
Data Definition Language (DDL) for defining and organizing tables and theirrelationships.
Data Access Language (DAL) to retrieve and update stored data. Structured Query Language (SQL) is used to support quires (answer ques-
tions about the data).
-
7/28/2019 VAMS Documentation
23/58
23
Table Definitions:
Primary key , are fields in the table that uniquely identifies a record. Oneor more fields whose values uniquely identify each record in a table. Null
values are not allowed in a primary key and a primary key must always have
a unique index. A primary key is used to relate a table to foreign keys in other
tables.
Foreign Key, One or more table fields that refer to the primary key field inanother table. A foreign key indicates how the tables are related.
Candidate key, if a field could uniquely identify a record then its called acandidate key.
Composite key, is a primary key that is made of 2 or more fields. Domain, all entries in table for one attribute belong to the same domain
which is a list of all possible values of an attribute. For example US states is
the domain for a states field.
Indexes , A feature that speeds up searching and sorting in a table basedon key values and can enforce uniqueness on the rows in a table. The primary
key of a table is automatically indexed. Some fields can't be indexed because
of their data type such memo fields.
Relationships
Relationships are used to extract information form multi-ple tables (i.e., to join one more tables). Primary and forign keys are used to join
tables in one of the following forms of relations:
1. one-to-one relationship, when one record in the first table relate to one and
only one record in the related table (foreign key).
2. one to many relationship, when one record in the primary table is related to
many records in the related table. this is the most common relationship. For ex-
ample there is a one to many relationship between Student table and the Courses
table since each student can register for multiple classes.
-
7/28/2019 VAMS Documentation
24/58
24
3. many to many relationship, when many records in one table are related to
many records in the related table. For example table Orders has a one to many
relationship with table Orders. MS Access does not support many-to-many rela-
tionship , we can implement it in access by breaking the relationship into two one
to many relationships using Junction tables. Junction tables are tables that are
used to to link two tables in a many-to-many relationship by including the pri-
mary keys from both tables.
Relationships Definitions
Referentional Integrity, when all values in related tables have a primary val-ues in the primary table.
Cascading updates, a feature that is supported by MS access that is used topreserve the Integrity of the data (Referentional Integrity). For example up-
dating a record in the Products table results in cascading the updates all re-
cords in the Orders table.
Cascading Deletes, a feature that is supported by MS access that is used topreserve the Integrity of the data (Referentional Integrity). For example de-
leting a record in the Products table results in cascading the delete of all re-
cords in the Orders table.
Access vs. Excel
Why store categories of information in separate tables?
Why not create one all-inclusive spreadsheet, using Microsoft Excel? Excel is
ideally suited to storing numerical data because of its ability to perform complex
calculations and to graph data. Access, on the other hand, is designed to manage
records by means of storing related data in separate tables whose information can
then be combined and retrieved based on criteria that you define. A business
wanting to keep track of suppliers, buyers and orders would be best served by
using a database, since those three categories contain relational data.
-
7/28/2019 VAMS Documentation
25/58
25
About saving in Access
Access automatically saves data as you move from one
record to another. (NOTE: This means once you type over old information, that
old information is lost and youd need to re-enter it to get it back.)
Access does prompt the user to save newly created objects before closing them
out, and to save objects to which you made structural changes. The user can
choose to save those changes or not.
Microsoft Access 2003 Table Views
Microsoft Access provides multiple views to work with
tables that are custom to your particular task. For example if you are trying to
edit records and modify information in the table then you can work with
the Datasheet view to directly enter, update and delete data value from the ta-ble. To work with the design of a table such as changing field type and size or
adding a primary key to your table you work with the Design View.
-
7/28/2019 VAMS Documentation
26/58
26
SYSTEM ANALYSIS AND DESIGN
-
7/28/2019 VAMS Documentation
27/58
27
SYSTEM ANALYSIS AND DESIGN
Fact Finding
After obtaining this background knowledge the analyst begin
to collect data on the existing systems output, inputs and costs. The following
are some of the methods for fact finding.
Review of Written Documents
When available all documentation on data carries (forms,
record, manuals etc...)Is organized and evaluated. Including in procedure manuals
are the requirements of the system, which helps in determining to what extend
that are met by the present system. Unfortunately, most manuals are not up to
date or may not be readable. Day to day problem may have forced changes that
are not reflected in the manual. Furthermore, people have a tendency to ignore
procedures and find shortcuts as long as the outcome is satisfactory.
-
7/28/2019 VAMS Documentation
28/58
28
SYSTEM DESCRIPTION
System analysis is the reduction of the entire system by
studying the various operations performed and the relationships with the system
and the requirement of its successor. A system can be defined as an orderly
grouping of independent component linked together according to a plan to
achieve a specific objective.
System study is a very critical activity while developing a
software application. This stage involves study of existing system and interacting
with users, which determines user requirements, and their expectations of the
proposed system. Series of discussions were made with users to arrive at a
solution to the problems they usually face. Determinations of system
requirements were preceded by a detailed study of the existing system in order to
analyze its functioning in depth. Study of all existing documentation and
procedures pertaining to the human resource management in the existing system
was made.
-
7/28/2019 VAMS Documentation
29/58
29
DATA FLOW DIAGRAM
The objective of the method is to provide a systematic
approach for the derivation of program structure the global view of softwareand the underpinning of architectural design. Beginning with a fundamental
system model, information may be represented as a continuous flow that
undergoes a series of transforms as it evolves from input to output. The data flow
diagram is used as a graphical tool to depict information flow. Data flow oriented
design defines a number of different mappings that transforms information flow
into program structure.
Each software design methodology has strengths and
weaknesses. An important selection factor for a design method is the breadth of
applications to which it can be applied. A data flow oriented approach to design
is best suitable when information is processed sequentially and no formal
hierarchical data structure exists; for example microprocessor control
applications, complex numerical analysis procedures, process control, and many
other engineering and scientific software fall into this category.
SYMBOLS USED IN DATA FLOW DIAGRAM:
Square defines a source or destination of system data. Arrow identifies data flow through which information flows. Circle represents a process that transforms incoming data flows into outgoing
data flows.
Open rectangle is a data store.
-
7/28/2019 VAMS Documentation
30/58
30
BASIC DFD SYMBOLS
A data flow is a route, which enables packets of
data to travel from one point to another. Data
may flow from a source to a processor and from
data store or process. An arrow line depicts the
flow, with arrowhead pointing in the direction
of flow.
A process represents transformation where
incoming data flows are changed into outgoing
data flows.
A data store is a repository of data that is to be
stored for use by a one or more process may besimple as buffer or queue or sophisticated as
relational database. They should have clear
names. If a process merely uses the content of
store and does not alter it, the arrow head goes
only from the store to the process. If a process
alters the details in the store then a doubleheaded arrow is used.
A source or sink is a person or part of an
organization that enters or receives information
from the system, but is considered to be outsidethe context of data flow model.
-
7/28/2019 VAMS Documentation
31/58
31
STEPS TO CONSTRUCT DATA FLOW DIAGRAM
Process should be named and numbered for easy reference. Each nameshould be representative of the process.
The direction of flow is from top to bottom and from left to right. When a process is exploded in to lower level details they are numbered. The names of data stores, sources and destinations are written in capital
letters.
-
7/28/2019 VAMS Documentation
32/58
32
Context Level DFD
Level 1 DFD
User/
Administrator CAR
SHOWROOM
MANAGEMENT
SYSTEMOutput
Login
Process
Catelog
Customer
Registration
Sales Order
Report
PurchaseOrder
Stock
Details
-
7/28/2019 VAMS Documentation
33/58
33
FEASIBILITY ANALYSIS
Having established a system, one has to determine whether
an alternative system is feasible compared to existing system. Feasibility study is
conducted in two steps: first a project team is formed. The team develop system
flowchart that identify the characteristics of the existing system, evaluate the
performance of the system, cost, and data and select the best system for the job.
Consider the above two steps and conduct a feasibility study
in the existing system to analyse whether a new system would be more feasible
than the existing one. To perform a feasibility study, we need to consider the
economical, technical, behavioural factor in a system.
Economic Feasibility
It is most frequently used method for evaluating the
effectiveness of a system, which is commonly known as cost/benefit analysis.
The existing system is operated manually which increases the workload, so an
alternative system is developed that minimizes the workload by making use of
automated processing. The cost required for automation is compared against the
benefits drawn out of it, and since the benefits exceeds cost we go for automation
of the system.
Technical Feasibility
This is designed to fit the available software and hardware
chosen. The data storage requirements are available. Already existing resources
can meet the expenses of the existing system in future. Out of it, we cant able to
get any solutions that are related with the proposed system.
-
7/28/2019 VAMS Documentation
34/58
34
Behavioural Feasibility
It involves performing an estimate, how strong a reaction the
user staff is likely to have towards the development of a computerized system.
The introduction of new system requires special efforts to educate and train the
user to perform the operation automatically.
The needs of various people affected by the
proposed system must be taken into account. The social cost must also be
evaluated for the proposed system. So the benefits are more and cost wise low.
Hence it is accepted.
Input Design
Once the analysis of the system has been done, it would be
necessary to identify the data that is required to be processed to produce the
outputs. Input design features can ensure reliability of the system and generate
reports from the accurate data.
The various objectives of the input design are:
Control the amount of input
Avoiding unwanted delay Avoiding errors in the data Keeping the process simple
The validations are carried out easily and there will be no
difficulty in adding a new entry.
-
7/28/2019 VAMS Documentation
35/58
35
Output Design
Computer output is the most important and direct source of
information to the user. Efficient, intelligible output design should improve the
systems relationships with the user and help in the decision making. A major
form of output is hardcopy from the printer. Printouts have been designed around
the outputs requirements of the employees.
There are several output reports they are:
Direct and Indirect sales report Invoice and receipt Billing reports Stock details
-
7/28/2019 VAMS Documentation
36/58
36
OUTPUT SCREENS
Login
-
7/28/2019 VAMS Documentation
37/58
37
Loading
-
7/28/2019 VAMS Documentation
38/58
38
Home Menu
-
7/28/2019 VAMS Documentation
39/58
39
Catelog
-
7/28/2019 VAMS Documentation
40/58
40
Customer Registration
-
7/28/2019 VAMS Documentation
41/58
41
Purchase Order
-
7/28/2019 VAMS Documentation
42/58
42
Sales Order
-
7/28/2019 VAMS Documentation
43/58
43
Stock Details
-
7/28/2019 VAMS Documentation
44/58
44
Database Design
This activity deals with the design of the physical
database .A key is to database how the access paths are to be implemented. In
database design, several specific objectives are to be considered. They are:
Controlled Redundancy Recover from Failure Privacy and security Performance Data Independence Ease of use Accuracy and integrity Avoiding inordinate delays
The overall objective in the development of database
technology has been to treat. Data as organizational resource and as an integrated
whole database management system allow the data to be protected and organized
separately from other resource.
Database can be defined as an integrated collection of data.
Database is acrucial factor in the performance of system both in term of system
timings and in the case with which the system can be maintained or modified.
Data store could have been implicit or explicit in the logical
store and physical file from them.
If the data management software can provide centralized
access to the data from the program, it is possible to treat the data as a separate
resource. The organization of the data in a database aims three major objectives
namely data integration, data integrity and data independence.
-
7/28/2019 VAMS Documentation
45/58
45
Database Normalization
Normalization has been carried out for the following reasons:
To structure the data To permit simple retrieval of data in the response to queries. To simplify the maintenance of the data through updates, insertion and
deletions.
To reduce the needs to restructure, if reorganizes data when newapplication requirements arise.
To avoid redundancy and data dependencies.
TABLE NAME: login
TABLE NAME : Car_Catelog
FIELD NAME DATA TYPE
username Text
password Text
FIELD NAME DATA TYPE
ID AutoNumber
modelid Text
modelname Text
opt Text
seat Text
fuel Text
mileage Text
cylinder Text
engine Text
cc Text
power Text
torque Text
fbreak Text
rbreak Text
srprice Text
orprice Text
-
7/28/2019 VAMS Documentation
46/58
46
TABLE NAME: car_details
TABLE NAME: car_color
TABLE NAME: car_stock
TABLE NAME: cust_details
FIELD NAME DATA TYPE
name Text
address Text
city Text
phone Text
FIELD NAME DATA TYPE
modelname Text
opt TextModelid Text
FIELD NAME DATA TYPEid AutoNumber
Modelid Text
Color Text
FIELD NAME DATA TYPE
modelid Text
color Text
stock Number
-
7/28/2019 VAMS Documentation
47/58
47
TABLE NAME: pur_bill
FIELD NAME DATA TYPE
ID AutoNumber
Invno Text
Invdate Date/Time
Modelname Text
Opt Text
modelid Text
Color Text
stock Number
price Number
TABLE NAME: sale_bill
FIELD NAME DATA TYPE
invno Number
invdate Date/Timecustid Text
modelid Text
color Text
engno Text
chasno Text
srprice Number
tax Number
accessories Number
Servcharge Numberdiscount Number
total Number
-
7/28/2019 VAMS Documentation
48/58
48
DEVELOPMENT OF SYSTEM AND TESTING
-
7/28/2019 VAMS Documentation
49/58
49
FUNDAMENTAL DESIGN CONCEPTS FOR
THE SYSTEM DEVELOPMENT
The design concept used here is the waterfall or phased life
cycle model. This model segments the software life cycle into series of
successive activities. Each phase requires well defined requirements; utilize well
defined process and results in well-defined output. Resources are required to
complete the processes in each phase and each phase is accomplished through the
application of explicit methods, tools and techniques.
The phased is also called waterfall model because of
sequential movement from one phase to another. Following are the phases of
development cycle:
Conception Initiation Analysis Design Construction Testing Implementation and maintenance
CONCEPTION
System development life cycle starts with the conception
phase. This phase is triggered by a competitor, a problem or an opportunity.
Certain important issues are clarified at this stage like:
The problem is perceived The goals to be achieved The benefits from the solution The scope of the project
-
7/28/2019 VAMS Documentation
50/58
50
INITIATION
In this phase, the software engineers work with users to carry
out a macro level study of the users requirements. The software engineers define
the various alternatives possible and the cost benefit justification of these
alternatives.
ANALYSIS
In this phase, the software engineers carry out a detailed
study of the users requirements. They then arrive the proposed system to be built.
The model of this system is used to freeze all requirements before the next phase
begins. The phase generates functional specifications, which contains:
Outputs to be produced Inputs that need to be received. Procedures that will get the output from the input. Acceptance test to list the types that the user can carry out to ensure that
the system is acceptable.
DESIGN
In this phase, the functional specifications are used for
translating the model into a design of the desired system. From the DFD the next
step is the definition of the modules and their relationships to one another in a
form called structured charts, using a data dictionary and other structured tools.
The purpose of the design phase is to specify a particular software system that
will meet stated requirements.
CONSTRUCTION
In this phase actual code that will be delivered to the
customer as the running system. Individual modules developed in this phase are
tested before delivering to the next phase.
-
7/28/2019 VAMS Documentation
51/58
51
TESTING
All the modules that have been developed before are
integrated or put together in this phase and tested as the complete system. A
system is tested for online response, volume of transaction, stress, recovery from
failure and usability.
IMPLEMENTATION
Implementation means converting a new system design in to
operation. This involves creating computer compactable files.
SYSTEM TESTING
Testing is a set of activities that can be planned in advance
and conducted systematically. System testing is a stage of implementation, which
is aimed at ensuring that the system works accurately and efficiently before live
operations commences. Testing is vital success of the system. System testing
makes a logical assumption that if all the parts of the system are correct, goal will
be successfully achieved. The different types of testing are unit, integration,
validation, output, performance and acceptance testing. IN this project following
two tests are performed:
Black box testing
White box testing
BLACK BOX TESTING
This testing is done to derive set of input conditions that will
fully exercise all functional requirements for a program. Black box testing is used
to find error in following categories:
-
7/28/2019 VAMS Documentation
52/58
52
Incorrect or missing functions. Interface errors. Errors in data structures. Initialization Errors.
WHITE BOX TESTING
It is used to derive tests cases.
To guarantee that all independent paths within a module have beenexercised at least once.
To check all the logical decisions on their true and false side To execute all loops within their operational bounds.
-
7/28/2019 VAMS Documentation
53/58
53
IMPLEMENTATION
-
7/28/2019 VAMS Documentation
54/58
54
IMPLEMENTATION
Implementation is the final important phase in the life cycleof a new system. The term implementation provides a wide range of meaning i.e.,
from conversion of a basic application to a complete replacement by a new
computer system. In short, implementation is the process of converting a new
system into an operating one. Under this smaller work the following are the
major steps in the implementation of the system
Installation of hardware, if required. The newly developed software is newly loaded. Different end users are trained to operate the new system. Distribution of user manual.
The implementation phase of this project was carried out according to the
strategies described above.
-
7/28/2019 VAMS Documentation
55/58
55
CONCLUSION
-
7/28/2019 VAMS Documentation
56/58
56
CONCLUSION & SCOPE OF THE SYSTEM
The system as the name indicates, CAR SHOWROOM
MANAGEMENT SYSTEM is used to purchase and sales the cars in easiest way.
The various processes of the construction of the new system have been done. The
customized progresses are effective and easy to handle. The customized modules
satisfy the user needs.
The user-friendly software, CAR SHOWROOM
MANAGEMENT SYSTEM successfully overcomes strict and severe validation
checks performed using the test data. The results attained were fully satisfactory
from the user point of view. An attempt was made to obtain maximum perfection
in documenting the software in a simple, precise and self-explanatory manner.
The system was verified with valid as well as invalid data
in each manner. The system is done with an insight into the necessary
modifications that may require in future. Hence the system can be maintained
successfully without much rework.
-
7/28/2019 VAMS Documentation
57/58
57
FUTURE ENHANCEMENTS
-
7/28/2019 VAMS Documentation
58/58
FUTURE ENHANCEMENTS
This application avoids the manual work and the
problems concern with it. It is an easy way to obtain the information regarding
the various products information that are present in the Super markets.
Well I and my team members have worked hard in
order to present an improved website better than the existing ones regarding the
information about the various activities. Still, we found out that the project can be
done in a better way. Primarily, when we request information about a particular
product it just shows the company, product id, product name and no. of quantities
available. So, after getting the information we can get access to the product
company website just by a click on the product name .
The next enhancement that we can add the searching
option. We can directly search to the particular product company from this
site .These are the two enhancements that we could think of at present.