Question 1

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 2

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 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A simple attribute cannot be broken down

Question 6

An attribute whose values can be calculated from related attribute values is called a derived attribute.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

An attribute that uniquely identifies an entity and consists of a composite attribute is called a(n):

Accepted Answer

A)  composite attribute. 
B)  composite identifier. 
C)  identifying attribute. 
D)  relationship identifier. 
A)  composite attribute. 
B)  composite identifier. 
C)  identifying attribute. 
D)  relationship identifier.

Question 9

A business rule should be internally consistent.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

An example of a term would be the following sentence: "A student registers for a course."

Accepted Answer

A) True 
 B)False

Question 13

The following figure shows an example of:

Accepted Answer

A)  a one-to-many relationship. 
B)  a strong entity and its associated weak entity. 
C)  a co-dependent relationship. 
D)  a double-walled relationship. 
A)  a one-to-many relationship. 
B)  a strong entity and its associated weak entity. 
C)  a co-dependent relationship. 
D)  a double-walled relationship.

Question 14

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 15

The logical representation of an organization's data is called a(n):

Accepted Answer

A)  database model. 
B)  entity-relationship model. 
C)  relationship systems design. 
D)  database entity diagram. 
A)  database model. 
B)  entity-relationship model. 
C)  relationship systems design. 
D)  database entity diagram.

Question 16

A(n) ________ is the relationship between a weak entity type and its owner.

Accepted Answer

A)  member chain 
B)  identifying relationship 
C)  jump path 
D)  chain link 
A)  member chain 
B)  identifying relationship 
C)  jump path 
D)  chain link

Question 17

On what premises are business rules based?

Accepted Answer

A business rules approach is based on th

Question 18

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 19

An entity type on which a strong entity is dependent is called a covariant entity.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

In the following diagram, which answer is true?

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

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

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

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

An attribute whose values can be calculated from related attribute values is called a derived attribute.

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

An attribute that uniquely identifies an entity and consists of a composite attribute is called a(n):

A business rule should be internally consistent.

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

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

An example of a term would be the following sentence: "A student registers for a course."

The following figure shows an example of:

A ________ defines or constrains some aspect of the business.

The logical representation of an organization's data is called a(n):

A(n) ________ is the relationship between a weak entity type and its owner.

On what premises are business rules based?

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

An entity type on which a strong entity is dependent is called a covariant entity.

The relationship among the instances of three entity types is called a unary 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

In the following diagram, which answer is true?

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

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

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

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

An attribute whose values can be calculated from related attribute values is called a derived attribute.

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

An attribute that uniquely identifies an entity and consists of a composite attribute is called a(n):

A business rule should be internally consistent.

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

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

An example of a term would be the following sentence: "A student registers for a course."

The following figure shows an example of:

A ________ defines or constrains some aspect of the business.

The logical representation of an organization's data is called a(n):

A(n) ________ is the relationship between a weak entity type and its owner.

On what premises are business rules based?

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

An entity type on which a strong entity is dependent is called a covariant entity.

The relationship among the instances of three entity types is called a unary 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