Question 1

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 C

Question 2

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

Accepted Answer

A) True 
 B)False  False

Question 3

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

The name used for an entity type should never be the same in other E-R diagrams on which the entity appears.

Accepted Answer

A) True 
 B)False

Question 6

An attribute whose value can be calculated from a related attribute is called a(n)________ attribute.

Accepted Answer

The answer of An attribute whose value can be calculated...

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

An attribute of an entity that must have a value for each entity instance is a(n):

Accepted Answer

A)  optional attribute. 
B)  composite attribute. 
C)  required attribute. 
D)  fuzzy attribute. 
A)  optional attribute. 
B)  composite attribute. 
C)  required attribute. 
D)  fuzzy attribute.

Question 9

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

Accepted Answer

A derived attribute is an attribute whos

Question 10

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 11

An affirmative entity is also called a relationship entity.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is NOT a good characteristic of a data name?

Accepted Answer

A)  Relates to business characteristics 
B)  Readable 
C)  Repeatable 
D)  Relates to a technical characteristic of the system 
A)  Relates to business characteristics 
B)  Readable 
C)  Repeatable 
D)  Relates to a technical characteristic of the system

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

While business rules are not redundant,a business rule can refer to another business rule.

Accepted Answer

A) True 
 B)False

Question 16

An attribute that must have a value for every entity (or relationship)instance is a(n):

Accepted Answer

A)  composite attribute. 
B)  required attribute. 
C)  optional attribute. 
D)  multivalued attribute. 
A)  composite attribute. 
B)  required attribute. 
C)  optional attribute. 
D)  multivalued attribute.

Question 17

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 18

An attribute that can be broken down into component parts is called a(n)________ attribute.

Accepted Answer

The answer of An attribute that can be broken down...

Question 19

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)  None of the above. 
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)  None of the above.

Question 20

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

Accepted Answer

A) True 
 B)False

In the figure below,which attribute is multivalued?

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

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

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

The name used for an entity type should never be the same in other E-R diagrams on which the entity appears.

An attribute whose value can be calculated from a related attribute is called a(n)________ attribute.

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

An attribute of an entity that must have a value for each entity instance is a(n):

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

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

An affirmative entity is also called a relationship entity.

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

Which of the following is NOT a good characteristic of a data name?

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

While business rules are not redundant,a business rule can refer to another business rule.

An attribute that must have a value for every entity (or relationship)instance is a(n):

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

An attribute that can be broken down into component parts is called a(n)________ attribute.

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

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

The Database Environment and Development Process

The Enhanced E-R Model and Business Rules

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

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 2: Modeling Data in the Organization

In the figure below,which attribute is multivalued?

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

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

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

The name used for an entity type should never be the same in other E-R diagrams on which the entity appears.

An attribute whose value can be calculated from a related attribute is called a(n)________ attribute.

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

An attribute of an entity that must have a value for each entity instance is a(n):

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

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

An affirmative entity is also called a relationship entity.

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

Which of the following is NOT a good characteristic of a data name?

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

While business rules are not redundant,a business rule can refer to another business rule.

An attribute that must have a value for every entity (or relationship)instance is a(n):

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

An attribute that can be broken down into component parts is called a(n)________ attribute.

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

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

The Database Environment and Development Process

The Enhanced E-R Model and Business Rules

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

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters