What are the phases in the data modelling development cycle?

1.	What are the phases in the data modelling development cycle?
Answer» There are 5 phases in data modelling: Gather Business REQUIREMENTS: The first phase is to gather the functional requirements and what are the reporting needs from the business analysts and the end-users. Conceptual Data Modeling(CDM): Then depending on the requirements, come up with a conceptual data model that includes major entities and relationships between them. This model will be used in the INITIAL Planning Phase. Logical Data Modeling(LDM): Post the creation of a conceptual model, create a logical data model that describes the logical representation of the business requirements in the organization. Physical Data Modeling(PDM): Here, we create a complete data model which includes required tables, columns in them, relationships between different entities and PROPERTIES for the implementation of the database. Database: Based on the physical data model created, the SQL codes would be generated with the help of the data modelling TOOLS and these codes (queries) are then executed on the server for creating the database entities.

Answer»

There are 5 phases in data modelling:

Gather Business REQUIREMENTS: The first phase is to gather the functional requirements and what are the reporting needs from the business analysts and the end-users.
Conceptual Data Modeling(CDM): Then depending on the requirements, come up with a conceptual data model that includes major entities and relationships between them. This model will be used in the INITIAL Planning Phase.
Logical Data Modeling(LDM): Post the creation of a conceptual model, create a logical data model that describes the logical representation of the business requirements in the organization.
Physical Data Modeling(PDM): Here, we create a complete data model which includes required tables, columns in them, relationships between different entities and PROPERTIES for the implementation of the database.
Database: Based on the physical data model created, the SQL codes would be generated with the help of the data modelling TOOLS and these codes (queries) are then executed on the server for creating the database entities.

Discussion