Maximus Database Relationships
Order custom writing paper now!
  • 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 quote
 
Title: Maximus Database Relationships

Essay Details:

Subject: Biographies
Author: Luis G
Date: May 25, 2012
Level: University
Grade: A
Length: 3 / 678

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

Showed 18% of text Buy database access to get full access to all 184 988 essays

Calculate a fair price for your order

Do you need an essay?

A professional team of writers is able to craft custom essays from scratch according to your instructions. We are ready to satisfy writing needs of every demanding customer.

Price start from $11.99 / page
Order now

Do you need many essays?

The product provided is intended to be used for research or study purposes. Get instant access to over 200,000 papers.

Price start from $28.95 / month
Buy database access
101 4.9 5

Feedback of people who used our services.

Rudy A., Los Angeles. CA

My experience with ManyEssays.com is extremely satisfying! I was amazed on your user-friendly website which is very helpful. I have also happy on how your customer service experts ...

Rebecca G., Portland, OR

I would like to say thank you for the level of excellence on providing written works. My University required us a very difficult paper using a very specific writing format and ...

Michael S.,Austin, TX

I am happy with the results your company gives. ManyEssays.com is the best place for essays!

Vincent S., Boston, MA

I was given by my professor a very difficult essay assignment and I really don’t know what to do. I needed help and ManyEssays.com came at the right time. I quickly availed your ...

Conrad H., Pasadena, CA

I am very happy on the excellent job your writers did on my thesis. It was beautiful in every way, it was a literary masterpiece! Everything was done according to instructions and ...

Alex M., Richmond, VA

A top-notch organization all the way and a model in excellent service, your company is. The level of expertise in your field is exceptional as you have in your employment the best ...

Emily R., Boston, MA

Your writing service is so amazing! I was skeptic at first on how your company provides result, but my skepticism gradually vanished immediately after you had finished one task in ...

Timothy J., Houston, TX

Your services were an important factor for my academic advance during my college years. I really thank you that you were there when I needed help in my term paper. Your company ...

Similar Essays:

Clarkson Lumber Company

1 pages / 254 words

Forecasting Report on Drive-In Theatres

5 pages / 1267 words

Chinese Head Tax

3 pages / 743 words

Head Start

2 pages / 454 words

CENTRIFUGAL PUMP

2 pages / 326 words

forecasting

3 pages / 611 words

the future of robots

1 pages / 300 words