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 the same as the other subtypes. 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. No attributes apply to any of the instances of an entity type. An instance of a subtype participates in a relationship that is the same as the other subtypes. 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. No attributes apply to any of the instances of an entity type. ANSWER DOWNLOAD EXAMIANS APP
ER Model and Business Rules A supertype/subtype hierarchy has which of the following features? Attributes are assigned at the lowest logical level. Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype. Attributes are assigned at the highest logical level. Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype. Attributes are assigned at the lowest logical level. Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype. Attributes are assigned at the highest logical level. Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype. ANSWER DOWNLOAD EXAMIANS APP
ER Model and Business Rules Which of the following statements concerning business rules is true? It should not be convertible to computer code. It should be complex. All of these It may include restrictions. It should not be convertible to computer code. It should be complex. All of these It may include restrictions. 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 total specialization Disjoint with partial specialization Overlap with total specialization Overlap with partial specialization Disjoint with total specialization Disjoint with partial specialization Overlap with total specialization Overlap with partial specialization ANSWER DOWNLOAD EXAMIANS APP
ER Model and Business Rules Specialization is which of the following processes? Defining one or more supertypes of the subtype and not forming supertype/subtype relationships. Defining one or more subtypes of the supertype and not forming supertype/subtype relationships. Defining one or more subtypes of the supertype and forming supertype/subtype relationships. Defining one or more supertypes of the subtype and forming supertype/subtype relationships. Defining one or more supertypes of the subtype and not forming supertype/subtype relationships. Defining one or more subtypes of the supertype and not forming supertype/subtype relationships. Defining one or more subtypes of the supertype and forming supertype/subtype relationships. Defining one or more supertypes of the subtype and forming supertype/subtype relationships. ANSWER DOWNLOAD EXAMIANS APP
ER Model and Business Rules An entity cluster is a set of one or more entity types and associated relationships. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS