Car Dealership Information System

(1)

Car Dealership Information System

A PROJECT REPORT A PROJECT REPORT Submitted by Submitted by

Nitin Satija…………. 11514201709

Swati Singhal……….. 10114201709

Rishab Kumar

Rishab Kumar………..10321401709

………..10321401709

Deepak

Deepak Sewal…………

Sewal…………07121401709

07121401709

In partial fulf

In partial fulfillment for the awillment for the award of the degrard of the degreeee Of

Of

BACHELOR OF BUSINESS ADMINISTRATION

JAGANNATH INTERNATIONAL MANAGEMENT SCHOOL VASANT

KUNJ, NEW DELHI

2011 2011

(2)

Car Dealership Information System

CERTIFICATE FOR PROJECT

This is to certify that this is a bonafide record of the project work done satisfactorily at This is to certify that this is a bonafide record of the project work done satisfactorily at ““Jagannath International Management SchoolJagannath International Management School” by the following students in the partial” by the following students in the partial fulfillment of BBA V Semester

fulfillment of BBA V Semester

-Nitin Satija

Nitin Satija

Swati Singhal

Rishab Kumar

Deepak Sewal

This report or similar report on the topic has not been submitted for any other examination This report or similar report on the topic has not been submitted for any other examination and doesn‟t form a part of

and doesn‟t form a part of any other course undergone by the candidateany other course undergone by the candidates.s.

Date: Date: Place:

Place: Project Project GuideGuide

Ms.Poonam Malik Ms.Poonam Malik

Jagannath International Management School Jagannath International Management School (Affiliated to GGS

(Affiliated to GGS IndraprasIndraprastha University, Delhi)tha University, Delhi) Vasant Kunj, New Delhi

(3)

Car Dealership Information System

ACKNOWLEDGMENT

I would like to thank

I would like to thank Mrs. Poonam Malik for introducing us to Mrs. Poonam Malik for introducing us to the field of Informationthe field of Information Management and for her professional guidance and direction during the entire length of Management and for her professional guidance and direction during the entire length of ourour project at the JIMS VK (GGSIPU). I would also like to thank my Project advisor Mrs.

project at the JIMS VK (GGSIPU). I would also like to thank my Project advisor Mrs. Poonam Malik

Poonam Malik for his guidance, supporfor his guidance, support and patience. Their experient and patience. Their experience and expertce and expert knowledge inspired us to reach beyond our

knowledge inspired us to reach beyond our previous limits and capabilities.previous limits and capabilities.

Last but not the least; we would like to thank all those people who directly or indirectly Last but not the least; we would like to thank all those people who directly or indirectly contributed for helping us in the successful completion of

contributed for helping us in the successful completion of the project.the project.

Thank you Thank you

Nitin Satija

Swati Singhal

Rishab Kumar

Deepak Sewal

(4)

Car Dealership Information System

Chapter

Chapter 5 5 ImplementatiImplementation on and and Coding Coding 3232

Chapter 6 Software Testing Chapter 6 Software Testing

6.1

6.1 Objectives Objectives of of testing testing 5757 6.2

6.2 Testing Testing Principles Principles 5858 6.3

6.3 Verification Verification and and Validation Validation 5858 6.4

6.4 Types Types of of Testing Testing 5858 6.5

6.5 Testing Testing procedure procedure 5959

Chapter

Chapter 7 7 Utilities Utilities in in the the system system 6161

Chapter

Chapter 8 8 Conclusion Conclusion 6464

Bibliography

(6)

Car Dealership Information System

INTRODUCTION INTRODUCTION

This project, “Car Dealership Information System”, is a Management Information System or MIS. This project, “Car Dealership Information System”, is a Management Information System or MIS. A

A dealership management systemdealership management system ((DMSDMS) is a bundled) is a bundled management information systemmanagement information system createdcreated specifically for

specifically for automotive industryautomotive industry car dealershipscar dealerships or large equipment manufacturers, Theseor large equipment manufacturers, These systems often contain

systems often contain softwaresoftware that cater to the needs of that cater to the needs of thethe financefinance,, salessales,, partsparts,, inventoryinventory andand administration

administration components of running the dealership. It has been designed to carry out basiccomponents of running the dealership. It has been designed to carry out basic functionality of adding, modifying and deleting records pertaining to a car dealership and its functionality of adding, modifying and deleting records pertaining to a car dealership and its various functions.

various functions.

It has been created using Visual Basic 6.0 as a frontend and Microsoft Access 2000 as a backend It has been created using Visual Basic 6.0 as a frontend and Microsoft Access 2000 as a backend for the databases. It works on MS- Access. The references for the

for the databases. It works on MS- Access. The references for the MS-Access and Visual BasicMS-Access and Visual Basic are provided with the introduction with the

are provided with the introduction with the System Development Life CycleSystem Development Life Cycle. The coding part has. The coding part has been attached with the

been attached with the output generated.output generated.

I have tried to make the s

I have tried to make the system more users friendly and more convenient to handle especially forystem more users friendly and more convenient to handle especially for the non computer professionals.

(7)

Car Dealership Information System

1.1 Objectives 1.1 Objectives

The main objective of any computerized system is to

The main objective of any computerized system is to minimize the manual work performed.minimize the manual work performed. As our project reduce

As our project reduces the register work or ms the register work or manual work of anual work of as all the entry system as all the entry system has beenhas been computerized. Objective of our system is to minimize and overcome the limitations of computerized. Objective of our system is to minimize and overcome the limitations of manual work.

manual work.

This computerized system possesses a good GUI which provides an ease of support to the This computerized system possesses a good GUI which provides an ease of support to the administrators and to perform their task in a very efficient manner and this work is also administrators and to perform their task in a very efficient manner and this work is also effective in nature. This system is also capable of generating error free reports that effective in nature. This system is also capable of generating error free reports that describes all records and custom reports can also be generated. The handling of this project describes all records and custom reports can also be generated. The handling of this project is also very simple so that anyone can understand it easily. And this system is also very is also very simple so that anyone can understand it easily. And this system is also very beneficial from the security point of view. It helps in

beneficial from the security point of view. It helps in

-1.

1. Successfully introduce Successfully introduce automation to automation to the enterprisethe enterprise 2. Provide functionality to add, edit and delete records 2. Provide functionality to add, edit and delete records 3. Increase efficiency of the business

3. Increase efficiency of the business

1.2 Need of the system 1.2 Need of the system

In today‟s fast changing world of technology every organization is in want of fully In today‟s fast changing world of technology every organization is in want of fully utilization of time and space in order to be counted in the lists of worlds highest-ranking utilization of time and space in order to be counted in the lists of worlds highest-ranking organizations.

organizations.

In order to this each organization is making itself fully computerized. Computerization also In order to this each organization is making itself fully computerized. Computerization also helps organization to minimize paper work as well

(8)

Car Dealership Information System

There are several attributes in which the computer based information works. Broadly the

There are several attributes in which the computer based information works. Broadly the workingworking of Computer system is divided into two

of Computer system is divided into two main groups.main groups.



 Transaction SystemTransaction System 

 Decision support systemDecision support system

Transaction System

Transaction System:: A transaction is a record of A transaction is a record of some well-defined single and usually smallsome well-defined single and usually small occurrence in a system. Transactions are input into the computer t

occurrence in a system. Transactions are input into the computer to update the database files. Ito update the database files. It checks the entering data for its accuracy. This means that

checks the entering data for its accuracy. This means that numeric data appears in numeric fieldnumeric data appears in numeric field and character data in character field. Once all the checks are made, transaction is

and character data in character field. Once all the checks are made, transaction is used to updateused to update the database. Transaction can be inputted in on-line mode or

the database. Transaction can be inputted in on-line mode or batch mode. In on-line mode,batch mode. In on-line mode, transactions are entered and updated into the database almost instantaneously. In batch mode, transactions are entered and updated into the database almost instantaneously. In batch mode, transactions are collected into batches which may be held for a

transactions are collected into batches which may be held for a while and inputted later.while and inputted later.

Decision Support System

Decision Support System: It assists the user to make analytical decision. It shows the : It assists the user to make analytical decision. It shows the variousvarious data in organized way called analysis. This analysis can be

data in organized way called analysis. This analysis can be made to help in making decisions.made to help in making decisions. User can store information as per requirement, which can

User can store information as per requirement, which can be used for comparison be used for comparison with otherwith other reports.

reports.

A Car Dealership or vehicle local distribution is

A Car Dealership or vehicle local distribution is a business that sells new a business that sells new cars and/or used cars atcars and/or used cars at the retail level, based on a dealership contract with an automaker or

the retail level, based on a dealership contract with an automaker or its sales subsidiary. It employsits sales subsidiary. It employs Automobile Salespeople to do the selling. It may also

Automobile Salespeople to do the selling. It may also provide Maintenance Services for cars, thusprovide Maintenance Services for cars, thus employing automobile mechani

employing automobile mechanics, stock and scs, stock and sell spare automobile parts, and process warrantyell spare automobile parts, and process warranty claims.

claims.

Such a business has to figure in various factors to function and thus encounters a large amount of Such a business has to figure in various factors to function and thus encounters a large amount of data pertaining to everything from models and prices to features and

data pertaining to everything from models and prices to features and specifications.specifications. To keep an account of such

To keep an account of such large chunks of information manually is a difflarge chunks of information manually is a difficult task and there is aicult task and there is a risk of information loss, redundancy, and misuse.

risk of information loss, redundancy, and misuse. This

This is why there is a requirement for a “Car Dealership Information System”, which seeks tois why there is a requirement for a “Car Dealership Information System”, which seeks to reduce or remove all the aforementioned problems and increase the efficiency of the business reduce or remove all the aforementioned problems and increase the efficiency of the business byby introducing automation.

(9)

Car Dealership Information System

1.3 Characteristics of proposed

1.3 Characteristics of proposed system

system

The manual dealing of preparing reports is a very tedious job, as administrator first needs to The manual dealing of preparing reports is a very tedious job, as administrator first needs to search for applications from the files and then presenting those in the form of reports. Thus search for applications from the files and then presenting those in the form of reports. Thus we need to automate this process to systemize and fasten up the overall system, as through we need to automate this process to systemize and fasten up the overall system, as through computerization enormous data will become easily accessible. The system should be computerization enormous data will become easily accessible. The system should be distributive in nature; it should be

distributive in nature; it should be designed to provide functionalities as explained below:designed to provide functionalities as explained below: 

 Database can be Database can be accessed by the Administrator.accessed by the Administrator.



 Maintains the member information and leave applications.Maintains the member information and leave applications.



 Administrator can take the backups and generate reports of Administrator can take the backups and generate reports of any or all any or all the databases.the databases.

1.4 Scope of the work

As in today‟s world ther

As in today‟s world ther e is nothing perfect, so there is always a chance of scope in everye is nothing perfect, so there is always a chance of scope in every aspect of project. At this

aspect of project. At this point of time our project is point of time our project is a standalone application whereas it cana standalone application whereas it can be converted into a fully automated system, reducing the paperwork to close to zero. Also be converted into a fully automated system, reducing the paperwork to close to zero. Also in this the administrator has to enter the unique ID of a member into the forms of Visual in this the administrator has to enter the unique ID of a member into the forms of Visual Basic which consumes time.

Basic which consumes time.

We can improve this project further by using web services and fully automating it where-in We can improve this project further by using web services and fully automating it where-in applications can be submitted online and receive the corresponding response by e-mail. The applications can be submitted online and receive the corresponding response by e-mail. The data can be s

data can be stored centrally at the server terminal.tored centrally at the server terminal.

The system covers 7 basic focus areas of a car dealership, viz. The system covers 7 basic focus areas of a car dealership, viz. 1. General Information

(10)

Car Dealership Information System

2. Engine Specifications

2. Engine Specifications 3. Dimensions

3. Dimensions 4. Technical

4. Technical InformatioInformationn 5. Financials 5. Financials 6. Features 6. Features 7. Accessories 7. Accessories

1.5 Advantages of proposed system



 With the feature of Login ID and password , data becomes more secure , as onlyWith the feature of Login ID and password , data becomes more secure , as only the person who has the passw

the person who has the password and login id ord and login id can view or modifcan view or modify records , rest noy records , rest no one can enter the

one can enter the system without password.system without password. 

 It provides a better and faster way of managing and maintaining variousIt provides a better and faster way of managing and maintaining various transactions of the

transactions of the membersmembers 

 Time wastage is minimal, as all records and reports are just a click away.Time wastage is minimal, as all records and reports are just a click away.

This

(11)

Car Dealership Information System

Methodology

The data used in this project Report are collected from both Primary and secondary The data used in this project Report are collected from both Primary and secondary sources. The strategy behind the data collection process in this research project has been sources. The strategy behind the data collection process in this research project has been collecting, studying, analyzing and putting data in both logical/chronological orders.

collecting, studying, analyzing and putting data in both logical/chronological orders.

The books, Internet, analysis of existing Car Parking Systems, and other resources were of The books, Internet, analysis of existing Car Parking Systems, and other resources were of great help in completing and giving this project a final touch.

great help in completing and giving this project a final touch.

The Faculties in the IT department of our institute contributed a lot towards the project. The Faculties in the IT department of our institute contributed a lot towards the project. They gave me an in-depth knowledge of various aspects of an IT application database They gave me an in-depth knowledge of various aspects of an IT application database project.

(12)

Car Dealership Information System

Chapter 2

Chapter 2 SYSTEM REQUIREMENTS

SYSTEM REQUIREMENTS

2.1 Hardware requirements



 2 GB Hard Disk(minimum requirement)2 GB Hard Disk(minimum requirement) 

 512 MB RAM512 MB RAM 

 Supports for printer (Dot Matrix / Inkjet / Laser printer)Supports for printer (Dot Matrix / Inkjet / Laser printer) – – that is, appropriatethat is, appropriate drivers are installed and printer connected. Printer will be required for printing drivers are installed and printer connected. Printer will be required for printing of issues.

of issues. 

 Standalone system or network based system- not a concern, as it will beStandalone system or network based system- not a concern, as it will be possible to run the application on any of these.

possible to run the application on any of these. 

 Processor- Pentium 166MHz or aboveProcessor- Pentium 166MHz or above 

 Monitor with appropriate resolution and color quality for proper and completeMonitor with appropriate resolution and color quality for proper and complete viewing of screens.

viewing of screens.

2.2 Software requirements



 Any windows-based Any windows-based operating system operating system (Windows-98/2000(Windows-98/2000/XP/NT)/XP/NT) 

 Visual Basic 6.0 – Visual Basic 6.0 – for coding/developing the softwarefor coding/developing the software 

(13)

Car Dealership Information System

PLATFORMS PLATFORMS



 VISUAL BASIC AS VISUAL PROGRAMMING LANGUAGEVISUAL BASIC AS VISUAL PROGRAMMING LANGUAGE

VISUAL BASIC follows an event driven programming approach. The user interface is VISUAL BASIC follows an event driven programming approach. The user interface is designed first with all the required controls placed on the user interface form. Customizing designed first with all the required controls placed on the user interface form. Customizing their properties modifies these controls. After the user interface is designed the events that their properties modifies these controls. After the user interface is designed the events that occur in the application are decided and are relating to their respective controls. Every occur in the application are decided and are relating to their respective controls. Every control is associated with its

control is associated with its respective events to be trapped.respective events to be trapped.

VISUAL BASIC APPLICATION DEVELOPMENT VISUAL BASIC APPLICATION DEVELOPMENT

The figure shows the steps that all visual basic developers follow as they prepare The figure shows the steps that all visual basic developers follow as they prepare projects:

projects: Design

Design and buildand build user

user interfaceinterface

Write event Write event driven code driven code

Create and call Create and call other procedures other procedures

Test and debug Test and debug

Prepared Prepared distribution file distribution file

(14)

Car Dealership Information System

The prototypical visual basic development cycle The prototypical visual basic development cycle

The steps mentioned above aren‟t symmetrical. Some steps take

The steps mentioned above aren‟t symmetrical. Some steps take longer than other do andlonger than other do and there is repetition of several steps as the initial application is design is refined and there is repetition of several steps as the initial application is design is refined and enhanced. Most of the development time is spent in the first four steps. Even the most enhanced. Most of the development time is spent in the first four steps. Even the most complex visual basic projects follow the steps described above. Most of time is spent in complex visual basic projects follow the steps described above. Most of time is spent in building the user interface and writing the code

building the user interface and writing the code required by the application.required by the application.

UNDERSTANDIN

UNDERSTANDING THE G THE ADVANTAGES OF VISUAL BASICADVANTAGES OF VISUAL BASIC

Let‟s take a minute to review some of the features that make visual basic such a robust and Let‟s take a minute to review some of the features that make visual basic such a robust and exciting development platform. The following key points make visual basic an excellent exciting development platform. The following key points make visual basic an excellent development tool:

development tool:

-1 Visual Basic Application Are Event Driven

1 Visual Basic Application Are Event Driven -- Event driven means the user is in control of Event driven means the user is in control of the application. The user generates a stream of events each time he clicks with mouse or the application. The user generates a stream of events each time he clicks with mouse or presses a key on the keyboard. Your visual basic application respond to those event a presses a key on the keyboard. Your visual basic application respond to those event a through the codes written and attached to

through the codes written and attached to those events.those events.

2

2 Visual Basic SupVisual Basic Supports The Priports The Principals Of ncipals Of Object OrienteObject Oriented Designd Design -- This This means means thatthat you can comport mentalist different aspects of your application as object and develop and you can comport mentalist different aspects of your application as object and develop and test those objects independently of the

(15)

Car Dealership Information System

3

3 Microsoft Has Designed VisuaMicrosoft Has Designed Visual Basic To Be A Complete Wl Basic To Be A Complete Window Development Sindow Development Systemystem -- This means that your visual basic application will look and behave like other windowsThis means that your visual basic application will look and behave like other windows program user might work with.

program user might work with.

4 Visual Basic Is Infinitely Extensible through The Use Of Active X, Controls, Dynamic 4 Visual Basic Is Infinitely Extensible through The Use Of Active X, Controls, Dynamic Link libraries (DLL‟S) And Add

Link libraries (DLL‟S) And Add



 MS-ACCESS 07MS-ACCESS 07

Microsoft (MS) Access is relational database management system (RDBMS) used to stored Microsoft (MS) Access is relational database management system (RDBMS) used to stored and manipulate large collection of information of any kind. Here RDBMS refers to the and manipulate large collection of information of any kind. Here RDBMS refers to the organization of data in a series of rows and columns in such a manner that any specific organization of data in a series of rows and columns in such a manner that any specific piece of information is available with the click of a mouse and a few keystrokes. piece of information is available with the click of a mouse and a few keystrokes. MS-Access has tools, which are easy to used and provide powerful development environment, Access has tools, which are easy to used and provide powerful development environment, making it an appropriate choice for novices as

making it an appropriate choice for novices as well as professional.well as professional.

There are different ways in which an application with multiple components that includes, There are different ways in which an application with multiple components that includes, Access can be integrated. A component (in Microsoft terminology) is an application or Access can be integrated. A component (in Microsoft terminology) is an application or development tool that makes it objects available to other applications. Using automation in development tool that makes it objects available to other applications. Using automation in Visual Basic it is possible to work with objects from other components to construct a Visual Basic it is possible to work with objects from other components to construct a seamless integrated application. Using the Object Linking and Embedding (OLE) seamless integrated application. Using the Object Linking and Embedding (OLE) technology, a user can include documents created in another component on a

technology, a user can include documents created in another component on a report or formreport or form within Access. Automation and OLE are distinct technologies, which are a part of the within Access. Automation and OLE are distinct technologies, which are a part of the Component Object Model (COM), a standard proposed by Microsoft.

(16)

Car Dealership Information System

Microsoft Access is used as backend because:

-1.

1. It is easy to use.It is easy to use.

2.

2. It can be integrated / connected easily with a Visual Basic.It can be integrated / connected easily with a Visual Basic.

3.

3. No programming skills required to work with.No programming skills required to work with.

4.

4. The database access time is better than other database Software.The database access time is better than other database Software.

5.

5. Access uses „structured query language (SQL)‟, which is English likeAccess uses „structured query language (SQL)‟, which is English like language, andlanguage, and makes interaction between user and the database very simple. It helps in easy creation, makes interaction between user and the database very simple. It helps in easy creation, manipulation and modification of the database.

(17)

Car Dealership Information System

Chapter 3 Chapter 3

SYSTEM SPECIFICATIONS

3.1 Security 3.1 Security

The application will be password protected. The user (administrator) will have to enter the The application will be password protected. The user (administrator) will have to enter the correct username and password in order to

correct username and password in order to access the application.access the application.

3.2 Maintainability 3.2 Maintainability

The application will be designed in maintainable manner. It will be easy to incorporate new The application will be designed in maintainable manner. It will be easy to incorporate new requirements in the individual modules.

requirements in the individual modules.

3.3 Portability

The application is easily portable on

The application is easily portable on any Windows-based system.any Windows-based system.

3.4 Feasibility

The economical and technical factors are considered to be feasibility study of the system. The economical and technical factors are considered to be feasibility study of the system. ECONOMICAL FEASIBILITY

ECONOMICAL FEASIBILITY

1. No manpower cost is incurred in this proposed system as the system has been 1. No manpower cost is incurred in this proposed system as the system has been developed as project work.

developed as project work.

2. The system has been developed in an environment where no hardware & software 2. The system has been developed in an environment where no hardware & software facilities have to be

facilities have to be installed for the purpose of development.installed for the purpose of development. 3. The cost entailed in this respect was

(18)

Car Dealership Information System

TECHNICAL FEASIBILITY

1. The existing hardware & software facilities are sufficient for development of this 1. The existing hardware & software facilities are sufficient for development of this proposed system. However at the beginning of the project, the P-II 400MHz machine proposed system. However at the beginning of the project, the P-II 400MHz machine was enough for the work. Soon we realized that machine is little bit slower for some was enough for the work. Soon we realized that machine is little bit slower for some complicated data retrieval & it will keep the user unnecessary waiting for the result to complicated data retrieval & it will keep the user unnecessary waiting for the result to pop-up on the screen.

pop-up on the screen.

2. So the project was relocated to P-IV machine. Thus no additional costs are 2. So the project was relocated to P-IV machine. Thus no additional costs are incurred during the development of the project.

incurred during the development of the project.

OPERATIONAL FEASIBILITY OPERATIONAL FEASIBILITY

Here we consider the extent to which the proposed system will fulfill any administrator Here we consider the extent to which the proposed system will fulfill any administrator‟‟ss requirement. That is whether the proposed system covers all aspects of the working system requirement. That is whether the proposed system covers all aspects of the working system or it has

or it has considerable improvemconsiderable improvements.ents.

BEHAVIORAL FEASIBILITY BEHAVIORAL FEASIBILITY

A disputation of any kind of change in existing system may be

A disputation of any kind of change in existing system may be appeared by users. But in theappeared by users. But in the ““Car dealership information SystemCar dealership information System” there may be less chance of having any opposing” there may be less chance of having any opposing views because this software is easy to

views because this software is easy to operate and increases the efficiency in user operation.operate and increases the efficiency in user operation. Because of its simplicity, any user can easily be t

(19)

Car Dealership Information System

Chapter 4 Chapter 4

SYSTEM DESIGN

4.1 System design

Design is a

Design is a meaningful engineerimeaningful engineering representation of something to be ng representation of something to be built. Software designbuilt. Software design is the first of three technical activities- designs, code generation and tests- that are required is the first of three technical activities- designs, code generation and tests- that are required to build and verify the software. Design focuses on the four major areas of concern- data, to build and verify the software. Design focuses on the four major areas of concern- data, architecture, interfaces and

architecture, interfaces and components.components. 

 The Data design transforms the information domain model created during analysisThe Data design transforms the information domain model created during analysis into the data structures that will be required to implement the software. The data into the data structures that will be required to implement the software. The data objects and relationships defined in the ERD provide the basis for the data design objects and relationships defined in the ERD provide the basis for the data design activity.

activity. 

 The Architectural design defines the relationship between major structural elementsThe Architectural design defines the relationship between major structural elements of the software, the "design patterns" that can be used to achieve the requirements of the software, the "design patterns" that can be used to achieve the requirements that have been defined for the system. The architectural design representation i.e. the that have been defined for the system. The architectural design representation i.e. the framework of a computer based system can be

framework of a computer based system can be derived from the system specification,derived from the system specification, the analysis model and the interaction of subsystems defined within the analysis the analysis model and the interaction of subsystems defined within the analysis model.

model. 

 The Interface design describes how the software communicates with itself, withThe Interface design describes how the software communicates with itself, with systems that interoperate with it. An interface implies a flow of information and a systems that interoperate with it. An interface implies a flow of information and a specific type of behavior. Therefore, data and DFDs provide much of the information specific type of behavior. Therefore, data and DFDs provide much of the information required for interface design.

required for interface design. 

 The Component-level design transforms structural elements of the softwareThe Component-level design transforms structural elements of the software architecture into a procedural description of software

architecture into a procedural description of software components. The importance of components. The importance of software design can be stated with a single word- Quality. Design is the only way software design can be stated with a single word- Quality. Design is the only way that we can accurately translate a customer's requirements into a finished software that we can accurately translate a customer's requirements into a finished software product or system.

(20)

Car Dealership Information System

4.2 Design principles

Software design is both a process and a model. The design process is a sequence of steps Software design is both a process and a model. The design process is a sequence of steps that enable the designer to describe all aspects of software to be built.

that enable the designer to describe all aspects of software to be built. The design model is the equivalent of an architect's plans for a

The design model is the equivalent of an architect's plans for a house.house. 

 The design process should not suffer from "tunnel vision"- a good designer shouldThe design process should not suffer from "tunnel vision"- a good designer should consider alternative approaches, judging each based in the requirements of the consider alternative approaches, judging each based in the requirements of the problem.

problem. 

 The design should be traceable to the analysis model- it is necessary to have a meansThe design should be traceable to the analysis model- it is necessary to have a means for tracking how requirements have been satisfied by the

for tracking how requirements have been satisfied by the design model.design model. 

 The design should exhibit uniformity and integration- rules of styles and formatThe design should exhibit uniformity and integration- rules of styles and format should be defined for a design team before design work begins. A design is

should be defined for a design team before design work begins. A design is integratedintegrated if care is

if care is taken in interfaces between design components.taken in interfaces between design components. 

 The design should be The design should be structured to accommodate changestructured to accommodate change 

 The design should be structured to degrade gently, even when aberrant data, eventsThe design should be structured to degrade gently, even when aberrant data, events or operating conditions are encountered- it should be designed to accommodate or operating conditions are encountered- it should be designed to accommodate unusual circumstances.

unusual circumstances. 

 Design is not coding, coding is not design- when detailed procedural designs areDesign is not coding, coding is not design- when detailed procedural designs are created for program components, the level of abstraction of the design model is created for program components, the level of abstraction of the design model is higher than source code. The only design code level address the small higher than source code. The only design code level address the small implementation details that enable the procedural design to be coded.

implementation details that enable the procedural design to be coded.



 The design should be reviewed to minimize conceptual (semantic) errors- a designThe design should be reviewed to minimize conceptual (semantic) errors- a design

team should ensure that major conceptual elements of the design have

team should ensure that major conceptual elements of the design have been addressedbeen addressed before worrying about the syntax of the d

(21)

Car Dealership Information System



4.3 Design concepts

The beginning of wisdom is to

The beginning of wisdom is to recognize the difference between getting a program to recognize the difference between getting a program to work,work, and getting it right. Fundamental software design concepts provide the necessary and getting it right. Fundamental software design concepts provide the necessary framework for “getting it right”.

framework for “getting it right”.



 ABSTRACTIONABSTRACTION

When we consider a modular solution to any problem, many level of abstraction can When we consider a modular solution to any problem, many level of abstraction can be posed. At the highest level of abstraction, a solution is stated in broad terms using be posed. At the highest level of abstraction, a solution is stated in broad terms using the language of the problem environment. At lower level of abstraction, a more the language of the problem environment. At lower level of abstraction, a more procedural orientation is taken. Finally, at lowest level of abstraction, the solution is procedural orientation is taken. Finally, at lowest level of abstraction, the solution is stated in a manner that can be directly implemented.

stated in a manner that can be directly implemented.



 REFINEMENTREFINEMENT

Refinement is a process of elaboration. Refinement causes the designer to elaborate Refinement is a process of elaboration. Refinement causes the designer to elaborate on the original statement, providing more and more detail as each successive on the original statement, providing more and more detail as each successive refinement

refinement occurs. occurs. It It helps helps the the designer designer to to reveal reveal low-level low-level details details as as designdesign progresses. It aids the designer in creating a complete design model as the design progresses. It aids the designer in creating a complete design model as the design evolves.

evolves.



 MODULARITYMODULARITY

Software is divided into separately named and addressable components, often called Software is divided into separately named and addressable components, often called modules that are integrated to satisfy problem requirements.

(22)

Car Dealership Information System

4.4 Project execution model

In this, we are developing an application phase developing process to manage the In this, we are developing an application phase developing process to manage the complexity, better project tracking, and quality to achieve consistency, software process is complexity, better project tracking, and quality to achieve consistency, software process is divided into set of phase, quality and progress checks are made without waiting till the divided into set of phase, quality and progress checks are made without waiting till the development is completed.

development is completed.

We have selected the waterfall model in the present application because this model is We have selected the waterfall model in the present application because this model is suitable to automate the existing manual system for which all requirements are known suitable to automate the existing manual system for which all requirements are known before the design starts.

before the design starts.

DATA FLOW DIAGRAM DATA FLOW DIAGRAM Requirement analysis &

Requirement analysis & specification specification Design Design Implementation Implementation & unit testing & unit testing

Integration & Integration & system testing system testing Operation & Operation & maintenance maintenance

(23)

Car Dealership Information System

INPUT INPUT USERNAME AND USERNAME AND PASSWORD PASSWORD SEARCH, ADDITION, SEARCH, ADDITION, DELETION AND DELETION AND MODIFICATION OF MODIFICATION OF EMPLOYEE DATA/RECORDS EMPLOYEE DATA/RECORDS OUTPUT OUTPUT

Symbols used for E-R diagram.

Car Dealership Car Dealership Information System Information System

(24)

Car Dealership Information System

Symbol

Meaning

Symbol

Meaning

ENTITY ENTITY WEAK ENTITY WEAK ENTITY RELATIONSHIP RELATIONSHIP IDENTIFYING RELATIONSHIP IDENTIFYING RELATIONSHIP ATTRIBUTE ATTRIBUTE KEY ATTRIBUTE KEY ATTRIBUTE MULTIVALUED MULTIVALUED COMPOSITE ATTRIBUTE COMPOSITE ATTRIBUTE

(25)

Car Dealership Information System

ENTITY RELATIONSHIP DIAGRAMS

General

General InformatInformationion

GENERAL INFORMATION

COMPANY COMPANY ID NUMBER ID NUMBER COLOR COLOR BODYTYPE BODYTYPE MODEL MODEL MAKE YEAR MAKE YEAR

(26)

Car Dealership Information System

Engine Specifications Engine Specifications

ENGINE SPECIFICATIONS

NO.

NO. OF OF CYLINDERSCYLINDERS

NO.

NO. OF OF VALVESVALVES

MAX. TORQUE MAX. TORQUE EMISSION STD. EMISSION STD. ID NUMBER ID NUMBER CAPACITY CAPACITY MAX. POWER MAX. POWER TYPE TYPE

(27)

Car Dealership Information System

Dimensions Dimensions

DIMENSIONS

TURNING TURNING RADIUS RADIUS WHEELBASE WHEELBASE ID NUMBER ID NUMBER REAR REAR TRACK TRACK LENGTH LENGTH WIDTH WIDTH HEIGHT HEIGHT FRONT FRONT TRACK TRACK GROUND GROUND CLEARANCE CLEARANCE BOOTSPACE BOOTSPACE

(28)

Car Dealership Information System

Technical Information Technical Information

TECHNICAL INFORMATION

ID NUMBER ID NUMBER TRANSMISSION TRANSMISSION MODEL MODEL SEATING CAPACITY SEATING CAPACITY

FUEL TANK CAPACITY FUEL TANK CAPACITY

NO.

NO. OF OF DOORSDOORS

NO.

(29)

Car Dealership Information System

Financials Financials

FINANCIALS

ID NUMBER ID NUMBER INSURANCE INSURANCE WARRANTY WARRANTY LOAN LOAN PRICE PRICE

(30)

Car Dealership Information System

Features Features

FEATURES

AIRBAGS AIRBAGS ID NUMBER ID NUMBER BODY COLORED BODY COLORED BUMPERS BUMPERS ALLOY WHEELS ALLOY WHEELS A.B.S. A.B.S. E.P.S. E.P.S. CENTRAL LOCKING CENTRAL LOCKING

(31)

Car Dealership Information System

Accessories Accessories ACCESSORIES ACCESSORIES G.P.S. G.P.S. SPECIAL SPECIAL PAINT PAINT E.S.P

E.S.P.. _GEAR_GEAR

LOCKS LOCKS STEREO STEREO ID NUMBER ID NUMBER

(32)

(33)

Car Dealership Information System

Chapter 5

Form Design and Coding

The proposed system is an application developed in Visual Basic 6.0, making it an event The proposed system is an application developed in Visual Basic 6.0, making it an event driven or menu driven system. Visual basic is an object based programming language. The driven or menu driven system. Visual basic is an object based programming language. The programming does not execute itself in any predetermined sequence but different lines of programming does not execute itself in any predetermined sequence but different lines of code in response to events.

code in response to events.

Visual Basic specifically follows procedural approach of coding wherein the problem is Visual Basic specifically follows procedural approach of coding wherein the problem is decomposed into independent procedures or modules (coded and tested), which are later decomposed into independent procedures or modules (coded and tested), which are later combined and finally a system is ready to be executed.

combined and finally a system is ready to be executed.

It allows us to adopt a parallel approach, with independent sections of code for each option It allows us to adopt a parallel approach, with independent sections of code for each option that the user might select.

that the user might select.

Coding for the proposed system was not a very tedious task since forms were distributed Coding for the proposed system was not a very tedious task since forms were distributed amongst the team of developers, who individually coded their parts, tested them and then amongst the team of developers, who individually coded their parts, tested them and then combined them to form

(34)

Car Dealership Information System

FORMS AND CODING

FORMS AND CODING Home

Home

Coding Coding

Private Sub Command1_Click () Private Sub Command1_Click () Form2gi.Show

Form2gi.Show End Sub

End Sub

Private Sub Command2_Click() Private Sub Command2_Click() Form3ENG.Show

Form3ENG.Show End Sub

End Sub

Private Sub Command3_Click() Private Sub Command3_Click()

(35)

Car Dealership Information System

Form4DIM.Show Form4DIM.Show End Sub

End Sub

Private Sub Command4_Click() Private Sub Command4_Click() Form5TEC.Show

Form5TEC.Show End Sub

End Sub

Private Sub Command5_Click() Private Sub Command5_Click() Form6FIN.Show

Form6FIN.Show End Sub

End Sub

Private Sub Command6_Click() Private Sub Command6_Click() Form7FEAT.Show

Form7FEAT.Show End Sub

End Sub

Private Sub Command7_Click() Private Sub Command7_Click() Form8ACC.Show

Form8ACC.Show End Sub

(36)

Car Dealership Information System

General Information

(37)

Car Dealership Information System

Coding Coding

Private Sub cmdfirst_Click() Private Sub cmdfirst_Click() Adodc1.Recordset.MoveFirst Adodc1.Recordset.MoveFirst End Sub

End Sub

Private Sub cmdlast_Click() Private Sub cmdlast_Click() Adodc1.Recordset.MoveLast Adodc1.Recordset.MoveLast End Sub

End Sub

Private Sub cmdnext_Click() Private Sub cmdnext_Click()

If Adodc1.Recordset.EOF = True Then If Adodc1.Recordset.EOF = True Then Adodc1.Recordset.MoveFirst Adodc1.Recordset.MoveFirst End If End If Adodc1.Recordset.MoveNext Adodc1.Recordset.MoveNext End Sub End Sub

Private Sub cmdprevious_Click() Private Sub cmdprevious_Click()

(38)

Car Dealership Information System

If Adodc1.Recordset.BOF = True Then If Adodc1.Recordset.BOF = True Then Adodc1.Recordset.MoveLast Adodc1.Recordset.MoveLast End If End If Adodc1.Recordset.MovePrevious Adodc1.Recordset.MovePrevious End Sub End Sub

Private Sub Command1_Click() Private Sub Command1_Click() Adodc1.Recordset.AddNew Adodc1.Recordset.AddNew End Sub

End Sub

If MsgBox("Save this record?", vbYesNo, "Save") = vbYes Then If MsgBox("Save this record?", vbYesNo, "Save") = vbYes Then Adodc1.Recordset.Update Adodc1.Recordset.Update Else Else Adodc1.Recordset.CancelUpdate Adodc1.Recordset.CancelUpdate End If End If End Sub End Sub

If MsgBox("Are you sure?", vbYesNo, "Delete") = vbYes Then If MsgBox("Are you sure?", vbYesNo, "Delete") = vbYes Then Adodc1.Recordset.Delete Adodc1.Recordset.Delete Adodc1.Recordset.MoveNext Adodc1.Recordset.MoveNext If Adodc1.Recordset.EOF Then If Adodc1.Recordset.EOF Then Adodc1.Recordset.MoveLast Adodc1.Recordset.MoveLast End If End If End If End If End Sub End Sub

Private Sub Command4_Click() Private Sub Command4_Click() Dim a As Variant

Dim a As Variant

a = InputBox("Please Enter Password") a = InputBox("Please Enter Password") If a = "suparn" Then If a = "suparn" Then Frame1.Visible = True Frame1.Visible = True Command5.Visible = True Command5.Visible = True Text1.Locked = False Text1.Locked = False Text2.Locked = False Text2.Locked = False Text3.Locked = False Text3.Locked = False Text4.Locked = False Text4.Locked = False Text5.Locked = False Text5.Locked = False Text6.Locked = False Text6.Locked = False Else Else

MsgBox "You do not have authorization to edit.", vbCritical MsgBox "You do not have authorization to edit.", vbCritical End If

End If End Sub End Sub

(39)

Car Dealership Information System

Private Sub Command5_Click () Private Sub Command5_Click () Frame1.Visible = False Frame1.Visible = False Command5.Visible = False Command5.Visible = False Text1.Locked = True Text1.Locked = True Text2.Locked = True Text2.Locked = True Text3.Locked = True Text3.Locked = True Text4.Locked = True Text4.Locked = True Text5.Locked = True Text5.Locked = True Text6.Locked = True Text6.Locked = True End Sub End Sub

(40)

Car Dealership Information System

Engine

Engine SpecificatiSpecificationsons

Coding Coding

End Sub

If Adodc1.Recordset.EOF = True Then If Adodc1.Recordset.EOF = True Then Adodc1.Recordset.MoveFirst

Adodc1.Recordset.MoveFirst End If

(41)

Car Dealership Information System

Adodc1.Recordset.MoveNext Adodc1.Recordset.MoveNext End Sub

End Sub

If MsgBox("Are you sure?", vbYesNo, "Delete") = vbYes Then If MsgBox("Are you sure?", vbYesNo, "Delete") = vbYes Then Adodc1.Recordset.Delete Adodc1.Recordset.Delete If Adodc1.Recordset.EOF Then If Adodc1.Recordset.EOF Then Adodc1.Recordset.MoveLast Adodc1.Recordset.MoveLast End If End If End If End If End Sub End Sub

Dim a As Variant

a = InputBox("Please Enter Password") a = InputBox("Please Enter Password") If a = "suparn" Then If a = "suparn" Then Frame1.Visible = True Frame1.Visible = True Command5.Visible = True Command5.Visible = True Text1.Locked = False Text1.Locked = False Text2.Locked = False Text2.Locked = False Text3.Locked = False Text3.Locked = False Text4.Locked = False Text4.Locked = False Text5.Locked = False Text5.Locked = False Text6.Locked = False Text6.Locked = False Text7.Locked = False Text7.Locked = False Text8.Locked = False Text8.Locked = False

(42)

Car Dealership Information System

Else Else

Private Sub Command5_Click() Private Sub Command5_Click() Frame1.Visible = False Frame1.Visible = False Command5.Visible = False Command5.Visible = False Text1.Locked = True Text1.Locked = True Text2.Locked = True Text2.Locked = True Text3.Locked = True Text3.Locked = True Text4.Locked = True Text4.Locked = True Text5.Locked = True Text5.Locked = True Text6.Locked = True Text6.Locked = True Text7.Locked = True Text7.Locked = True Text8.Locked = True Text8.Locked = True End Sub End Sub

(43)

Car Dealership Information System

Dimensions

Coding Coding

End Sub

(44)

Car Dealership Information System

End If End If Adodc1.Recordset.MoveNext Adodc1.Recordset.MoveNext End Sub End Sub

End Sub

Dim a As Variant

a = InputBox("Please Enter Password") a = InputBox("Please Enter Password") If a = "suparn" Then If a = "suparn" Then Frame1.Visible = True Frame1.Visible = True Command5.Visible = True Command5.Visible = True Text1.Locked = False Text1.Locked = False Text2.Locked = False Text2.Locked = False Text3.Locked = False Text3.Locked = False Text4.Locked = False Text4.Locked = False Text5.Locked = False Text5.Locked = False Text6.Locked = False Text6.Locked = False Text7.Locked = False Text7.Locked = False

(45)

Car Dealership Information System

Text8.Locked = False Text8.Locked = False Else

Else

Private Sub Command5_Click() Private Sub Command5_Click() Frame1.Visible = False Frame1.Visible = False Command5.Visible = False Command5.Visible = False Text1.Locked = True Text1.Locked = True Text2.Locked = True Text2.Locked = True Text3.Locked = True Text3.Locked = True Text4.Locked = True Text4.Locked = True Text5.Locked = True Text5.Locked = True Text6.Locked = True Text6.Locked = True Text7.Locked = True Text7.Locked = True Text8.Locked = True Text8.Locked = True End Sub End Sub

(46)

Car Dealership Information System

Technical Information

Coding Coding

End Sub

If Adodc1.Recordset.EOF = True Then If Adodc1.Recordset.EOF = True Then

(47)

Car Dealership Information System

Adodc1.Recordset.MoveFirst Adodc1.Recordset.MoveFirst End If End If Adodc1.Recordset.MoveNext Adodc1.Recordset.MoveNext End Sub End Sub

End Sub

Dim a As Variant

a = InputBox("Please Enter Password") a = InputBox("Please Enter Password") If a = "suparn" Then If a = "suparn" Then Frame1.Visible = True Frame1.Visible = True Command5.Visible = True Command5.Visible = True Text1.Locked = False Text1.Locked = False Text2.Locked = False Text2.Locked = False Text3.Locked = False Text3.Locked = False Text4.Locked = False Text4.Locked = False Text5.Locked = False Text5.Locked = False Text6.Locked = False Text6.Locked = False

(48)

Car Dealership Information System

Else Else

Private Sub Command5_Click() Private Sub Command5_Click() Frame1.Visible = False Frame1.Visible = False Command5.Visible = False Command5.Visible = False Text1.Locked = True Text1.Locked = True Text2.Locked = True Text2.Locked = True Text3.Locked = True Text3.Locked = True Text4.Locked = True Text4.Locked = True Text5.Locked = True Text5.Locked = True Text6.Locked = True Text6.Locked = True End Sub End Sub

(49)

Car Dealership Information System

Financials

Coding Coding

End Sub

(50)

Car Dealership Information System

Adodc1.Recordset.MoveNext Adodc1.Recordset.MoveNext End Sub

End Sub

Dim a As Variant

a = InputBox("Please Enter Password") a = InputBox("Please Enter Password") If a = "suparn" Then If a = "suparn" Then Frame1.Visible = True Frame1.Visible = True Command5.Visible = True Command5.Visible = True Text1.Locked = False Text1.Locked = False Text2.Locked = False Text2.Locked = False Text3.Locked = False Text3.Locked = False Text4.Locked = False Text4.Locked = False Text5.Locked = False Text5.Locked = False Else Else

MsgBox "You do not have authorization to edit.", vbCritical MsgBox "You do not have authorization to edit.", vbCritical

(51)

Car Dealership Information System

End If End If End Sub End Sub

Private Sub Command5_Click() Private Sub Command5_Click() Frame1.Visible = False Frame1.Visible = False Command5.Visible = False Command5.Visible = False Text1.Locked = True Text1.Locked = True Text2.Locked = True Text2.Locked = True Text3.Locked = True Text3.Locked = True Text4.Locked = True Text4.Locked = True Text5.Locked = True Text5.Locked = True End Sub End Sub

(52)

Car Dealership Information System

Features Features

Coding Coding

End Sub

Car Dealership Information System

Car Dealership Information System

Car Dealership Information System

Nitin Satija…………. 11514201709

Nitin Satija…………. 11514201709

Swati Singhal……….. 10114201709

Swati Singhal……….. 10114201709

Rishab Kumar

Rishab Kumar………..10321401709

………..10321401709

Deepak

Deepak Sewal…………

Sewal…………07121401709

07121401709

BACHELOR OF BUSINESS ADMINISTRATION

BACHELOR OF BUSINESS ADMINISTRATION

JAGANNATH INTERNATIONAL MANAGEMENT SCHOOL VASANT

JAGANNATH INTERNATIONAL MANAGEMENT SCHOOL VASANT

KUNJ, NEW DELHI

KUNJ, NEW DELHI

Car Dealership Information System

Car Dealership Information System

CERTIFICATE FOR PROJECT

CERTIFICATE FOR PROJECT

-Nitin Satija

Nitin Satija

Swati Singhal

Swati Singhal

Rishab Kumar

Rishab Kumar

Deepak Sewal

Deepak Sewal

Car Dealership Information System

Car Dealership Information System

ACKNOWLEDGMENT

ACKNOWLEDGMENT

Nitin Satija

Nitin Satija

Swati Singhal

Swati Singhal

Rishab Kumar

Rishab Kumar

Deepak Sewal

Deepak Sewal

Car Dealership Information System

Car Dealership Information System

TABLE OF CONTENTS

TABLE OF CONTENTS

Car Dealership Information System

Car Dealership Information System

Car Dealership Information System

Car Dealership Information System

Car Dealership Information System

Car Dealership Information System

Car Dealership Information System

Car Dealership Information System

Car Dealership Information System

Car Dealership Information System

1.3 Characteristics of proposed

1.3 Characteristics of proposed system

system

1.4 Scope of the work

1.4 Scope of the work

Car Dealership Information System

Car Dealership Information System

1.5 Advantages of proposed system

1.5 Advantages of proposed system

Car Dealership Information System

Car Dealership Information System

Methodology

Methodology

Car Dealership Information System

Car Dealership Information System

Chapter 2

Chapter 2

SYSTEM REQUIREMENTS

SYSTEM REQUIREMENTS

2.1 Hardware requirements

2.1 Hardware requirements

2.2 Software requirements