Dimensional Modeling

What is a Data Model?
A Data model is a conceptual representation of data structures (tables) required for a database and is very powerful in expressing and communicating the business requirements.Data Modeling Overview:
A data model visually represents the nature of data, business rules governing the data, and how it will be organized in the database. Data Models are created for OLTP databases by normalizing the data and for OLAP databases, data models are created by de-normalizing the data. Usually Data Modelscontains the key database objects like tables, columns, relationships, constraints etc.