ER Model and Business Rules Use of a supertype/subtype relationship is necessary when which of the following exists? An instance of a subtype participates in a relationship that is unique to that subtype. No attributes apply to any of the instances of an entity type. Attributes apply to all of the instances of an entity type. An instance of a subtype participates in a relationship that is the same as the other subtypes. An instance of a subtype participates in a relationship that is unique to that subtype. No attributes apply to any of the instances of an entity type. Attributes apply to all of the instances of an entity type. An instance of a subtype participates in a relationship that is the same as the other subtypes. ANSWER DOWNLOAD EXAMIANS APP
ER Model and Business Rules When an entity instance must be a member of only one subtype, it is which of the following? Disjoint with partial specialization Disjoint with total specialization Overlap with total specialization Overlap with partial specialization Disjoint with partial specialization Disjoint with total specialization Overlap with total specialization Overlap with partial specialization ANSWER DOWNLOAD EXAMIANS APP
ER Model and Business Rules A supertype/subtype hierarchy is which of the following? Each supertype has only one subtype. Each subtype has only one supertype. Each supertype has only one attribute. Each subtype has only one attribute. Each supertype has only one subtype. Each subtype has only one supertype. Each supertype has only one attribute. Each subtype has only one attribute. ANSWER DOWNLOAD EXAMIANS APP
ER Model and Business Rules Inheritance is which of the following? When a subtype entity inherits values of another subtype attribute When a supertype entity inherits values of the subtype attribute When a subtype entity inherits values of the supertype attribute When a supertype entity inherits values of another supertype attribute When a subtype entity inherits values of another subtype attribute When a supertype entity inherits values of the subtype attribute When a subtype entity inherits values of the supertype attribute When a supertype entity inherits values of another supertype attribute ANSWER DOWNLOAD EXAMIANS APP
ER Model and Business Rules A rectangle represents which of the following in an EER? Entity Relationship Optional One Attribute Entity Relationship Optional One Attribute ANSWER DOWNLOAD EXAMIANS APP
ER Model and Business Rules A subtype discriminator of the supertype is an attribute whose values determine the target subtype(s). False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS