# Logical data model ## Definition(s) ### Context: [[Nexus - Google Analytics Certificate Course|Google Analytics Certificate]] #### [[Data model]] >[! Definition] >This data model type focuses on technical details of a database. Items like relationships, attributes and entities but gives no further detail, like table names. More detail than a [[Conceptual data model]] but gives less detail than a [[Physical data model]] ## 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 | ==Logica==l | Physical | | -------------------- | ---------- | ----------- | -------- | | Entity Names | ✓ | ✓ | | | Entity Relationships | ✓ | ✓ | | | Attributes | | ✓ | | | Primary Keys | | ✓ | ✓ | | Foreign Keys | | ✓ | ✓ | | Table Names | | | ✓ | | Column Names | | | ✓ | | Column Data Types | | | ✓ | ![[logical_data_model_example.png]] ## Related [[Data model]] [[Conceptual data model]] [[Physical 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/) This data model type focuses on technical details of a database. Items like relationships, attributes and entities but gives no further detail, like table names. @@@ [[Logical data model]]