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.
Highly abstract
Easily Enhanced
Only Entities and Abstract Relationships
No software tool required to define CDM
Created by Business Analysts
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
Entities referred as Tables
Attributes referred as columns
Database compatible table names and columns and db specific data types
Created by Database designer/engineer
Last updated 3 years ago
