A Method for Data Warehouse Design - Data Warehouse Systems: Design and Implementation - page 392

Subordinate

ShippedVia Managed ReportsTo

(1,n) (1,1) (1,1) (1,n) (0,1)

Shippers Orders Employees

(0,n)
Supervisor ShipperID

CompanyName
Phone

OrderID
OrderDate
RequiredDate
ShippedDate (0,1)
Freight
ShipName
ShipAddress
ShipCity
ShipRegion (0,1)
ShipPostalCode (0,1)
ShipCountry

EmployeeID
Name
FirstName
LastName
Title
TitleOfCourtesy
BirthDate
HireDate
Address
City
Region (0,1)
PostalCode
Country
HomePhone
Extension
Photo (0,1)
Notes (0,1)
PhotoPath (0,1)

Place

(1,1)

(1,n)

Customers

CustomerID
CompanyName
ContactName
ContactTitle
Address
City
Region (0,1)
PostalCode (0,1)
Country
Phone
Fax (0,1)

(1,n)

OrderDetails

UnitPrice
Quantity
Discount

(1,n)

(1,n)

Products

Employee
Territories

ProductID
ProductName
QuantityPerUnit
UnitPrice
UnitsInStock
UnitsOnOrder
ReorderLevel
Discontinued
/NumberOrders

(1,1 )

(1,n)

Supplies

Territories

(0,n)

TerritoryID
TerritoryDescription

Suppliers

SupplierID
CompanyName
ContactName
ContactTitle
Address
City
Region (0,1)
PostalCode
Country
Phone
Fax (0,1)
Homepage (0,1)

(1,1)

Belongs

(1,1)

(1,n)

HasCategory

Regions

(0,n)

RegionID
RegionDescription

Categories

CategoryID
CategoryName
Description
Picture

Fig. 10.4 Conceptual schema of the Northwind database (repeated from Fig. 2.1 )