Dimension Tables
1 dimension table names should always be in singular
2 All underscores in columns and table names should be replaced with space and type case capitalisation e.g order_id should be Order ID
3 Surrogate keys should be hidden from client tools
Fact Tables
1 Fact table names should be plural
Dimension Tables
1 dimension table names should always be in singular
2 All underscores in columns and table names should be replaced with space and type case capitalisation e.g order_id should be Order ID
3 Surrogate keys should be hidden from client tools
Fact Tables
1 Fact table names should be plural