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

distributing attribute

percentage ÷

Employee Section

EmployeeId
EmployeeName
...

SectionName
Description
...

Nonstrict hierarchy

Fiscal
Quarter
QuarterNo
...

FiscalYear

FiscalYear
...

Time Month

Date
...

MonthName
...

Calendar
Quarter
QuarterNo
...

CalendarYear

CalendarYear
...

Alternative hierarchy

State

City

CityName
CityPopulation
CityArea
...

StateName
StateCapital
StatePopulation
...

Customer

CustomerId
FirstName
LastName
BirthDate
Address
...

AgeGroup

AgeGroupId
Description

Parallel independant hierarchies

City

CityName
CityPopulation
CityArea
...

Employee

State

EmployeeId
FirstName
LastName
Title
BirthDate
...

StateName
StateCapital
StatePopulation
...

Territory

TerritoryName
Description

Parallel dependant hierarchies