Question 1

For each of the examples listed below, indicate if it is a relationship, an entity, or an attribute.(Answers may occur more than once.)
-inventory item
A)Attribute
B)Entity
C)Relationship

Accepted Answer

"Inventory item" is an entity, as it represents a distinct object in the system. It is not a relationship, which represents a connection between entities, nor is it an attribute, which describes a characteristic of an entity.

Question 2

For each of the following statements, answer "a" if it is a true statement or answer "b" if the statement is false.
-A recursive relationship is a relationship between the instances of two entity types.

Accepted Answer

The answer of For each of the following statements, answer...

Question 3

For each of the following statements, answer "a" if it is a true statement or answer "b" if the statement is false.
-On E-R diagrams, relationships are labeled with verb phrases.

Accepted Answer

The answer of For each of the following statements, answer...

Question 4

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

Accepted Answer

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

Note: the other terms are not definitions of relationship, but rather different concepts in database design.

Question 5

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

Accepted Answer

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

Question 6

For each of the examples listed below, indicate if it is a relationship, an entity, or an attribute.(Answers may occur more than once.)
-product
A)Attribute
B)Entity
C)Relationship

Accepted Answer

"product" is an entity, as it represents a distinct object or thing that can be described and given attributes. It is not a relationship, as it does not describe any connections or associations between entities, and it is not an attribute, as it represents a whole object rather than a characteristic or property of an object.

Question 7

For each of the examples listed below, indicate if it is a relationship, an entity, or an attribute.(Answers may occur more than once.)
-is ordered on
A)Attribute
B)Entity
C)Relationship

Accepted Answer

"is ordered on" suggests that there is a relationship between two entities, such as a customer placing an order for a product. It is not an attribute, which describes a characteristic of an entity, nor is it an entity itself.

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

Ternary relationship is a simultaneous relationship among instances of three entity types.

Question 11

For each of the examples listed below, indicate if it is a relationship, an entity, or an attribute.(Answers may occur more than once.)
-sells
A)Attribute
B)Entity
C)Relationship

Accepted Answer

"Sells" indicates a relationship between two entities, typically between a seller and a buyer. It is not an attribute because it describes a connection between two separate entities, and it is not an entity because it does not represent a distinct object or concept.

Question 12

For each of the following statements, answer "a" if it is a true statement or answer "b" if the statement is false.
-The name of the identifier of each entity is underlined on an E-R diagram.

Accepted Answer

The answer of For each of the following statements, answer...

Question 13

For each of the following statements, answer "a" if it is a true statement or answer "b" if the statement is false.
-The goal of conceptual data modeling is to identify as much of the processing activity as possible.

Accepted Answer

The answer of For each of the following statements, answer...

Question 14

For each of the examples listed below, indicate if it is a relationship, an entity, or an attribute.(Answers may occur more than once.)
-sale
A)Attribute
B)Entity
C)Relationship

Accepted Answer

The answer of For each of the examples listed below,...

Question 15

Match each of the following terms with its corresponding definition.
-A named property or characteristic of an entity that is of interest to the organization
A)Entity
B)Entity type
C)Attribute
D)Multivalued attribute
E)Entity instance

Accepted Answer

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

Question 16

Match each of the following terms with its corresponding definition.
-An attribute that can have more than one value for each entity instance
A)Entity
B)Entity type
C)Attribute
D)Multivalued attribute
E)Entity instance

Accepted Answer

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

Question 17

Match each of the following terms with its corresponding definition.
-A collection of entities that share common properties or characteristics
A)Entity
B)Entity type
C)Attribute
D)Multivalued attribute
E)Entity instance

Accepted Answer

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

Question 18

For each of the following statements, answer "a" if it is a true statement or answer "b" if the statement is false.
-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.

Accepted Answer

The answer of For each of the following statements, answer...

Question 19

For each of the examples listed below, indicate if it is a relationship, an entity, or an attribute.(Answers may occur more than once.)
-quantity sold
A)Attribute
B)Entity
C)Relationship

Accepted Answer

"Quantity sold" is an attribute as it describes a characteristic or property of an entity, such as a product or transaction.

Question 20

Match each of the following terms with its corresponding definition.
-An entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances
A)Unary relationship
B)Ternary relationship
C)Binary relationship
D)Relationship
E)Repeating group
F)Associative entity

Accepted Answer

An associative entity is an entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances.

Answer: C
 A binary relationship is a relationship between two entity types.

Answer: B
 A ternary relationship is a relationship between three entity types.

Answer: D
 A relationship is an association between two or more entities.

Answer: E
 A repeating group is a group of related fields that can occur multiple times within a single record. It is not a type of relationship.

Answer: A 
 A unary relationship is a relationship between instances of the same entity type.

Quiz 7: Structuring System Requirements: Conceptual Data Modeling

For each of the examples listed below, indicate if it is a relationship, an entity, or an attribute.(Answers may occur more than once.) -inventory item

For each of the following statements, answer "a" if it is a true statement or answer "b" if the statement is false. -A recursive relationship is a relationship between the instances of two entity types.

For each of the following statements, answer "a" if it is a true statement or answer "b" if the statement is false. -On E-R diagrams, relationships are labeled with verb phrases.

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. -A set of two or more multivalued attributes that are logically related

For each of the examples listed below, indicate if it is a relationship, an entity, or an attribute.(Answers may occur more than once.) -product

For each of the examples listed below, indicate if it is a relationship, an entity, or an attribute.(Answers may occur more than once.) -is ordered on

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

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

For each of the examples listed below, indicate if it is a relationship, an entity, or an attribute.(Answers may occur more than once.) -sells

For each of the following statements, answer "a" if it is a true statement or answer "b" if the statement is false. -The name of the identifier of each entity is underlined on an E-R diagram.

For each of the following statements, answer "a" if it is a true statement or answer "b" if the statement is false. -The goal of conceptual data modeling is to identify as much of the processing activity as possible.

For each of the examples listed below, indicate if it is a relationship, an entity, or an attribute.(Answers may occur more than once.) -sale

Match each of the following terms with its corresponding definition. -A named property or characteristic of an entity that is of interest to the organization

Match each of the following terms with its corresponding definition. -An attribute that can have more than one value for each entity instance

Match each of the following terms with its corresponding definition. -A collection of entities that share common properties or characteristics

For each of the following statements, answer "a" if it is a true statement or answer "b" if the statement is false. -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.

For each of the examples listed below, indicate if it is a relationship, an entity, or an attribute.(Answers may occur more than once.) -quantity sold

Match each of the following terms with its corresponding definition. -An entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances