1 / 7

CHAPTER 6.1

CHAPTER 6.1. Sometimes referred also as “enhanced entity relationship model”. It is the result of adding more semantic constructs to the original entity relationship (ER) model. To follow closely the complexity of real world scenario. THE EXTENDED ENTITY RELATIONSHIP MODEL (EERM).

desma
Download Presentation

CHAPTER 6.1

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CHAPTER 6.1 • Sometimes referred also as “enhanced entity relationship model”. • It is the result of adding more semantic constructs to the original entity relationship (ER) model. • To follow closely the complexity of real world scenario. THE EXTENDED ENTITY RELATIONSHIP MODEL (EERM)

  2. Entity Supertypes and Subtypes • Specialization hierarchy • Depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities) • Supertype entity • Contains shared attributes • Subtype entity • Contains unique attributes • Supertype and its subtype(s) maintain a 1:1 relationship.

  3. Disjoint Subtypes • Also known as non-overlapping subtypes. • Subtypes that contain a subset of the supertype entity set • Each entity instance (row) of the supertype can appear in ONLY ONE of the disjoint subtypes • Disjoint subtypes are indicated by the symbol “G” (Chen) or “d” (Crow Foot).

  4. Overlapping Subtypes • Overlapping subtypes are subtypes that contain a subset of the supertype entity set. • However, each entity occurrence (row) of the supertype can appear in MORE THAN ONE subtypes. • Overlapping subtypes are indicated by the symbol “Gs” (Chen) or “o” (Crow Foot).

  5. A Specialization Hierarchy

  6. A Specialization Hierarchy with Overlapping Subtypes

  7. COMPLETENESS CONSTRAINTS • Specifies whether each entity occurrence must also be a member of subtype • Partial completeness • Some supertype occurrences are NOT members of any subtype • Single horizontal line • Complete completeness • Must be a member of AT LEAST ONE subtype • Double horizontal line • Refer Pg. 185 & 188

More Related