Maximus Database Relationships
Essay Preview: Maximus Database Relationships
Report this essay
Develop entities and attributes for a database for Maximus Motor Company from the information supplied by the Company. Develop an Entity-Relationship Diagram for Maximus Motor Company using the entities and attributes used to create the database.
Maximus Motor Company has a need for a database to record sales information. This database will be shared by the various dealerships owned by the Maximus Motor Company. The database will allow the dealerships to share customer information and allow for various reports to be run, such as total number of sales at a specific dealership. 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
Field Name
Data Type
Description
Required
Duplicates
customer_id
Number
Unique ID
dealershp_id
Number
Unique ID
Contract_id
Number
Unique ID
trde_in_id
Number
Unique ID
vehicle_stck
Number
Unique ID
Dealership Table
Field Name
Data Type
Description
Required
Duplicates
dealershp_id
Number
Unique ID
dealershp_name
dealershp_addrs
Address
dealershp_phn
Phone Nr
dealershp_max_inv
Number
Max Inv
dealershp_crnt_inv
Number
Current Inv
Customer Table
Field Name
Data Type
Description
Required
Duplicates
customer_id
Autonumber
Unique ID
customer_first_name
First Name
customer_last_name
Last Name
customer_mdl_int
Middle Init
customer_addrs
Address
customer_phone
Phone Nr
customer_dob
Date/Time
Date of Birth
customer_ssn
customer_gross_inc
Currency
Gross Income
customer_cred_rate
Number
Credit rating
customer_mrtg
Yes/No
Have an mrtg?
customer_mrtg_amt
Currency
Amt of mrtg
customer_contacts
Contacts
Vehicle Table
Field Name
Data Type
Description
Required
Duplicates
Vehicle_stck
Autonumber
Invent Nr
Vehicle_make
Vehicle_Model
Model
Vehicle_yr
Build Date
Vehicle_clr
Color
Vehicle_sales_rate
Currency
Price for sale
Vehicle_purchased_price
Currency
Cost @ purchase
Vehicle_Mileage
Number
Mileage
Vehicle_VIN