Graphical Notation - Data Warehouse Systems: Design and Implementation - page 581

name

Sales

Fact
(short description)

name

Sales

Quantity
Amount

measures

Fact
(with measures shown)

(0,1)
(1,1)

(0,n)
(1,n)

Cardinalities

Many-to-one
dimension

Customer
CustomerId
CompanyName
...

Role-playing
dimension

Many to-many
dimension

OrderDate

Time SalesReason

Sales

Date
DayNbWeek
...

DueDate SalesReasonId

SalesReasonDesc
...

Quantity
Amount

One-to-one
dimension

Order

OrderNo
DeliveryAddress
...

Types of dimensions

leaf level root level

criterion cardinalities

Product

Category
CategoryName
Description

Department
DepartmentName
Description

ProductNumber
ProductName
Description
Size

parent level

child level

Balanced hierarchy