Data Modeling FUNdamentals - 401-advanced-javascript-aimurphy/seattle-javascript-401n13 GitHub Wiki

Data modeling is the process of developing data model for the data to be stored in a Database.
Data Models ensure consistency in naming conventions, default values, semantics, security while ensuring quality of the data.
Data Model structure helps to define the relational tables, primary and foreign keys and stored procedures.

3 Types: Conceptual, Logical, Physical; 2 techniques: E-R and UML

Conceptual: This Data Model defines WHAT the system contains. This model is typically created by Business stakeholders and Data Architects. The purpose is to organize, scope and define business concepts and rules. Logical: Defines HOW the system should be implemented regardless of the DBMS. This model is typically created by Data Architects and Business Analysts. The purpose is to developed technical map of rules and data structures. Physical: This Data Model describes HOW the system will be implemented using a specific DBMS system. This model is typically created by DBA and developers. The purpose is actual implementation of the database.

The two types of Data Models techniques are Entity Relationship (E-R) Model UML (Unified Modeling Language)