Database Models
High-level specification for database structure
- Relational Model
- NoSQL, OOM, Network Model
Schemas
Blueprint of the database
- Defines tables, field, relationships, indexes, and views
- Schemas must be respected in insertion of data
Data Modeling
- Conceptual Data Model - describe entities, relationships, and attributes (ERD, UML Diagrams)
- Logical Data Model - defines tables, columns, relationships (Relational Model, and Star Schema)
- Physical Data Model - describes physical storage