8.2 Conceptual Schema (ER Model)
This lesson covers the design of a database's conceptual schema using the Entity-Relationship (ER) model. Students learn to identify entities, attributes, entity identifiers, relationships, and cardinality from real-world scenarios. It also introduces Extended Entity-Relationship (EER) diagrams to model specialized and generalized scenarios where standard ER diagrams are insufficient.
ප්රධාන සංකල්ප
- Entity (භූතාර්ථ)
- An independent object, person, place, or concept of interest about which data is captured in a database system.
- Attribute (උපලක්ෂණ)
- A property or characteristic that describes an entity, acting as a dependent descriptor of that entity.
- Entity Identifier (භූතාර්ථ හැඳුනුම්කය)
- An attribute or set of attributes that uniquely identifies a specific instance of an entity.
- Relationship (සම්බන්ධතා)
- An association or link between two or more entities, typically identified by verbs in scenario descriptions.
- Cardinality (ගණනීයතාව)
- The numerical relationship expressing how many instances of one entity can relate to instances of another entity (e.g., One-to-One, One-to-Many, Many-to-Many).
- Extended Entity-Relationship (EER) Diagram (විස්තෘත භූතාර්ථ සම්බන්ධතා රූප සටහන)
- An extension of the standard ER diagram used to represent complex structures such as specialization, generalization, and categorization where standard ER concepts are insufficient.
MCQ කට්ටල
MCQ 12විභාගයේදී
- Identifying entities, attributes, and relationships from a given descriptive business scenario
- Drawing a complete ER Diagram (ERD) with correct notation, attributes, and identifiers
- Determining and representing cardinality (1:1, 1:N, M:N) between related entities
- Differentiating between standard ER and EER diagrams to model generalization or specialization scenarios
