Question 1

Match each of the following terms with its corresponding definition.
-To illustrate a multivalued attribute,separate the repeating data into another entity,then using a relationship,link the weak entity to its associated regular entity.
A)unary relationship
B)ternary relationship
C)binary relationship
D)relationship
E)repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule

Accepted Answer

A unary relationship is a relationship between an entity and itself.

Question 2

Match each of the following terms with its corresponding definition.
-Specifies that each entity instance of the supertype must be a member of some subtype in the relationship.
A)unary relationship
B)ternary relationship
C)binary relationship
D)relationship
E)repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule

Accepted Answer

The total specialization rule specifies that each entity instance of the supertype must be a member of some subtype in the relationship.

Question 3

Match each of the following terms with its corresponding definition.
-Upper- and lower-case letters are used in naming an entity type.
A)unary relationship
B)ternary relationship
C)binary relationship
D)relationship
E)repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule

Accepted Answer

The answer of Match each of the following terms with...

Question 4

Match each of the following terms with its corresponding definition.
-A singular noun is used to name an entity type.
A)unary relationship
B)ternary relationship
C)binary relationship
D)relationship
E)repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule

Accepted Answer

A singular noun is used to name an entity type.

Question 5

Match each of the following terms with its corresponding definition.
-An association between the instances of one or more entity types that is of interest to the organization.
A)unary relationship
B)ternary relationship
C)binary relationship
D)relationship
E)repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule

Accepted Answer

A relationship is an association between the instances of one or more entity types that is of interest to the organization.

Question 6

Match each of the following terms with its corresponding definition.
-On E-R diagrams,relationships are labeled with verb phrases.
A)unary relationship
B)ternary relationship
C)binary relationship
D)relationship
E)repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule

Accepted Answer

The answer of Match each of the following terms with...

Question 7

Match each of the following terms with its corresponding definition.
-A set of two or more multivalued attributes that are logically related.
A)unary relationship
B)ternary relationship
C)binary relationship
D)relationship
E)repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule

Accepted Answer

A repeating group is a set of two or more multivalued attributes that are logically related.

Question 8

Match each of the following terms with its corresponding definition.
-A recursive relationship is a relationship between the instances of two entity types.
A)unary relationship
B)ternary relationship
C)binary relationship
D)relationship
E)repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule

Accepted Answer

The answer of Match each of the following terms with...

Question 9

Match each of the following terms with its corresponding definition.
-To illustrate a multivalued attribute,enclose it in curly brackets.
A)unary relationship
B)ternary relationship
C)binary relationship
D)relationship
E)repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule

Accepted Answer

A unary relationship is a relationship between instances of a single entity type.

Question 10

Match each of the following terms with its corresponding definition.
-A relationship between the instances of one entity type.
A)unary relationship
B)ternary relationship
C)binary relationship
D)relationship
E)repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule

Accepted Answer

A unary relationship is a relationship between the instances of one entity type.

Question 11

Match each of the following terms with its corresponding definition.
-A simultaneous relationship among instances of three entity types.
A)unary relationship
B)ternary relationship
C)binary relationship
D)relationship
E)repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule

Accepted Answer

A ternary relationship involves a simultaneous relationship among instances of three different entity types.

Question 12

Match each of the following terms with its corresponding definition.
-Specifies that if an entity instance of the supertype is a member of one subtype,it cannot simultaneously be a member of any other subtype.
A)unary relationship
B)ternary relationship
C)binary relationship
D)relationship
E)repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule

Accepted Answer

The disjoint rule specifies that an entity instance of the supertype can only be a member of one subtype and cannot simultaneously be a member of any other subtype.

Question 13

Match each of the following terms with its corresponding definition.
-A many-to-many (or one-to-one)relationship that the data modeler chooses to model as an entity type with several associated one-to-many relationships with other entity types.
A)unary relationship
B)ternary relationship
C)binary relationship
D)relationship
E)repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule

Accepted Answer

An associative entity is used to model a many-to-many or one-to-one relationship as an entity type with several associated one-to-many relationships with other entity types.

Question 14

Match each of the following terms with its corresponding definition.
-The name of the identifier of each entity is underlined on an E-R diagram.
A)unary relationship
B)ternary relationship
C)binary relationship
D)relationship
E)repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule

Accepted Answer

A unary relationship is a relationship between instances of a single entity type.

Question 15

Match each of the following terms with its corresponding definition.
-Specifies that an entity instance can simultaneously be a member of two (or more)subtypes.
A)unary relationship
B)ternary relationship
C)binary relationship
D)relationship
E)repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule

Accepted Answer

The overlap rule specifies that an entity instance can simultaneously be a member of two (or more) subtypes.

Question 16

Match each of the following terms with its corresponding definition.
-An entity instance is a single occurrence of an entity type.
A)unary relationship
B)ternary relationship
C)binary relationship
D)relationship
E)repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule

Accepted Answer

An entity instance is a unique occurrence of an entity type. It is also called an entity occurrence, entity record or row.

Question 17

Match each of the following terms with its corresponding definition.
-Specifies that if an entity instance of the supertype is a member of one subtype,it cannot simultaneously be a member of any other subtype.
A)business rule
B)disjoint rule
C)overlap rule
D)partial specialization rule
E)total specialization rule

Accepted Answer

The disjoint rule specifies that an entity instance of the supertype can belong to only one subtype at a time, meaning that the subtypes are mutually exclusive. This is in contrast to the overlap rule, which allows an entity instance to belong to multiple subtypes at once, and the partial and total specialization rules, which pertain to the relationship between supertypes and subtypes. The business rule is a more general term and could apply to any rule governing an organization's operations.

Question 18

Match each of the following terms with its corresponding definition.
-Many instances of an entity type are represented by data stored in the database.
A)unary relationship
B)ternary relationship
C)binary relationship
D)relationship
E)repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule

Accepted Answer

The answer of Match each of the following terms with...

Question 19

Match each of the following terms with its corresponding definition.
-Specifies that an entity instance of the supertype is allowed not to belong to any subtype.
A)unary relationship
B)ternary relationship
C)binary relationship
D)relationship
E)repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule

Accepted Answer

The partial specialization rule specifies that an entity instance of the supertype is allowed not to belong to any subtype.

Question 20

Match each of the following terms with its corresponding definition.
-A relationship between instances of two entity types.
A)unary relationship
B)ternary relationship
C)binary relationship
D)relationship
E)repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule

Accepted Answer

A binary relationship is a relationship between instances of two entity types.

Quiz 8: Structuring System Data Requirements

Match each of the following terms with its corresponding definition. -To illustrate a multivalued attribute,separate the repeating data into another entity,then using a relationship,link the weak entity to its associated regular entity.

Match each of the following terms with its corresponding definition. -Specifies that each entity instance of the supertype must be a member of some subtype in the relationship.

Match each of the following terms with its corresponding definition. -Upper- and lower-case letters are used in naming an entity type.

Match each of the following terms with its corresponding definition. -A singular noun is used to name an entity type.

Match each of the following terms with its corresponding definition. -An association between the instances of one or more entity types that is of interest to the organization.

Match each of the following terms with its corresponding definition. -On E-R diagrams,relationships are labeled with verb phrases.

Match each of the following terms with its corresponding definition. -A set of two or more multivalued attributes that are logically related.

Match each of the following terms with its corresponding definition. -A recursive relationship is a relationship between the instances of two entity types.

Match each of the following terms with its corresponding definition. -To illustrate a multivalued attribute,enclose it in curly brackets.

Match each of the following terms with its corresponding definition. -A relationship between the instances of one entity type.

Match each of the following terms with its corresponding definition. -A simultaneous relationship among instances of three entity types.

Match each of the following terms with its corresponding definition. -Specifies that if an entity instance of the supertype is a member of one subtype,it cannot simultaneously be a member of any other subtype.

Match each of the following terms with its corresponding definition. -A many-to-many (or one-to-one) relationship that the data modeler chooses to model as an entity type with several associated one-to-many relationships with other entity types.

Match each of the following terms with its corresponding definition. -The name of the identifier of each entity is underlined on an E-R diagram.

Match each of the following terms with its corresponding definition. -Specifies that an entity instance can simultaneously be a member of two (or more) subtypes.

Match each of the following terms with its corresponding definition. -An entity instance is a single occurrence of an entity type.

Match each of the following terms with its corresponding definition. -Specifies that if an entity instance of the supertype is a member of one subtype,it cannot simultaneously be a member of any other subtype.

Match each of the following terms with its corresponding definition. -Many instances of an entity type are represented by data stored in the database.

Match each of the following terms with its corresponding definition. -Specifies that an entity instance of the supertype is allowed not to belong to any subtype.

Match each of the following terms with its corresponding definition. -A relationship between instances of two entity types.