Get a Website Built

Database Requirements:

• Customer Data: The name of every customer who ever purchased goods or services from the dealership, or those have visited the dealership. This includes name, address, phone #, email address, and type such as purchase, service, or visit.

• Employee Data: The information of every employees at the dealership, including name, address, phone#, email address, etc.

• Vehicle Data: Pertinent information on every vehicle the dealership ever worked on. This includes make, model, year, vehicle identification number, price.

• Sales Data: Data on every vehicle sold through the dealership. In addition to the vehicle data above, the date sold, the customer it was sold to, the temporary tag number, any customization work done to the vehicle, a link to the billing data for that sale, ...

• Service Data: Data covering each service visit at the dealership. The vehicle and customer involved, the mechanic(s) who worked on the vehicle, the vehicle mileage when it arrived at the dealership and when it left the dealership, preliminary estimates, what was actually done to the car, and final billing information, the date the vehicle entered the dealership, the time estimate for the work on the vehicle, the date the work was completed, the date the customer picked up the vehicle...

• Inventory Data: It is useful for the dealership to be able to track where a vehicle is located. A vehicle can be located at their parking lot or other dealerships’ parking lot. Shipments of new vehicles arrive, vehicles are sold, various customer vehicles arrive for service and leave. This can be confusing, but it is important (in cases of theft, or to avoid costly mistakes) that the dealership be able to track this information. Some dealerships will have other parking lots at remote sites as well as their main dealership lot.

• Billing Data: Relation connecting customers and billing events -- the date, payment method, customer information, and what dealership goods or service are being purchased.

• Contract Data: Dealerships are involved with a number of contracts that require database management -- car leases, service contracts with vehicle fleets for small companies, service contracts with other dealers, promotional contracts, and the like. Representing these appropriately is also important for the dealership database.

• Different Views: The dealership has a number of different employee types who require access to the database. Mechanics need to look at vehicle and customer data, and update service data. Sales people need a different view of the database, focussed on vehicle sales. Billing personnel would have a third set of requirements and responsibilities. It would be useful to be able to support giving each type of access their own view of the database.


• Sell a vehicle: vehicles sold might be off the lot, in which case the lot inventory needs to be modified, or they might be sold in expectation of delivery from the factory.

• Lease a vehicle: this is much as with selling vehicles, except that a lease contract is involved, and leased vehicles are treated differently with regard to regular maintenance and service.

• Order a vehicle from the factory: describe the vehicle desired, including all options (leather seats, four-wheel drive, moon roof, whatever), and request that the factory build one like that and send it to the dealership.

• Transfer inventory: it might be useful to support sending and receiving new vehicles from other nearby dealerships, for example if our dealership had a surplus of Rav4s and a Bowie dealership was out of that model.

• Customize a new vehicle: add post-factory options, like roofracks, stereo systems, rust-resistant coating, and the like.

• Service a vehicle: Add a new service record when a vehicle enters the dealership for service; keep track of the ongoing status of the vehicle during service; update the service record after the service is completed and again when the vehicle is

Skills: Graphic Design, HTML, PHP, Website Design

See more: Get built website, built website swoopo, built website integrating, built website jewellery, built website getafreelancer, built website compare flights, custom built website needed, netsuites built website, built website forclosurecom, built website bidster, built website developed website resume, built website hotel booking, todays custom built website prices, company can built website

About the Employer:
( 0 reviews ) United States

Project ID: #12161582

57 freelancers are bidding on average $554 for this job


Hi, Nice project you have there, let us help you with it! Our team is Russian-Canadian. We code in PHP. Check our recent projects here [url removed, login to view] Here’s a little video about our team too! ht More

$750 USD in 7 days
(110 Reviews)

Hello there, Greetings! We have gone through the complete job description and are pretty sure to assist you with this task as we are expertise team of developers & designers working on Web & App Development/Desig More

$1855 USD in 30 days
(271 Reviews)

Hi,Its just the beginning of our long term professional relationship,so let’s connect now :) I have gone through your requirement and understand that your business is unique and Drupaltonic has always built websites More

$777 USD in 30 days
(86 Reviews)

Hello, Here are Magento Exerpts we have done 150+ Magento projects at [url removed, login to view] and fully confident after read your requirements to give you a better and satisfied solutions. Can we have a small meeting on s More

$1000 USD in 20 days
(136 Reviews)

Dear Employer, Greetings from fortranPRO. I have worked on similar projects to what you are looking for, and I am 100% confident that I can exceed your expectations. I have attached samples of work very similar More

$500 USD in 18 days
(120 Reviews)

My Portfolio: [url removed, login to view] I am an experienced senior web developer & graphic designer. I am quite handy on both front/backend. Please contact me to discuss more. I have more than 8 years of experience i More

$750 USD in 10 days
(199 Reviews)

Hello, my name is Olya. I represent Ukrainian IT Company «Webbook». We provide website design and web and app development services for organizations, public and government institutions, company or private web-pages. More

$600 USD in 20 days
(67 Reviews)
$555 USD in 10 days
(241 Reviews)

Hi, I am interested to work with you on this web design project, I reviewed the requests you listed and I would like to discuss further details with you. Since 2006 I am managing a Web Design Agency located in Romania More

$889 USD in 30 days
(66 Reviews)

Hello, We are happy to discuss our proposal with you. KEY POINTS THAT MAKE US DIFFER FROM OTHERS: ~ We have 5+ years of experiences in Unity 3D, Xcode, CoCoa 2d, Phonegap and major iOS and Android developement. ~ More

$1000 USD in 10 days
(70 Reviews)

Hello, I want to show you all relevant Demo and Designs which is similar to your project completed previously. To make sure about the requirement set and customizations, I want to discuss this project with you further More

$773 USD in 18 days
(17 Reviews)

Hello, We have accomplished 90% of the project which is similar of your requirement. All we need 10% customization as per your requirement set and specifications. I want to discuss in personal chat in order to explore More

$773 USD in 20 days
(63 Reviews)

Read your brief thoroughly and very interested in working on it. I create elegant and appealing experience to satisfy my clients and go the extra miles wherever needed. Portfolio: [url removed, login to view] More

$600 USD in 3 days
(159 Reviews)

Hi there.. I have read your project details completely and willing to do it for you... Check our recent reviews for our quality work on on time delivery : [url removed, login to view] More

$750 USD in 10 days
(62 Reviews)

****** Greetings from WebMantra! ****** Thanks for giving us opportunity to bid on your project. We are experienced in working with WordPress, Custom PHP, Open Cart etc... Just checked your requirement we have develope More

$750 USD in 25 days
(72 Reviews)

Hello, I have gone through your outsourced requirements "Get a Website Built" and have analyzed that I have right skills (Graphic Design, HTML, PHP, Website Design) to execute your esteemed project. I will comple More

$455 USD in 365 days
(113 Reviews)

Howdy, We have gone through your requirement to revamp your old website, [url removed, login to view] . We are delighted to inform you that we can be your one stop solution for all the designing and development related needs. More

$555 USD in 10 days
(18 Reviews)

Hello there, Hope you are doing great..!! Going through your project description we understand that you are looking for an experienced team of professional developers and designers to work on your assignment. We More

$250 USD in 10 days
(57 Reviews)

Hello Can I help you with your project? What kind of website do you need? Looking forward to hearing from you soon. Thank you for your time. Sincerely Smbat

$250 USD in 3 days
(66 Reviews)

HI There ! We read your job post and most interested in your job cause we have expert web developer team in our company and able to provide you Exact you want. Let's discuss more about your job and start as soon. More

$250 USD in 10 days
(67 Reviews)