Auto Inventory Database Design



Auto Inventory Database Design

[pic]

By Edward Roberts

Project Name: Formal Business Report

Project: D3

Auto Inventory Database Design

Prepared for:

Dr. Turner

Prepared by:

Edward Roberts

March 25, 2007

Table on Contents

List of Illustrations ------------------------------------------------------ page 4

Executive Summary ----------------------------------------------------- page 5

Background ------------------------------------------------------ page 5

Resources used -------------------------------------------------- page 5

Software and Hardware ---------------------------------------- page 6

End user, names, addresses ------------------------------------ page 6

Description of the project scope ------------------------------- page 6

Definition of Application deliverables ----------------------- page 6

Summary --------------------------------------------------------- page 6

Introduction --------------------------------------------------------------- page 7

Hardware ------------------------------------------------------------------ page 8

Software ------------------------------------------------------------------- page 8

End-User ------------------------------------------------------------------ page 8

Description of Project Scope ------------------------------------------- page 10

Application Deliverables ------------------------------------------------ page 11

Resources ------------------------------------------------------------------ page 11

Entity Description -------------------------------------------------------- page 13

Source Code --------------------------------------------------------------- page 14

List of Illustrations

Figure 1: Context DFD Level ---------------------------------------- page 15

Figure 2: System DFD Level ---------------------------------------- page 16

Executive Summary

Background

This report is for Ant-Lo Auto and Taylor Car Connection, the two companies deal with buying and selling used cars to consumers. The two companies buy vehicles from individuals and auto auctions. The cars are then reconditioned and made ready to sale to the consumers. The two owners of these companies asked me (Edward Roberts) to build a program that would keep up with the past cars bought and sold during the companies operation. The program will serve as a historical database that will inform the owners about the Make, Model, Color, VIN number, Down Payment, Sticker Price, and Sale price. The report will discuss feature such as the list below:

• Resources used

• Hardware and Software

• End users, names, addresses

• Description of Project scope

• Definition of application deliverables

Resources used

This section will discuss the all the different resources and references that were being used to complete the program.

Hardware and Software

This section will go into detail about the hardware used to run the different types of software to build the program. Also this section will discuss the specification on the software.

End user, names, addresses

This next section will tell who the end users are, were they are located, and what their intentions are for the use of this software.

Description of the project scope

This section will discuss what was included and excluded from the project. Also this section will discuss a little about the time invested in this project.

Definition of Application deliverables

This last section will discuss what with program/application will deliver to the end user.

Summary

After the project is done, it will represent a historical document that will help the companies keep up with past vehicles that they have purchased and sold. The application will let them know if a certain vehicle’s is value is more then Kelly bluebook says. Also they will know a range of how much they have spent on vehicles in the past and this will inform them on how much they would spend on the same vehicle in the future.

Introduction

This report will discuss the methods used to build a program/application that will be used to help Ant-Lo Auto and Taylor Car Connection with keeping track with inventory and prices of vehicles that they have purchased in the past and future purchases. The purpose of the program/application will be used to help the owners know about how much they want to spend on a vehicle before they buy it; by comparing the prices they paid for the same vehicle in the past and how much they can sell that vehicle for.

The purpose of this report is to inform Dr. Turner on the process of the design of the program/application and to show the setup and steps taken to complete this project. All the material for this report was gather from my knowledge and downloaded or viewed for the internet. Also there were some personal interviews conducted with the owners of the car lots.

Although there are numerous ways in the approach to developing the program/application this report only discusses the ways that were approached by me to develop the application. There were a few limitations when the application was developed, such as time to put into the project because there was other work that had to be done for other classes that I am taking, and limited access to applications such as Microsoft Virtual Server. This caused a problem because all the work had to be moved from my home computer to a flash drive to take to campus. Also limited knowledge about some of the software used to build the program slow the progress of the project.

Hardware

Most of the hardware used to develop the application consisted of use of my home computer a Dell 4550 with Microsoft XP Home Edition version 2002. I use a Intel Pentium 4 CPU 2.53GHz with 1GB of Ram. The monitor used was a 19in View Sonic. The printer was used to print out code to be viewed and highlighted for editing.

Software

The software used to create this project were Macromedia products, such as Dream Weaver 8 and Cold Fusion MX 7. I also used the Cold Fusion Administer to view the webpage/database on the web. The files were stored and viewed off my local computer and modified there also. Microsoft products were used also, such as Microsoft word, excel, and access. Microsoft excel was used to put the database information in to columns and rows, then access was used to completely build the database. The access database was then uploaded to the Cold Fusion Administer to build the WebPages for the website. Notepad was used to store code that was deleted from Dream Weaver and copy that code back into Dream Weaver when needed. The internet browsers that were used to view the samples of code were Internet Explorer 7 and Mozilla Firefox 2.0.

End-Users

The end users that will make use of the web application will be Anthony Lonon owner of Lo Auto Sales in Athens Georgia and Rod Taylor of Taylor Car Connections in Austell Georgia. Taylor Car Connection is located 181 Maxham Rd Austell, GA 30168

(770) 732-8656. Mr. Taylor came to me with the idea of have a database website only for him to access information about his vehicles so he could compare prices of vehicles he purchased in the past to future purchase.

Lo Auto Sales is located at 225 Collins Industrial B, Athens, GA (706) 549-1100, and the owner is Anthony Lonon. Mr. Lonon came to me around the same time looking for the same kind of application for his company. Both owners are in the same business and need to use the same application, which I will be developing for them, but with a different interface and different column names in the databases.

Description of Project Scope

This will be a Website on the end users already made website, but it will contain a password so that the end user will be the only who can access the web page. The webpage will have 4 to 5 different functions in the beginning stages, but maybe expanded upon later in the future. The functions that are implemented now are the search fields, update function, add function, and delete function. The end user will be the only ones who can use these functions to manipulate the database.

This project was started January 8th and is due April 18th, this is the time period in which the project is to be worked on and completed.

Application Deliverables

All the pages will be linked together so that the users can access the functions from any page. In the search page the user will be able to search for vehicles by the make, model, vin number, color, down payment by customer, sticker price, and sale price. The fields will be able to be left blank accept for the make and model. The update page will be used to add in the fields that were left out during the creation of the new entry. The add page will be used to create a new vehicle in the database. The delete function will be used to delete any data out of the database. The application will search thru the database using the primary key ID, which is the automatic numbering in the database. The webpage will have a password link built into the page so that the user will have to have a password to login.

Resources

The resources used to complete the applications consist of books, internet, and web forums. The books used were ColdFusion MX7 web application construction kit, Macromedia Dreamweaver 8 unleashed, and Using Macromedia Studio 8. There were websites on the internet that guided me in the process of completing the application; here are a few that I used:





• questions







Object Type Object Label Dictionary ID

Entity Customer LOA00

Method of Data Handling

N/A

Text Description and Comments

Anyone who comes in the shop and purchases a vehicle.

Object Type Object Label Dictionary ID

Entity Employee LOA00

Method of Data Handling

N/A

Text Description and Comments

Commission employees are anyone who manages specific areas such as sales, financial,

and promotions for the company.

Hourly employees who are receptionist, repair specialist, or provide any services in the company.

Object Type Object Label Dictionary ID

Entity Owner LOA00

Method of Data Handling

N/A

Text Description and Comments

Responsible for leading the employees, marketing and evaluating the promotions,

programs, and developing training for employees involved in the company.

Object Type Object Label Dictionary ID

Entity Suppliers LOA00

Method of Data Handling

N/A

Text Description and Comments

Companies and individuals that supply vehicles, equipment to repair vehicles, web site

designers, and database designers.

Object Type Object Label Dictionary ID

Data Store External LOA00

Method of Data Handling

N/A

Text Description and Comments

Government guidelines

Object Type Object Label Dictionary ID

Data Store Internal LOA00

Method of Data Handling

N/A

Text Description and Comments

Sample Code

index page

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download