Database modelling
There are four stages in database design:
Analysis of existing situation and needs (clarification).
Creation of a conceptual model to represent all important aspects of the problem.
Translation of the conceptual model into a logical model (and standardization of this logical model).
Implementation of a database in a DBMS, based on the logical model (and optimization).
Analysis: This consists of studying the problem and recording the needs, choices and constraints in a document known as a clarification note.
Conceptual modeling: This is a non-formal (usually graphic) description of the problem at hand, based on simplifying assumptions. It is not a description of reality, but a simplified representation of reality.
Logical modeling: This describes a solution, taking a formal, general IT approach (typically DBMS type), but independently of specific implementation choices.
Implementation: This corresponds to technical choices, in terms of the DBMS chosen, and their implementation (programming, optimization, etc.).
Note :
There are several types of conceptual models used in database design. The Entity-Association (EA), also known as the Entity-Relationship (ER) model, uses entities, attributes, identifiers, and relationships with cardinality to represent data. UML (Unified Modeling Language) is another modeling approach that uses class diagrams to represent entities and their associations. These models are used to visualize the structure of data and guide the design of databases.
