The database will supply the sales team with information on in house financing compared to cash sales or alternate financing. The Trade-in statistics will also be available to the sales team.
The following assumptions were made. This database is for sales information only and is not a vehicle inventory database... displayed 300 characters
Custom written essay
All essays are written from scratch by professional writers according to your instructions and delivered to your email on time. Prices start from $10.99/page
Your research paper is written by certified writers
Your requirements and targets are always met
You are able to control the progress of your writing assignment
You get a chance to become an excellent student!
Get a price guote
Trade-ins and financing are optional on a sale and will not be required as customers may either make a down payment on a vehicle or have their own financing, or the transactions may be a cash sale.
The following entities were created for the database.
Sales Table
PK Field Name Data Type Description Required Duplicates
customer_id Number Unique ID Yes Yes
dealershp_id Number Unique ID Yes Yes
Contract_id Number Unique ID No No
trde_in_id Number Unique ID No No
vehicle_stck Number Unique ID Yes No
Dealership Table
PK Field Name Data Type Description Required Duplicates
Yes dealershp_id Number Unique ID Yes No
dealershp_name Text Name Yes No
dealershp_addrs Text Address Yes No
dealershp_phn Text Phone Nr Yes No
dealershp_max_inv Number Max Inv No No
dealershp_crnt_inv Number Current Inv No No
Customer Table
PK Field Name Data Type Description Required Duplicates
Yes customer_id Autonumber Unique ID Yes No
customer_first_name Text First Name Yes Yes
customer_last_name Text Last Name Yes Yes
customer_mdl_int Text Middle Init No Yes
customer_addrs Text Address Yes Yes
customer_phone Text Phone Nr Yes Yes
customer_dob Date/Time Date of Birth Yes Yes
customer_ssn Text SSN Yes No
customer_gross_inc Currency Gross Income Yes Yes
customer_cred_rate Number Credit rating Yes Yes
customer_mrtg Yes/No Have an mrtg? Yes Yes
customer_mrtg_amt Currency Amt of mrtg Yes Yes
customer_contacts Text Contacts Yes Yes
Vehicle Table
PK Field Name Data Type Description Required Duplicates
Yes Vehicle_stck Autonumber Invent Nr Yes No
Vehicle_make Text Make Yes Yes
Vehicle_Model Text Model Yes Yes
Vehicle_yr Text Build Date Yes Yes
Vehicle_clr Text Color Yes Yes
Vehicle_sales_rate Currency Price for sale Yes Yes
Vehicle_purchased_price Currency Cost @ purchase Yes Yes
Vehicle_Mileage Number Mileage Yes Yes
Vehicle_VIN Text VIN Nr Yes No
Is_Wholesale Yes/NO Flag Yes Yes
Trade-in
PK Field Name Data Type Description Required Duplicates
Yes trde_in_id Autonumber Unique ID Yes No
trde_in_make Text Make Yes Yes
trde_in_model Text Model Yes Yes
trde_in_yr Text Date Yes Yes
trde_in_clr Text Color Yes Yes
trde_in_mlge Number Mileage Yes Yes
trde_in_vin Text Vin Nr Yes No
trde_in_value Currency Value/Purchase price Yes Yes
Financing
PK Field Name Data Type Description Required Duplicates
Yes Contract_id Autonumber Unique ID Yes No
finance-cmp Text Company Yes No
phne_nmbr Text Phone Nr Yes Yes
deposit Currency Deposit Yes Yes
finance_amount Currency Amount Yes Yes
interst_rt Number Rate of Loan Yes Yes
Entity Relationship Diagram (ERD)
Conclusion
The creation of the database system for sales and trade-ins and the new Entity-Relationship Diagram offers Maximus Motor Company several advantages previously not held, namely, the ability to store and access customer information, sales information, trade-in details, redundancy of this information company-wide, report generation not previously possible, and the improvement of integrity over the company network... displayed 300 characters
