Question 1

The intent of a business rule is to break down business structure.

Accepted Answer

A) True 
 B)False

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

Question 3

A good data definition is always accompanied by diagrams,such as the entity-relationship diagram.

Accepted Answer

A) True 
 B)False

Question 4

A cardinality constraint tells what kinds of properties are associated with an entity.

Accepted Answer

A) True 
 B)False

Question 5

A business rule:

Accepted Answer

A)  defines or constrains some aspect of the business. 
B)  asserts business structure. 
C)  controls or influences the behavior of the business. 
D)  all of the above. 
A)  defines or constrains some aspect of the business. 
B)  asserts business structure. 
C)  controls or influences the behavior of the business. 
D)  all of the above.

Question 6

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 7

When systems are automatically generated and maintained,quality is diminished.

Accepted Answer

A) True 
 B)False

Question 8

A(n)________ is an attribute that uniquely identifies individual instances of an entity type.

Accepted Answer

The answer of A(n)________ is an attribute that uniquely identifies...

Question 9

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

Accepted Answer

A)  associative 
B)  simple 
C)  composite 
D)  complex 
A)  associative 
B)  simple 
C)  composite 
D)  complex

Question 10

A relationship instance is an association between entity instances where each relationship instance includes exactly one entity from each participating entity type.

Accepted Answer

A) True 
 B)False

Question 11

A simultaneous relationship among the instances of three entity types is called a(n)________ relationship.

Accepted Answer

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

Question 12

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 can not participate in a relationship with another entity instance. 
D)  none of the above. 
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 can not participate in a relationship with another entity instance. 
D)  none of the above.

Question 13

Which of the following is an entity type on which a strong entity depends?

Accepted Answer

A)  Owner 
B)  Member 
C)  Attribute 
D)  None of the above 
A)  Owner 
B)  Member 
C)  Attribute 
D)  None of the above

Question 14

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 15

An entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship is called a(n)________.

Accepted Answer

The answer of An entity type that associates the instances...

Question 16

An entity type name should always be a singular noun.

Accepted Answer

A) True 
 B)False

Question 17

Some examples of attributes are: eye_color,weight,student_id,student.

Accepted Answer

A) True 
 B)False

Question 18

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 19

Which of the following conditions should exist if an associative entity is to be created?

Accepted Answer

A)  All the relationships for the participating entities are many-to-many. 
B)  The new associative entity has independent meaning. 
C)  The new associative entity participates in independent relationships. 
D)  All of the above. 
A)  All the relationships for the participating entities are many-to-many. 
B)  The new associative entity has independent meaning. 
C)  The new associative entity participates in independent relationships. 
D)  All of the above.

Question 20

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.

The intent of a business rule is to break down business structure.

In the figure below,which attribute is derived?

A good data definition is always accompanied by diagrams,such as the entity-relationship diagram.

A cardinality constraint tells what kinds of properties are associated with an entity.

A business rule:

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.

When systems are automatically generated and maintained,quality is diminished.

A(n)________ is an attribute that uniquely identifies individual instances of an entity type.

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

A relationship instance is an association between entity instances where each relationship instance includes exactly one entity from each participating entity type.

A simultaneous relationship among the instances of three entity types is called a(n)________ relationship.

A mutually exclusive relationship is one in which:

Which of the following is an entity type on which a strong entity depends?

Customers,cars,and parts are examples of:

An entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship is called a(n)________.

An entity type name should always be a singular noun.

Some examples of attributes are: eye_color,weight,student_id,student.

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

Which of the following conditions should exist if an associative entity is to be created?

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

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

The intent of a business rule is to break down business structure.

In the figure below,which attribute is derived?

A good data definition is always accompanied by diagrams,such as the entity-relationship diagram.

A cardinality constraint tells what kinds of properties are associated with an entity.

A business rule:

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.

When systems are automatically generated and maintained,quality is diminished.

A(n)________ is an attribute that uniquely identifies individual instances of an entity type.

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

A relationship instance is an association between entity instances where each relationship instance includes exactly one entity from each participating entity type.

A simultaneous relationship among the instances of three entity types is called a(n)________ relationship.

A mutually exclusive relationship is one in which:

Which of the following is an entity type on which a strong entity depends?

Customers,cars,and parts are examples of:

An entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship is called a(n)________.

An entity type name should always be a singular noun.

Some examples of attributes are: eye_color,weight,student_id,student.

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

Which of the following conditions should exist if an associative entity is to be created?

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

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