DB Model Flashcards
What is a Data Model
It defines how data is structured, stored, and accessed. They serve as a blueprint for creating database systems
Enumerate the Components of a Data Model
- Entities
- Attributes
- Relations
- Constraints
This component represents real-world concepts or objects
Entities
This component contains characteristics or properties of entities
Attributes
This component defines how entities are connected to each other
Relations
This component specifies rules that restrict values that can be stored
Constraints
These are also referred to as columns in a table
Attributes
These are stored as a table in a Relational Database
Entities
These are represented as Foreign Keys in Tables
Relations
Define Data Modeling
It creates a visual representation of data entities, their attributes, and relationships, usually via an ERD
These define specific policies or conditions to be enforced by the database
Business Rules
Enumerate the Stages of Data Modeling
- Conceptual Database Design
- Logical Database Design
- Physical Database Design
This stage of data modeling focuses on the data that needs to be stored and its relation to other data
Conceptual Database Design
This stage of data modeling translates the conceptual design into a Schema
Logical Database Design
This stage of data modeling concerns the storage and access of data for optimized performance
Physical Database Design
