Database

Database

ER Model and Business Rules has 30 Questions

An action assertion must include which of the following?

Anchor object
Action
Corresponding object
All of the above.
Packaged data models are meant to be exactly right straight out of the box.

True
False
An oval represents which of the following in an EER?

Attribute
Entity
Optional One
Relationship
An action assertion is a statement that expresses some aspect of the static structure of the organization.

True
False
Inheritance is which of the following?

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
A supertype can only have only one subtype.

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

Disjoint with total specialization
Disjoint with partial specialization
Overlap with total specialization
Overlap with partial specialization
There is cardinality on an EER between the supertype and subtype.

True
False
A supertype/subtype hierarchy is which of the following?

Each subtype has only one attribute.
Each supertype has only one attribute.
Each subtype has only one supertype.
Each supertype has only one subtype.
A subtype discriminator of the supertype is an attribute whose values determine the target subtype(s).

True
False
A rectangle represents which of the following in an EER?

Attribute
Entity
Optional One
Relationship
Overlapping and disjoint subtypes have different approaches on how the subtype discriminator is applied.

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

Rectangle
Oval
Diamond
Circle
An entity instance of a subtype represents the same entity instance of a supertype.

True
False
Specialization is which of the following processes?

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 subtypes of the supertype and not forming supertype/subtype relationships.
Defining one or more supertypes of the subtype and not forming supertype/subtype relationships.
A supertype is an entity type that shares common attributes or relationships distinct from other subgroupings.

True
False
Which of the following statements concerning business rules is true?

It should be complex.
It should not be convertible to computer code.
It may include restrictions.
All of the above.
An ERD that has had the entities clustered will display more entities.

True
False
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.
Attributes are assigned at the highest logical level.
Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
Attributes are assigned at the lowest logical level.
Total specialization is represented by double lines between the supertype and subtype on an EER.

True
False
A subtype discriminator is which of the following?

An attribute of the supertype whose values determine the subtype
An attribute of the subtype whose values determine the supertype
An attribute of the supertype whose values determine the supertype
An attribute of the subtype whose values determine the subtype
Generalization is the process of defining more general entity types from a set of more specialized entity types.

True
False
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
It is appropriate to use a supertype/subtype relationship when there are attributes that apply to some of the instances of an entity type.

True
False
A subtype entity name should be which of the following?

A singular noun
Specific to the organization
Concise
All of the above
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
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.
Attributes apply to all of the instances of an entity type.
No attributes apply to any of the instances of an entity type.
Action assertions have traditionally been implemented within an application program.

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

Condition
Integrity Control
Authorization
Enabler
An entity cluster is a set of one or more entity types and associated relationships.

True
False