DW Database Design - Naming Conventions

Follow the Naming conventions.....

1. Name "Surrogate key" as SK at the end
2. Name "Business key" as BK or AK at the end
3. All "Fact" table columns should have Foreign keys back to the "Dimension" tables 

     4) This is a Star Schema...