# Conceptual, Logical, and Physical Models

## What is data modeling

Data models are built during the analysis and design phases of the project to collect and understand all the **requirements** for the product.

Starts with the collection of **business rules** which are then translated into **data structures** and creates a **database design**.

Models are conversion of business processes and requirements into graphical objects and relationships.

Data modelers translate the business requirements to architecture.

## Modeling Types

### Conceptual Model

* Highly abstract
* Easily Enhanced
* Only Entities and Abstract Relationships
* No software tool required to define CDM
* Created by Business Analysts

![](https://3167488510-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FN5Oxfr1ogoEGQMX2dzNM%2Fuploads%2F8tnmRTMI5LtR7Q4UmryS%2Fimage.png?alt=media\&token=a63323ce-35fd-43cb-bf10-23467bff2600)

### Logical Model

* Presence of attributes
* Primary and Foreign key relations
* Data Modeling Tools like Erwin and Power Designer
* They can be converted to Physical Data Models with help of these tools
* Created by Business Analysts

![](https://3167488510-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FN5Oxfr1ogoEGQMX2dzNM%2Fuploads%2F3IX1D0Lc9EHbFJkhvjOA%2Fimage.png?alt=media\&token=081910ce-9ca8-4b5f-9806-5ab6a6d368d6)

### Physical Model

* Entities referred as Tables
* Attributes referred as columns
* Database compatible table names and columns and db specific data types
* Created by Database designer/engineer

![](https://3167488510-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FN5Oxfr1ogoEGQMX2dzNM%2Fuploads%2FZ0CizcmaarXEEew6xyNG%2Fimage.png?alt=media\&token=649dac18-5e69-43f6-a614-4a969a77152e)