[AccessD] Primary Key Best Practices

Great points! 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert L. Stewart

In a transactional database, all tables have a surrogate, autonumbering
primary key. They also have one or more unique indexes on the candidate key
or keys. Also, indexes on all foreign key columns.

In a data warehouse or data mart, all dimension tables will have a single
column primary key inherited from the source primary table.
All fact tables will have multiple columns that make up the primary key.
There are no snowflakes. It is a true star schema.