![translation](https://cdn.durumis.com/common/trans.png)
This is an AI translated post.
Relational Data Modeling
- Writing language: Korean
- •
-
Base country: All countries
- •
- Information Technology
Select Language
Summarized by durumis AI
- Relational data modeling is the task of dividing real-world information into tables and data, and consists of the stages of requirement analysis, conceptual data modeling, logical data modeling, and physical data modeling.
- Requirement analysis is the most important stage in the data modeling process, and it is important to match thoughts by drawing UI together with people who want to create the program.
- Conceptual modeling uses ERD to divide concepts and express interactions, logical modeling converts ERD into logical tables, and physical modeling represents tables in SQL statements.
Relational data modeling is the process of dividing complex real-world information into tables and data.
Relational data modeling is largely composed of several procedures.
Requirements Analysis
Requirements analysis is the process of determining what the real-world information is about.
Generally, developers obtain deliverables such as planning documents to understand the information needed in the program.
Requirements analysis is the most important process in data modeling, and most problems occur at the requirements analysis stage.
The best way to prevent problems in the requirements analysis stage is to draw the UI(User Interface) together with the person who wants to create the program, aligning each other's thoughts.
Conceptual Data Modeling
This is the stage of modeling the concepts necessary for the work you want to do and how each concept interacts with each other.
Usually, it is expressed schematically by drawing an ERD(Entity Relationship Diagram) using the Crow's foot notation.
Logical Data Modeling
The ERD, which is the output of the conceptual data modeling process, is converted into a logical table.
[Logical Data Modeling]
Physical Data Modeling
The tables created in the logical data modeling process are expressed as SQL statements that can be used in the actual database.
Relational data modeling is the process of extracting complex real-world problems and translating them into a computer through an abstraction process.