Question 1

In an E-R diagram, there are/is ________ business rule(s) for every relationship.

Accepted Answer

A)  two 
B)  three 
C)  one 
D)  zero 
A)  two 
B)  three 
C)  one 
D)  zero A

Question 2

The total quiz points for a student for an entire semester is a(n) ________ attribute.

Accepted Answer

A)  derived 
B)  mixed 
C)  stored 
D)  addressed 
A)  derived 
B)  mixed 
C)  stored 
D)  addressed A

Question 3

In the figure below, Name would be an ideal identifier.

Accepted Answer

A) True 
 B)False  False

Question 4

The number of entity types that participate in a Unary relationship is:

Accepted Answer

A)  zero. 
B)  one. 
C)  two. 
D)  three. 
A)  zero. 
B)  one. 
C)  two. 
D)  three.

Question 5

The relationship among the instances of three entity types is called a unary relationship.

Accepted Answer

A) True 
 B)False

Question 6

In the following diagram, which of the answers below is true?

Accepted Answer

A)  Each patient has one or more patient histories. 
B)  Each patient has one and only one visit. 
C)  Each patient history belongs to zero and one patient. 
D)  Each patient history belongs to many patients. 
A)  Each patient has one or more patient histories. 
B)  Each patient has one and only one visit. 
C)  Each patient history belongs to zero and one patient. 
D)  Each patient history belongs to many patients.

Question 7

How is a strong entity different from a weak entity?

Accepted Answer

A strong entity type exists independentl

Question 8

The name used for an entity type should never be the same in other E-R diagrams on which the entity appears.

Accepted Answer

A) True 
 B)False

Question 9

In an E-R diagram, strong entities are represented by double-walled rectangles.

Accepted Answer

A) True 
 B)False

Question 10

The E-R model is used to construct a conceptual model.

Accepted Answer

A) True 
 B)False

Question 11

In the figure shown below, which of the following business rules would apply?

Accepted Answer

A)  Each vendor can supply many parts to any number of warehouses, but need not supply any parts. 
B)  Each part must be supplied by exactly one vendor to any number of warehouses. 
C)  Each warehouse can be supplied with any number of parts from more than one vendor, and each warehouse could be supplied with no parts. 
D)  VENDOR is not allowed. 
A)  Each vendor can supply many parts to any number of warehouses, but need not supply any parts. 
B)  Each part must be supplied by exactly one vendor to any number of warehouses. 
C)  Each warehouse can be supplied with any number of parts from more than one vendor, and each warehouse could be supplied with no parts. 
D)  VENDOR is not allowed.

Question 12

The relationship between the instances of two entity types is called a binary relationship.

Accepted Answer

A) True 
 B)False

Question 13

In the following diagram, which answer is true?

Accepted Answer

A)  Each employee can supervise one employee, no employees or many employees. 
B)  Each employee can manage many departments. 
C)  Each employee works in more than one department. 
D)  Each employee was fired. 
A)  Each employee can supervise one employee, no employees or many employees. 
B)  Each employee can manage many departments. 
C)  Each employee works in more than one department. 
D)  Each employee was fired.

Question 14

Participation in a relationship may be optional or mandatory.

Accepted Answer

A) True 
 B)False

Question 15

A single occurrence of an entity is called an entity instance.

Accepted Answer

A) True 
 B)False

Question 16

A business rule should be internally consistent.

Accepted Answer

A) True 
 B)False

Question 17

The intent of a business rule is to break down business structure.

Accepted Answer

A) True 
 B)False

Question 18

A good data definition will describe all of the characteristics of a data object EXCEPT:

Accepted Answer

A)  subtleties. 
B)  examples. 
C)  who determines the value of the data. 
D)  who can delete the data. 
A)  subtleties. 
B)  examples. 
C)  who determines the value of the data. 
D)  who can delete the data.

Question 19

An attribute that must have a value for every entity (or relationship) instance is a(n):

Accepted Answer

A)  composite attribute. 
B)  required attribute. 
C)  optional attribute. 
D)  multivalued attribute. 
A)  composite attribute. 
B)  required attribute. 
C)  optional attribute. 
D)  multivalued attribute.

Question 20

A simultaneous relationship among the instances of three entity types is called a ________ relationship.

Accepted Answer

A)  ternary 
B)  tertiary 
C)  primary 
D)  binary 
A)  ternary 
B)  tertiary 
C)  primary 
D)  binary

In an E-R diagram, there are/is ________ business rule(s) for every relationship.

The total quiz points for a student for an entire semester is a(n) ________ attribute.

In the figure below, Name would be an ideal identifier.

The number of entity types that participate in a Unary relationship is:

The relationship among the instances of three entity types is called a unary relationship.

In the following diagram, which of the answers below is true?

How is a strong entity different from a weak entity?

The name used for an entity type should never be the same in other E-R diagrams on which the entity appears.

In an E-R diagram, strong entities are represented by double-walled rectangles.

The E-R model is used to construct a conceptual model.

In the figure shown below, which of the following business rules would apply?

The relationship between the instances of two entity types is called a binary relationship.

In the following diagram, which answer is true?

Participation in a relationship may be optional or mandatory.

A single occurrence of an entity is called an entity instance.

A business rule should be internally consistent.

The intent of a business rule is to break down business structure.

A good data definition will describe all of the characteristics of a data object EXCEPT:

An attribute that must have a value for every entity (or relationship) instance is a(n):

A simultaneous relationship among the instances of three entity types is called a ________ relationship.

The Database Environment and Development Process

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 2: Modeling Data in the Organization

In an E-R diagram, there are/is ________ business rule(s) for every relationship.

The total quiz points for a student for an entire semester is a(n) ________ attribute.

In the figure below, Name would be an ideal identifier.

The number of entity types that participate in a Unary relationship is:

The relationship among the instances of three entity types is called a unary relationship.

In the following diagram, which of the answers below is true?

How is a strong entity different from a weak entity?

The name used for an entity type should never be the same in other E-R diagrams on which the entity appears.

In an E-R diagram, strong entities are represented by double-walled rectangles.

The E-R model is used to construct a conceptual model.

In the figure shown below, which of the following business rules would apply?

The relationship between the instances of two entity types is called a binary relationship.

In the following diagram, which answer is true?

Participation in a relationship may be optional or mandatory.

A single occurrence of an entity is called an entity instance.

A business rule should be internally consistent.

The intent of a business rule is to break down business structure.

A good data definition will describe all of the characteristics of a data object EXCEPT:

An attribute that must have a value for every entity (or relationship) instance is a(n):

A simultaneous relationship among the instances of three entity types is called a ________ relationship.

The Database Environment and Development Process

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters