CMIS-420 Project #2

date

gross

sale

price

sale_ID

zip

cust_ID

salesperson_ID

OS_ID

dist_ID

dealer_ID

manager

phone

sq_ft

location

dist_ID

VIN

sale_ID

trade_ID

trade_in

amount

hire_date

openDate

OVC, Inc. Database ERD

includes

part of

becomes

part of

makes

comes

from

VIN

wherefrom

type

model

make

part of

includes

works at

employs

contains

comes

from

makes

made by

has

belongs to

comes from

part of

includes

ship_date

facilitates

facilitated by

part of

includes

trade_ID

dealer_ID

phone

address

street

city

state

POC

zip

has

belongs

to

FINANCING

PLAN

SALE

FINANCING

SALE

SALEPERSON

DEALERSHIP

CUSTOMER

SALE

VEHICLE

TRADE_IN

VEHICLE

ORDER

SHIPMENT

DISTRIBUTOR

plan_ID

state

first

name

cust_ID

loan_term

wholesale_cost

down_pay

plan_ID

sale_ID

percentage

max_loan_amt

max_term

Loan_type

Institution

min_down

city

street

address

MI

last

region

MI

last

first

name

title

salesperson_ID

vehicle

status

mileage

VIN