02. Data Models Basics

Schemas allow us to have and have the ability to plan in advance

Pasted image 20250905164256.png

A formal definition on how to represent data and the operations allowed on it.

Structure
Integrity
Manipulation

Logical schema = Conceptual schema (all relationships and entities) in the chosen data model(adapted to the capabilities and restrictions of our data model).

Pasted image 20250905170151.png Foreign keys constrains: Pasted image 20250905170252.png