අන්තර්ගතයට යන්න
mcqdinethlive

Unit 8, Database Management

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