SQL 3

TIME

Sale_Day (PK)

Day_Type

SALES_FACTS

Sale_Day (FK)

Vehicle_Code (FK)

Plan_Code (FK)

Dealer_ID (FK)

Vehicles_Sold

Gross_Sales_Amt

...

FINANCING_PLANS

Plan_Code (PK)

Loan_Type

Institution_Name

Loan_Perc_Rate

Min_Down

Max_Loan_Amount

Max_Term

DEALERSHIPS

Dealer_ID (PK)

Location

Region_ID

Street Address

City

State

Zip Code

Phone

Sq Ft

Opened Date

Manager

District_ID

VEHICLES

Vehicle_Code (PK)

Description

Star Schema for OVS, Inc. Data Warehouse

a single

fact

PK of

a fact

calculated values

for each fact