Summary Handbook Statistics Final Exam (CIS)2023

___ is the result of adding more semantic constructs to the original entity relationship (ER) model. - -Extended entity relationship model -___ depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities). - -Specialization hierarchy -The attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related. - -subtype discriminator -Subtypes that contain a unique subset of the supertype entity set. - -non-overlapping subtypes -It specifies whether each entity supertype occurrence must also be a member of at least one subtype. - -completeness constraint -Means some supertype occurrences that are not members of any subtype. - -Partial completeness -Means that every supertype occurrence must be a member of at least one subtype. - -Total completeness -The bottom-up process of identifying a higher-level, more generic entity supertype from lower-level entity subtypes. - -generalization -A "virtual" entity type used to represent multiple entities and relationships in the ERD. - -entity cluster -Occurs when you have one entity in two 1:M relationships to other entities, thus producing an association among the other entities that is not expressed in the model. - -fan trap -The entity supertype contains the comm