ER Model and Business Rules An oval represents which of the following in an EER? Entity Optional One Attribute Relationship Entity Optional One Attribute Relationship 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? Overlap with partial specialization Disjoint with partial specialization Overlap with total specialization Disjoint with total specialization Overlap with partial specialization Disjoint with partial specialization Overlap with total specialization Disjoint with total specialization ANSWER DOWNLOAD EXAMIANS APP
ER Model and Business Rules If an entity adheres to the disjoint rule, then an entity instance can be a member of more than one entity for a given supertype. True False True False ANSWER DOWNLOAD EXAMIANS APP
ER Model and Business Rules When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following? Disjoint with partial specialization Disjoint with total specialization Overlap with partial specialization Overlap with total specialization Disjoint with partial specialization Disjoint with total specialization Overlap with partial specialization Overlap with total specialization ANSWER DOWNLOAD EXAMIANS APP
ER Model and Business Rules A supertype/subtype hierarchy has which of the following features? Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype. Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype. Attributes are assigned at the lowest logical level. Attributes are assigned at the highest logical level. Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype. Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype. Attributes are assigned at the lowest logical level. Attributes are assigned at the highest logical level. ANSWER DOWNLOAD EXAMIANS APP
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. An instance of a subtype participates in a relationship that is the same as the other subtypes. 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 unique to that subtype. An instance of a subtype participates in a relationship that is the same as the other subtypes. No attributes apply to any of the instances of an entity type. Attributes apply to all of the instances of an entity type. ANSWER DOWNLOAD EXAMIANS APP