Database Reference
In-Depth Information
Family
Country
Customer
Family Name
Country Name
Country Geom
Customer ID
First Name
Middle Initial
Last Name
Birth Date
Gender
Education
Marital Status
Member Card
Yearly Income
Occupation
Total Children
Nb Children Home
House Owner
Nb Cars Owned
Customer Geom
Department
State
Department Name
State Name
State Geom
Category
Category Name
City
City Name
City Geom
Subcategory
Subcategory Name
Geography
Class
Store
Product
Product ID
Product Name
SKU
SRP
Year
Store ID
Store Name
Store Type
Store Manager
Store Sqft
Grocery Sqft
Frozen Sqft
Meat Sqft
Coffe Bar
Store Geom
Year No
Quarter
Brand
Quarter Name
Brand
Month
Brand Name
Month No
Month Name
Promotion
Sales
Promotion Name
Calendar
Store Sales
Store Cost
Unit Sales
/Sales Average
/Profit
Media
Time
Date
Day Name Week
Day Nb Month
Week Nb Year
Promotion Media
Media Type
Fig. 11.19
Conceptual schema of the GeoFoodmart cube
(c) Display the unit sales by product brand, considering only sales to
customers from a country different from the country of the store.
(d) Display all measures summarized for the stores located in California
or Washington, considering only stores in California that are less
than 200km from Los Angeles and stores in Washington that are
less than 200km from Seattle.
(e) Total sales of stores located at less than 5km from the city center
against total sales for all stores in their state.
(f) For each store, list total sales to customers living closer than 10km
from the store against total sales for the store.
Search WWH ::
Custom Search