Microsoft Office Tutorials and References
In Depth Information
Table 1-3. continued )
Table Name
Column Name
Data Type
Key
Dim_SalesTerritoryHistory
SalesTerritoryHistoryID
Int, not null
PK
SalesPersonID
Int, not null
FK (to SalesPersonID in
Dim_SalesPerson table)
TerritoryID
Int, not null
FK (to TerritoryID in
Dim_SalesTerritory table)
StartDate
Date, null
EndDate
Date, null
Dim_Store
StoreID
Int, not null
PK
CustomerID
Int, not null
FK (to CustomerID in
Dim_Customer table)
SalesPersonID
Int, not null
FK (to SalesPersonID in
Dim_SalesPerson table)
Fact_SalesOrderDetails
SalesOrderID
Int, not null
PK
SalesOrderHeaderID
Int, not null
FK (on SalesOrderHeaderID in
Dim_SalesOrderHeader table)
DateKey
Int, not null
FK (to DateKey in
Dim_DateTime table)
CustomerID
Int, not null
FK (to CustomerID in
Dim_Customer table)
TerritoryID
Int, not null
FK (to TerritoryID in
Dim_SalesTerritory table)
After you build these tables, the final tables and their relations would look pretty much as shown in Figure 1-33 .
 
Search JabSto ::




Custom Search