Question 1

A ________ defines or constrains some aspect of the business.

Accepted Answer

A)  business constraint 
B)  business structure 
C)  business control 
D)  business rule 
A)  business constraint 
B)  business structure 
C)  business control 
D)  business rule

Question 2

Data, rather than processes, are the most complex aspects of many modern information systems.

Accepted Answer

A) True 
 B)False

Question 3

Relationships represent action being taken using a verb phrase.

Accepted Answer

A) True 
 B)False

Question 4

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 5

Data names do not have to be unique.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is an entity that exists independently of other entity types?

Accepted Answer

A)  Codependent 
B)  Weak 
C)  Strong 
D)  Variant 
A)  Codependent 
B)  Weak 
C)  Strong 
D)  Variant

Question 7

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

Question 8

On what premises are business rules based?

Accepted Answer

A business rules approach is based on th

Question 9

What is the difference between a simple attribute and a composite attribute?

Accepted Answer

A simple attribute cannot be broken down

Question 10

A mutually exclusive relationship is one in which:

Accepted Answer

A)  an entity instance can participate in many different relationships. 
B)  an entity instance can participate in only one of several alternative relationships. 
C)  an entity instance cannot participate in a relationship with another entity instance. 
D)  an entity instance bridges other XML documents. 
A)  an entity instance can participate in many different relationships. 
B)  an entity instance can participate in only one of several alternative relationships. 
C)  an entity instance cannot participate in a relationship with another entity instance. 
D)  an entity instance bridges other XML documents.

Question 11

A value that indicates the date or time of a data value is called a:

Accepted Answer

A)  value stamp. 
B)  time stamp. 
C)  checkpoint. 
D)  check counter. 
A)  value stamp. 
B)  time stamp. 
C)  checkpoint. 
D)  check counter.

Question 12

An entity type whose existence depends on another entity type is called a ________ entity.

Accepted Answer

A)  strong 
B)  weak 
C)  codependent 
D)  variant 
A)  strong 
B)  weak 
C)  codependent 
D)  variant

Question 13

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 14

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 15

A multivalued attribute may take on more than one value for a particular entity instance.

Accepted Answer

A) True 
 B)False

Question 16

What is an associative entity? What four conditions should exist in order to convert a relationship to an associative entity?

Accepted Answer

An associative entity is an entity type

Question 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

What are some of the guidelines for good data names of objects in general?

Accepted Answer

Data names always should:
1. Relate to t

Question 20

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

A ________ defines or constrains some aspect of the business.

Data, rather than processes, are the most complex aspects of many modern information systems.

Relationships represent action being taken using a verb phrase.

In the following diagram, which is true?

Data names do not have to be unique.

Which of the following is an entity that exists independently of other entity types?

In the figure below, which attribute is derived?

On what premises are business rules based?

What is the difference between a simple attribute and a composite attribute?

A mutually exclusive relationship is one in which:

A value that indicates the date or time of a data value is called a:

An entity type whose existence depends on another entity type is called a ________ entity.

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

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

A multivalued attribute may take on more than one value for a particular entity instance.

What is an associative entity? What four conditions should exist in order to convert a relationship to an associative entity?

In the figure below, which attribute is multivalued?

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

What are some of the guidelines for good data names of objects in general?

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.

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 ________ defines or constrains some aspect of the business.

Data, rather than processes, are the most complex aspects of many modern information systems.

Relationships represent action being taken using a verb phrase.

In the following diagram, which is true?

Data names do not have to be unique.

Which of the following is an entity that exists independently of other entity types?

In the figure below, which attribute is derived?

On what premises are business rules based?

What is the difference between a simple attribute and a composite attribute?

A mutually exclusive relationship is one in which:

A value that indicates the date or time of a data value is called a:

An entity type whose existence depends on another entity type is called a ________ entity.

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

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

A multivalued attribute may take on more than one value for a particular entity instance.

What is an associative entity? What four conditions should exist in order to convert a relationship to an associative entity?

In the figure below, which attribute is multivalued?

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

What are some of the guidelines for good data names of objects in general?

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.

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