Relational Data Modeling

Relational data modeling refers to the process of breaking down complex real-world information into tables and data.
Relational data modeling generally consists of several steps.

Requirements Analysis

Requirements analysis involves identifying what needs to be done with the real-world information.

Typically, developers receive deliverables such as a project plan to understand the information needed for the program.

Requirements analysis is the most crucial stage in the data modeling process, and most issues arise during this phase.

The best way to prevent problems during the requirements analysis stage is to collaborate with the individuals requesting the program and sketch out the program's UI(User Interface) together to align everyone's understanding.

Conceptual Data Modeling

This stage involves identifying the concepts needed for the task and modeling how these concepts interact with each other.

Usually, it is depicted diagrammatically using an ERD(Entity Relationship Diagram) drawn with Crow's Foot Notation.

[Conceptual Data Modeling]

Logical Data Modeling

The ERD, which is the output of the conceptual data modeling process, is transformed into logical tables.

[Logical Data Modeling]⁠⁠⁠⁠⁠⁠⁠

Physical Data Modeling

The tables created during the logical data modeling process are represented as SQL statements that can be used in a real database.

Relational data modeling is the process of taking a complex real-world problem, abstracting it, and transferring it to a computer.