"If the facts don’t fit the theory, change the facts”
- Albert Einstein
1.Requirement Analysis involves figuring out what information the users need and their processing requirements. The output of this is the Business Information Model (BIM) which shows major entities and their relationships. This is sometimes referred to as the Business Model or the Business Impact Model.
2.Logical Modeling determines defining the tables and their relationships, and this should be independent of a particular database or indexing strategy. Greenplum works well with a Third Normal Form (3NF) model, and the output defines all tables and their columns and the Primary Key Foreign Key ...