Assignment 3: Entity-Relationship (ER) Modeling and the Use of Super/Sub Structures
Outcomes addressed in this activity:
Unit Outcomes:
• Define the construct of supertype and subtype.
• Identify overlap and disjoint subtypes.
• Identify completeness & disjoint constraints.
• Prepare an enhanced entity relationship (EER) model.
Course Outcome:
IT525-2: Use entity-relation diagrams in the design of a database.
Purpose:
This Assignment will allow you to demonstrate practical knowledge of supertype/subtype concepts and will have you create an ERD with supertype/subtype constructs and required attributes.
Define the construct of supertype and subtype.
