2. Entity–Relationship Data Model

Get Started. It's Free
or sign up with your email address
2. Entity–Relationship Data Model by Mind Map: 2. Entity–Relationship Data Model

1. Basic Concepts

1.1. Model

1.2. Data Model

2. Types of Data Models

2.1. High-level/Conceptual

2.2. Low-level/Physical

2.3. Representational/Implementation

3. Classification of DBMS

3.1. Based on Data Model

3.1.1. RDBMS: Relational data model

3.1.2. OODBMS: Object data model

3.1.3. ORDBMS: Object and Relational data model

3.1.4. Native XML DBMSs: tree-structured (hierarchical) data model

3.2. Based on number of users

3.2.1. Single-user

3.2.2. Multi-user

3.3. Based on number of sites

3.3.1. Centralized

3.3.2. Distributed

3.3.3. Homogeneous

3.3.4. Heterogeneous

4. Phases of Database Modeling

4.1. 1. Requirements collection and analysis

4.2. 2. Conceptual schema/design

4.3. 3. Logical design/data model mapping

4.4. 4. Physical design

5. Entity Relationship (E-R) Model

5.1. Entity

5.1.1. Entity type

5.1.2. Entity set

5.1.3. Weak Entity

5.1.3.1. Identifying/Owner entity type

5.1.3.2. Identifying Relationship

5.1.3.3. Partial Key

5.1.4. Strong Entity

5.2. Attributes

5.2.1. Types

5.2.1.1. Simple/Atomic

5.2.1.2. Composite

5.2.1.3. Single valued

5.2.1.4. Multivalued

5.2.1.5. Stored

5.2.1.6. Derived

5.2.1.7. Complex

5.2.2. Key Attribute

5.2.3. Value Sets/Domains

5.3. Relationship

5.3.1. Relationship Set

5.3.2. Relationship Type

5.3.3. Relationship Instance

5.3.4. Participation

5.3.5. Relationship Degree

5.3.5.1. Binary

5.3.5.2. Ternary

5.3.6. Roles

5.3.7. Recursive Relationships

5.3.8. Constraints on Binary Relationship Types

5.3.8.1. Cardinality Ratios/Mapping Cardinalities

5.3.8.1.1. One-to-one (1:1)

5.3.8.1.2. One-to-many (1:N)

5.3.8.1.3. Many-to-one (N:1)

5.3.8.1.4. Many-to-many (M:N)

5.3.8.2. Participation Constraint

5.3.8.2.1. Total Participation

5.3.8.2.2. Partial Participation

5.3.9. Attributes of Relationship Types

6. ER Diagrams

6.1. Basic Structure

6.1.1. Rectangles divided into two parts

6.1.2. Diamonds

6.1.3. Undivided rectangles

6.1.4. Lines

6.1.5. Dashed lines

6.1.6. Double lines

6.1.7. Double diamonds

6.2. Naming Conventions

6.2.1. Entity Types

6.2.2. Relationship Types

7. Extended Entity-Relationship (EER) Model

7.1. Specialization

7.2. Generalization

7.3. Aggregation

7.4. Inheritance

7.4.1. Single inheritance

7.4.2. Multiple inheritance/Lattice

7.5. Constraints on Specialization and Generalization

7.5.1. Based on Membership

7.5.1.1. Conditioned Defined

7.5.1.2. User Defined

7.5.2. More than one/Not

7.5.2.1. Disjoint

7.5.2.2. Overlapping

7.5.3. Must belong to at least one

7.5.3.1. Total

7.5.3.2. Partial