Logical Data Model - Design Step -2

This is Second step for Designing 

Good Logical data model in data warehouse implementation is very important. Logical data model has to be detailed (though some might not agree) as it represents the entire business in one shot and shows relationship between business entities. Logical Model should have following things to make it detailed and self explanatory.

1. All entities to be included in data warehouse
2. All possible attributes of each entity
3. Primary keys of each entity ( Natural Keys as well as Surrogate Keys )
4. Relationships between each every entity

Characteristics of Data Warehouse Logical Data Model

1. It has all the entities which will be used in data warehouse
2. It shows all possible attributes of all entities
3. It depicts the relationships between all entities