Question 1

A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship.

Accepted Answer

A)  optional 
B)  unidirectional 
C)  mandatory link 
D)  mandatory one 
A)  optional 
B)  unidirectional 
C)  mandatory link 
D)  mandatory one

Question 2

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

Accepted Answer

A)  number. 
B)  identifying characteristic. 
C)  degree. 
D)  counter. 
A)  number. 
B)  identifying characteristic. 
C)  degree. 
D)  counter.

Question 3

An entity that associates the instances of one or more entity types and contains attributes peculiar to the relationships is called a(n):

Accepted Answer

A)  associative entity. 
B)  build entity. 
C)  gateway entity. 
D)  smush entity. 
A)  associative entity. 
B)  build entity. 
C)  gateway entity. 
D)  smush entity.

Question 4

What is a derived attribute, and how is it different from a stored attribute?

Accepted Answer

A derived attribute is an attribute whos

Question 5

For the relationship represented in the figure below, a department can have more than one employee.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

A relationship instance is an association between entity instances where each relationship instance includes exactly one entity from each participating entity type.

Accepted Answer

A) True 
 B)False

Question 8

It is desirable that no two attributes across all entity types have the same name.

Accepted Answer

A) True 
 B)False

Question 9

How is a strong entity different from a weak entity?

Accepted Answer

A strong entity type exists independentl

Question 10

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

Question 11

It is not permissible to associate attributes with relationships.

Accepted Answer

A) True 
 B)False

Question 12

One reason to use an associative entity is if the associative entity has one or more attributes in addition to the identifier.

Accepted Answer

A) True 
 B)False

Question 13

A simple attribute can be broken down into smaller pieces.

Accepted Answer

A) True 
 B)False

Question 14

In the figure below, which attribute is multivalued?

Accepted Answer

A)  Years_Employed 
B)  Employee_ID 
C)  Skill 
D)  Address 
A)  Years_Employed 
B)  Employee_ID 
C)  Skill 
D)  Address

Question 15

The relationship between a weak entity type and its owner is an identifying relationship.

Accepted Answer

A) True 
 B)False

Question 16

A customer can order many items, and an item can be ordered by many customers is an example of a recursive relationship.

Accepted Answer

A) True 
 B)False

Question 17

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 18

A business rule is a statement of how a policy is enforced or conducted.

Accepted Answer

A) True 
 B)False

Question 19

In the following diagram, which is true?

Accepted Answer

A)  It depicts a ternary relationship. 
B)  It depicts a many-to-many relationship. 
C)  Item represents a column. 
D)  BOM_STRUCTURE represents a row. 
A)  It depicts a ternary relationship. 
B)  It depicts a many-to-many relationship. 
C)  Item represents a column. 
D)  BOM_STRUCTURE represents a row.

Question 20

Customers, cars, and parts are examples of:

Accepted Answer

A)  entities. 
B)  attributes. 
C)  cardinals. 
D)  relationships. 
A)  entities. 
B)  attributes. 
C)  cardinals. 
D)  relationships.

A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship.

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

An entity that associates the instances of one or more entity types and contains attributes peculiar to the relationships is called a(n):

What is a derived attribute, and how is it different from a stored attribute?

For the relationship represented in the figure below, a department can have more than one employee.

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

A relationship instance is an association between entity instances where each relationship instance includes exactly one entity from each participating entity type.

It is desirable that no two attributes across all entity types have the same name.

How is a strong entity different from a weak entity?

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

It is not permissible to associate attributes with relationships.

One reason to use an associative entity is if the associative entity has one or more attributes in addition to the identifier.

A simple attribute can be broken down into smaller pieces.

In the figure below, which attribute is multivalued?

The relationship between a weak entity type and its owner is an identifying relationship.

A customer can order many items, and an item can be ordered by many customers is an example of a recursive relationship.

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

A business rule is a statement of how a policy is enforced or conducted.

In the following diagram, which is true?

Customers, cars, and parts are examples of:

The Database Environment and Development Process

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 2: Modeling Data in the Organization

A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship.

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

An entity that associates the instances of one or more entity types and contains attributes peculiar to the relationships is called a(n):

What is a derived attribute, and how is it different from a stored attribute?

For the relationship represented in the figure below, a department can have more than one employee.

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

A relationship instance is an association between entity instances where each relationship instance includes exactly one entity from each participating entity type.

It is desirable that no two attributes across all entity types have the same name.

How is a strong entity different from a weak entity?

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

It is not permissible to associate attributes with relationships.

One reason to use an associative entity is if the associative entity has one or more attributes in addition to the identifier.

A simple attribute can be broken down into smaller pieces.

In the figure below, which attribute is multivalued?

The relationship between a weak entity type and its owner is an identifying relationship.

A customer can order many items, and an item can be ordered by many customers is an example of a recursive relationship.

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

A business rule is a statement of how a policy is enforced or conducted.

In the following diagram, which is true?

Customers, cars, and parts are examples of:

The Database Environment and Development Process

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters