Maximus Database Relationships

Essay text:

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. 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...