brodie [/url]":a6oqhcom]Can you do a foreign key within a single table, though? Yes. Foreign keys can refer to another column in the same table.

There are times when a foreign key becomes embedded within a table's primary key. In the previous example given above, the CustomerOrderTable has a column named OrderID serving as its primary key. The ...

When working on a multidimensional design, every fact table within scope should be handled with care. In an ideal world, each low-level fact table represents the metrics related to a business event.