Question 1

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. A

Question 2

In the figure below, which attribute is derived?

Accepted Answer

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

Question 3

A property or characteristic of an entity type that is of interest to the organization is called a(n):

Accepted Answer

A)  attribute. 
B)  coexisting entity. 
C)  relationship. 
D)  cross-function. 
A)  attribute. 
B)  coexisting entity. 
C)  relationship. 
D)  cross-function. A

Question 4

Enforcement of business rules can be automated through the use of software that can interpret the rules and enforce them.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

When choosing an identifier, choose one that will not change its value often.

Accepted Answer

A) True 
 B)False

Question 7

Business rules are formulated from a collection of business ramblings.

Accepted Answer

A) True 
 B)False

Question 8

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 9

For the relationship represented in the figure below, which of the following is true?

Accepted Answer

A)  An employee can work in more than one department but does not have to work for any department. 
B)  A department must have at least one employee. 
C)  A department can have more than one employee. 
D)  An employee has to work for more than one department. 
A)  An employee can work in more than one department but does not have to work for any department. 
B)  A department must have at least one employee. 
C)  A department can have more than one employee. 
D)  An employee has to work for more than one department.

Question 10

In the figure below, the name of the relationship follows the guidelines for naming a relationship.

Accepted Answer

A) True 
 B)False

Question 11

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 12

A relationship between the instances of a single entity type is called a ________ relationship.

Accepted Answer

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

Question 13

Which of the following criteria should be considered when selecting an identifier?

Accepted Answer

A)  Choose an identifier that is not stable. 
B)  Choose a null identifier. 
C)  Choose an identifier that doesn't have large composite attributes. 
D)  Choose the most complex identifier possible. 
A)  Choose an identifier that is not stable. 
B)  Choose a null identifier. 
C)  Choose an identifier that doesn't have large composite attributes. 
D)  Choose the most complex identifier possible.

Question 14

A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a ________ relationship.

Accepted Answer

A)  one-to-one 
B)  many-to-many 
C)  one-to-many 
D)  strong 
A)  one-to-one 
B)  many-to-many 
C)  one-to-many 
D)  strong

Question 15

In the following diagram, what type of relationship is depicted?

Accepted Answer

A)  Unary 
B)  Binary 
C)  Ternary 
D)  Quad 
A)  Unary 
B)  Binary 
C)  Ternary 
D)  Quad

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

An attribute that can be calculated from related attribute values is called a ________ attribute.

Accepted Answer

A)  simple 
B)  composite 
C)  multivalued 
D)  derived 
A)  simple 
B)  composite 
C)  multivalued 
D)  derived

Question 18

The purpose of data modeling is to document business rules about processes.

Accepted Answer

A) True 
 B)False

Question 19

Data names should always relate to business characteristics.

Accepted Answer

A) True 
 B)False

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

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

In the figure below, which attribute is derived?

A property or characteristic of an entity type that is of interest to the organization is called a(n):

Enforcement of business rules can be automated through the use of software that can interpret the rules and enforce them.

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

When choosing an identifier, choose one that will not change its value often.

Business rules are formulated from a collection of business ramblings.

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

For the relationship represented in the figure below, which of the following is true?

In the figure below, the name of the relationship follows the guidelines for naming a 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.

A relationship between the instances of a single entity type is called a ________ relationship.

Which of the following criteria should be considered when selecting an identifier?

A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a ________ relationship.

In the following diagram, what type of relationship is depicted?

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

An attribute that can be calculated from related attribute values is called a ________ attribute.

The purpose of data modeling is to document business rules about processes.

Data names should always relate to business characteristics.

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

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

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

In the figure below, which attribute is derived?

A property or characteristic of an entity type that is of interest to the organization is called a(n):

Enforcement of business rules can be automated through the use of software that can interpret the rules and enforce them.

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

When choosing an identifier, choose one that will not change its value often.

Business rules are formulated from a collection of business ramblings.

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

For the relationship represented in the figure below, which of the following is true?

In the figure below, the name of the relationship follows the guidelines for naming a 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.

A relationship between the instances of a single entity type is called a ________ relationship.

Which of the following criteria should be considered when selecting an identifier?

A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a ________ relationship.

In the following diagram, what type of relationship is depicted?

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

An attribute that can be calculated from related attribute values is called a ________ attribute.

The purpose of data modeling is to document business rules about processes.

Data names should always relate to business characteristics.

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

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