Car Showroom Management System
Car Showroom Management System
Car Showroom Management System
ABSTRACT
This is a live project which was developed for a local CAR Agent. It is useful
to the Agent to maintain the Customers details, Sales Details, Company items and services and
also CAR Details. If any customer buy a CAR in loan that persons CAR will recognizes with the
help of CAR no.
CAR Recognition System, which will cover the following modules
The agent will enter the CAR No It will help the user to search the CAR details and the
required details of the customer .The agent enters the customer details and maintain company
details.
Regarding the registration module, it contains the information about newly joined User
details like name of the user, password etc. CAR Details module contains the details like
Name of the CAR, send from, send to etc. Billing and Payment Detail will contain the
details like Actual Amount to be paid, emi. Searching is having the details of the customer.
Any agent will login and search the details of the customer it will show all details like
customer Details, CAR name, payment type etc.
This CAR Showroom Management System project mainly contains the CAR
information and loan recovering details. The CAR is purchased that CAR amount will be
cleared or not. It will clear then its ok. Other wise the agent will search the details of the
customer and recover the loan.
Hardware Requirements:
Pentium-IV (Processor).
256 MB Ram
Hard disk 10 GB
Software Requirements:
Operating System :
Front-End:
Back-End:
SQL SERVER
Windows
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
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. . No specific training is required
for the distributors to use this application. They can easily use the tool that decreases manual hours
spending for normal things and hence increases the performance. It is very easy to record the information
of online sales and purchases in the databases.
INPUT DESIGN
Input design is the process of converting user-oriented input to a computer based
format. Input design is a part of overall system design, which requires very careful attention
.Often the collection of input data is the most expensive part of the system. The main
objectives of the input design are
1. Produce cost effective method of input
2. Achieve highest possible level of accuracy
3. Ensure that the input is acceptable to and understood by the staff.
OUTPUT DESIGN
Outputs from computer systems are required primarily to communicate the results of
processing to users. They are also used to provide a permanent copy of these result for latter
consultation .Computer output is the most important and direct source of information to the
users. Designing computer output should proceed in an organized well through out the
manner. The right output must be available for the people who find the system easy o use.
The outputs have been defined during the logical design stage. If not, they should defined at
the beginning of the output designing terms of types of output connect, format, response etc,
. LANGAUGE SPECIFICATION
4.1 FEATURES OF VISUAL BASIC. NET
IMPLEMENTATION INHERITANCE:
GARBAGE COLLECTION:
OVERLOADING:
MULTITHREADING:
Visual Basic .NET, Visual C++ .NET, and Visual C# .NET all use
the same integrated development environment (IDE), which allows
them to share tools and facilitates in the creation of mixed-language
solutions. In addition, these languages leverage the functionality of the
.NET Framework and simplify the development of ASP Web applications
and XML Web services.
INTRODUCTION TO SQL
Server
Physical Structure
Logical Structure
Physical Structure:
a) Table spaces
b) Segments
c) Extents
d) Data Blocks
The data files contain all user data in terms of tables, index and views. The
log files contain the information to open and be recovered, of undone after a
transaction (Rollback).
The control file physical data, media information to open and manage data
files. If the control file is damaged the server will not be able to open or use the
database even if the database is undamaged.
DATABASE
The conventional data processing approach is to develop a program (or many
programs) for each application. This result in one or more data files for each
application. Some of the data may be common between files. However one
application may require the file to be organized on a particular field, while other
application may require the file to be organized on another field. A major drawback
of the conventional method is that the storage access methods are built in to the
program. Therefore, though the same data may be required by two applications, the
data will have to be sorted in two different places because each application depends
on the way that the data stored.
Data Redundancy:
Some data elements like name, address, identification code, are used in
various applications. Since data is required by multiple applications, it is
stored in multiple data files. In most cases, there is a repetition of data. This
is referred to as data redundancy, and leads to various other problems.
The end user interacts with the system either by invoking an application
program or by writing their queries in a database query language. The database
query language allows the end user to perform all the basic operations (retrieval,
deletion, insertion and updating) on the data.
The DBA has to coordinate the functions of collecting information about the data
to be stored, designing and maintaining the database and its security. The database
must be designed and maintained to provide the right information at the right time
to authorized people. These responsibilities belong to the DBA and his staff.
ADVANTAGES OF A DBMS
The major advantage that the database approach has over the conventional
approach is that a database system provides centralized control of data. Most
benefits accrue from this notion of centralized control.
The DBMS guarantees that only authorized persons can access the database.
The DBA defines the security checks to be carried out. Different checks can
be applied to different operations on the same data. For instance, a person
may have the access rights to query on a file, but may not have the right to
delete or update that file. The DBMS allows such security checks to be
established for each piece of data in the database.
DATA INDEPENDENCE
FEATURES OF RDBMS:
The ability to create multiple relations and enter data into them
NORMALIZATION
Normalized data structures are simpler, more stable and are easier to maintain.
Normalization can therefore be defined as a process of simplifying the relationship
between data elements in a record.
To structure the data so that there is no repetition of data, this helps in saving
space.
Testing :
Testing is a process of executing a program with the indent of finding an
error. Testing is a crucial element of software quality assurance and presents
ultimate review of specification, design and coding.
System Testing is an important phase. Testing represents an interesting anomaly for the software.
Thus a series of testing are performed for the proposed system before the system is ready for user
acceptance testing.
A good test case is one that has a high probability of finding an as undiscovered error. A
successful test is one that uncovers an as undiscovered error.
Testing Objectives:
1.
2.
A good test case is one that has a probability of finding an as yet undiscovered error
3.
Testing Principles:
Testing should begin on a small scale and progress towards testing in large
The primary objective for test case design is to derive a set of tests that has the highest livelihood
for uncovering defects in software. To accomplish this objective two different categories of test case
design techniques are used. They are
White-box testing:
White box testing focus on the program control structure. Test cases are derived to ensure
that all statements in the program have been executed at least once during testing and that all
logical conditions have been executed.
Block-box testing:
Black box testing is designed to validate functional requirements without regard to the internal workings
of a program. Black box testing mainly focuses on the information domain of the software, deriving test
cases by partitioning input and output in a manner that provides through test coverage. Incorrect and
missing functions, interface errors, errors in data structures, error in functional logic are the errors falling
in this category.
Testing strategies:
A strategy for software testing must accommodate low-level tests that are necessary to
verify that all small source code segment has been correctly implemented as well as high-level
tests that validate major system functions against customer requirements.
Testing fundamentals:
Testing is a process of executing program with the intent of finding error. A good test case is one
that has high probability of finding an undiscovered error. If testing is conducted successfully it uncovers
the errors in the software. Testing cannot show the absence of defects, it can only show that software
defects present.
Unit testing:
Unit testing is essential for the verification of the code produced during the coding phase and
hence the goal is to test the internal logic of the modules. Using the detailed design description as a
guide, important paths are tested to uncover errors with in the boundary of the modules. These tests were
carried out during the programming stage itself. All units of ViennaSQL were successfully tested.
Integration testing :
Integration testing focuses on unit tested modules and build the program structure that is dictated
by the design phase.
System testing:
System testing tests the integration of each module in the system. It also tests to find
discrepancies between the system and its original objective, current specification and system
documentation. The primary concern is the compatibility of individual modules. Entire system is working
properly or not will be tested here, and specified path ODBC connection will correct or not, and giving
output or not are tested here these verifications and validations are done by giving input values to the
system and by comparing with expected output. Top-down testing implementing here.
Acceptance Testing:
This testing is done to verify the readiness of the system for the implementation. Acceptance testing
begins when the system is complete. Its purpose is to provide the end user with the confidence that the
system is ready for use. It involves planning and execution of functional tests, performance tests and
stress tests in order to demonstrate that the implemented system satisfies its requirements.
Tools to special importance during acceptance testing include:
Test coverage Analyzer records the control paths followed for each test case.
Timing Analyzer also called a profiler, reports the time spent in various regions of the code are areas to
concentrate on to improve system performance.
Coding standards static analyzers and standard checkers are used to inspect code for deviations from
standards and guidelines.
Test Cases:
Test cases are derived to ensure that all statements in the program have been executed at
least once during testing and that all logical conditions have been executed.
Using White-Box testing methods, the software engineer can drive test cases that
Execute all loops at their boundaries and with in their operational bounds.
The test case specification for system testing has to be submitted for review before system
testing commences.
CONCLUSION:
The package was designed in such a way that future modifications can be
done easily. The following conclusions can be deduced from the development of the
project.
It provides a friendly graphical user interface which proves to be better when compared
to the existing system.
It gives appropriate access to the authorized users depending on their permissions.
It effectively overcomes the delay in communications.
Updating of information becomes so easier.
System security, data security and reliability are the striking features.
The System has adequate scope for modification in future if it is necessary.
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.
BIBLIOGRAPHY
The following books were referred during the analysis and execution phase of the project
C# COOK BOOK
O reilly Publications
WEBSITES:
www.google.com
www.microsoft.com