10.1.1 Data models

• Data models are blueprints for structuring and organizing data in databases
• There are two primary types of data models: conceptual and logical.
• The logical data model provides a detailed plan for implementing the database structure
• Match the type of data model with its purpose:

  Conceptual ↔️ To understand the scope and structure of data from a business perspective

  Logical ↔️ To provide a detailed plan for implementing the database structure
• What is one reason why data models are important for organization?

  Define relationships between entities
• Data models ensure consistency by establishing standards for data storage and retrieval
• Entities in a data model represent real-world objects or concepts.
• What are attributes in a data model?

  Characteristics of entities
• Relationships in a data model describe connections between entities
• What is an example of a relationship in a university database?

  Enrollment between students and courses
• What are data models used for in databases?

  Structuring and organizing data
• There are two primary types of data models: conceptual and logical
• Match the type of data model with its purpose:

  Conceptual ↔️ Understanding data structure from a business perspective

  Logical ↔️ Providing a detailed plan for database implementation
• A conceptual data model in a CRM system might include entities like "Customers" and "Products."
• What is the purpose of a conceptual data model?

  High-level blueprint of data
• A logical data model includes tables, keys, constraints, and data types
• Match the type of data model with its example:

  Conceptual ↔️ Customer orders products

  Logical ↔️ Customer table referencing product table via foreign key
• Why are data models important in database management?

  Ensuring organization and efficiency
• Data models provide a clear structure for organizing data and relationships between entities.
• A data model is composed of entities, attributes, and relationships
• What is an entity in a data model?

  Real-world object or concept
• Relationships in data models define connections between entities.
• Match the relationship type with its example:

  One-to-one ↔️ Person and passport number

  One-to-many ↔️ Customer placing multiple orders

  Many-to-many ↔️ Students enrolling in multiple courses
• What is a one-to-one relationship in a data model?

  Uniqueness and direct association
• A many-to-many relationship requires an intermediate table