Conceptual Data Warehouse Design - Data Warehouse Systems: Design and Implementation - page 89

Employee City

EmployeeID
FirstName
LastName
Title
BirthDate
HireDate
Address
City
Region
PostalCode
Country

CityName

Supplier

SupplierID
CompanyName
Address
PostalCode

State

StateName
EnglishStateName
StateType
StateCode
StateCapital

Customer

CustomerID
CompanyName
Address
PostalCode

Supervision
Subordinate

Region

RegionName
RegionCode

Time

Sales

Date
DayNbWeek
DayNameWeek
DayNbMonth
DayNbYear
WeekNbYear
Calendar

Quantity
UnitPrice: Avg +!
Discount: Avg +!
SalesAmount
Freight
/NetAmount

OrderDate

Country

DueDate

CountryName
CountryCode
CountryCapital
Population
Subdivision

ShippedDate

Month Product

MonthNumber
MonthName

ProductID
ProductName
QuantityPerUnit
UnitPrice
Discontinued

Continent

ContinentName

Quarter

Categories

Shipper

Quarter

ShipperID
CompanyName

Category

Semester

CategoryID
CategoryName
Description

Semester

Order

OrderNo
OrderLineNo

Year

Year

Fig. 4.2 Conceptual schema of the Northwind data warehouse

every sale is related to only one order line and that each order line has only
one sale.
A fact may contain attributes commonly called measures .Thesecontain
data (usually numerical) that are analyzed using the various perspectives