Question 1

A ternary relationship is equivalent to three binary relationships.

Accepted Answer

A) True 
 B)False

Question 2

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 3

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

Accepted Answer

A) True 
 B)False

Question 4

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 5

An entity type name should always be a singular noun.

Accepted Answer

A) True 
 B)False

Question 6

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 7

The maximum criminality of a relationship is the maximum number of instances of entity B that may be associated with each instance of entity A.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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.

Question 10

An entity is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data.

Accepted Answer

A) True 
 B)False

Question 11

Data modeling may be the most important part of the systems development process because:

Accepted Answer

A)  data characteristics are important in the design of programs and other systems components. 
B)  the data in a system are generally less complex than processes and play a central role in development. 
C)  data are less stable than processes. 
D)  it is the easiest. 
A)  data characteristics are important in the design of programs and other systems components. 
B)  the data in a system are generally less complex than processes and play a central role in development. 
C)  data are less stable than processes. 
D)  it is the easiest.

Question 12

Which of the following is NOT a characteristic of a good business rule?

Accepted Answer

A)  Declarative 
B)  Atomic 
C)  Inconsistent 
D)  Expressible 
A)  Declarative 
B)  Atomic 
C)  Inconsistent 
D)  Expressible

Question 13

Most systems developers believe that data modeling is the least important part of the systems development process.

Accepted Answer

A) True 
 B)False

Question 14

A person's name, birthday, and social security number are all examples of:

Accepted Answer

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

Question 15

A simple attribute can be broken down into smaller pieces.

Accepted Answer

A) True 
 B)False

Question 16

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 17

A time stamp is a time value that is associated with a data value.

Accepted Answer

A) True 
 B)False

Question 18

Business rules are formulated from a collection of business ramblings.

Accepted Answer

A) True 
 B)False

Question 19

Data modeling is about documenting rules and policies of an organization that govern data.

Accepted Answer

A) True 
 B)False

Question 20

An entity that associates the instances of one or more entity types and contains attributes specific 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.

A ternary relationship is equivalent to three binary relationships.

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

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

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

An entity type name should always be a singular noun.

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

The maximum criminality of a relationship is the maximum number of instances of entity B that may be associated with each instance of entity A.

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

Customers, cars, and parts are examples of:

An entity is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data.

Data modeling may be the most important part of the systems development process because:

Which of the following is NOT a characteristic of a good business rule?

Most systems developers believe that data modeling is the least important part of the systems development process.

A person's name, birthday, and social security number are all examples of:

A simple attribute can be broken down into smaller pieces.

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

A time stamp is a time value that is associated with a data value.

Business rules are formulated from a collection of business ramblings.

Data modeling is about documenting rules and policies of an organization that govern data.

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

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

A ternary relationship is equivalent to three binary relationships.

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

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

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

An entity type name should always be a singular noun.

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

The maximum criminality of a relationship is the maximum number of instances of entity B that may be associated with each instance of entity A.

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

Customers, cars, and parts are examples of:

An entity is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data.

Data modeling may be the most important part of the systems development process because:

Which of the following is NOT a characteristic of a good business rule?

Most systems developers believe that data modeling is the least important part of the systems development process.

A person's name, birthday, and social security number are all examples of:

A simple attribute can be broken down into smaller pieces.

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

A time stamp is a time value that is associated with a data value.

Business rules are formulated from a collection of business ramblings.

Data modeling is about documenting rules and policies of an organization that govern data.

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

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