# Physical data model
## Definition(s)
### Context: [[Nexus - Google Analytics Certificate Course|Google Analytics Certificate]]
#### Sub-context: [[Data model]]
>[! Definition]
>These data models depict how a database operates. Defines all entities and attributes used. Table names, column names, and data types for the database.
## Examples
Both the image and table below from [1keydata.com](https://www.1keydata.com/datawarehousing/data-modeling-levels.html) Emphasis is my own
| Feature | Conceptual | Logical | ==Physical== |
| -------------------- | ---------- | ------- | ------------ |
| Entity Names | ✓ | ✓ | |
| Entity Relationships | ✓ | ✓ | |
| Attributes | | ✓ | |
| Primary Keys | | ✓ | ✓ |
| Foreign Keys | | ✓ | ✓ |
| Table Names | | | ✓ |
| Column Names | | | ✓ |
| Column Data Types | | | ✓ |
![[Physical_data_model_example.png]]
## Related
[[Data model]]
[[Conceptual data model]]
[[Logical data model]]
## Resources
[1keydata.com](https://www.1keydata.com/datawarehousing/data-modeling-levels.html)
## Flashcards
The below code are generated for use with [Spaced Repetition plugin](https://github.com/st3v3nmw/obsidian-spaced-repetition/) [docs](https://www.stephenmwangi.com/obsidian-spaced-repetition/)
These data models depict how a database operates. Defines all entities and attributes used. Table names, column names, and data types for the database. @@@ [[Physical data model]]