ER Model Business(Ict-Basic)Q1

Use of a supertype/subtype relationship is necessary when which of the following exists?

1 Mark(s)

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.
No attributes apply to any of the instances of an entity type.
An instance of a subtype participates in a relationship that is unique to that subtype.

A supertype/subtype hierarchy is which of the following?

1 Mark(s)

Which of the following is not one of the three ways to classify an action assertion?

1 Mark(s)

. A supertype/subtype hierarchy has which of the following features?

1 Mark(s)

Attributes are assigned at the highest logical level.
Attributes are assigned at the lowest 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.

Specialization is which of the following processes?

1 Mark(s)

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.

A rectangle represents which of the following in an EER?

1 Mark(s)

An oval represents which of the following in an EER?

1 Mark(s)

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?

1 Mark(s)

Which of the following statements concerning business rules is true?

1 Mark(s)

Which one of the following symbols is not used in an ERD?

1 Mark(s)

An action assertion must include which of the following?

1 Mark(s)

A subtype entity name should be which of the following?

1 Mark(s)

When an entity instance must be a member of only one subtype, it is which of the following?

1 Mark(s)

A subtype discriminator is which of the following?

1 Mark(s)

ER Model Business(Ict-Basic)Q1 : Question 1 of 14