Question 1

Understanding the steps involved in transforming EER diagrams into relations is important because:

Accepted Answer

A)  one must be able to check the output of a CASE tool. 
B)  there are rarely legitimate alternatives from which to choose. 
C)  CASE tools can model any situation. 
D)  CASE tools model hypothetical business problems. 
A)  one must be able to check the output of a CASE tool. 
B)  there are rarely legitimate alternatives from which to choose. 
C)  CASE tools can model any situation. 
D)  CASE tools model hypothetical business problems.

Question 2

A domain definition consists of all of the following components EXCEPT:

Accepted Answer

A)  domain name. 
B)  data type. 
C)  integrity constraints. 
D)  size. 
A)  domain name. 
B)  data type. 
C)  integrity constraints. 
D)  size.

Question 3

When all multivalued attributes have been removed from a relation, it is said to be in:

Accepted Answer

A)  first normal form. 
B)  second normal form. 
C)  Boyce-Codd normal form. 
D)  third normal form. 
A)  first normal form. 
B)  second normal form. 
C)  Boyce-Codd normal form. 
D)  third normal form.

Question 4

A two-dimensional table of data sometimes is called a:

Accepted Answer

A)  group. 
B)  set. 
C)  declaration. 
D)  relation. 
A)  group. 
B)  set. 
C)  declaration. 
D)  relation.

Question 5

If an identifier is not assigned, the default primary key for an associative relation consists of the two primary key attributes from the other two relations.

Accepted Answer

A) True 
 B)False

Question 6

How do you convert weak entities to relations?

Accepted Answer

A weak entity becomes a relation. Howeve

Question 7

In the relational data model, associations between tables are defined through the use of primary keys.

Accepted Answer

A) True 
 B)False

Question 8

Discuss the types of integrity constraints.

Accepted Answer

The three major types of integrity const

Question 9

In the figure below, each employee has exactly one manager.

Accepted Answer

A) True 
 B)False

Question 10

When transforming a one-to-one relationship, a new relation is always created.

Accepted Answer

A) True 
 B)False

Question 11

Explain how subtype/supertype relationships are converted to relations.

Accepted Answer

When we have a supertype/subtype relatio

Question 12

A candidate key must satisfy all of the following conditions EXCEPT:

Accepted Answer

A)  the key must uniquely identify the row. 
B)  the key must indicate the row's position in the table. 
C)  the key must be nonredundant. 
D)  each nonkey attribute is functionally dependent upon it. 
A)  the key must uniquely identify the row. 
B)  the key must indicate the row's position in the table. 
C)  the key must be nonredundant. 
D)  each nonkey attribute is functionally dependent upon it.

Question 13

In the SQL language, the ________ statement is used to make table definitions.

Accepted Answer

A)  create session 
B)  create table 
C)  create index 
D)  select 
A)  create session 
B)  create table 
C)  create index 
D)  select

Question 14

When transforming a unary many-to-many relationship to relations, a recursive foreign key is used.

Accepted Answer

A) True 
 B)False

Question 15

The ________ states that no primary key attribute may be null.

Accepted Answer

A)  referential integrity constraint 
B)  entity integrity rule 
C)  partial specialization rule 
D)  range domain rule 
A)  referential integrity constraint 
B)  entity integrity rule 
C)  partial specialization rule 
D)  range domain rule

Question 16

An attribute (or attributes) that uniquely identifies each row in a relation is called a:

Accepted Answer

A)  column. 
B)  foreign field. 
C)  primary key. 
D)  duplicate key. 
A)  column. 
B)  foreign field. 
C)  primary key. 
D)  duplicate key.

Question 17

A synonym is an attribute that may have more than one meaning.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following are properties of relations?

Accepted Answer

A)  Each attribute has the same name. 
B)  No two rows in a relation are identical. 
C)  There are multivalued attributes in a relation. 
D)  All columns are numeric. 
A)  Each attribute has the same name. 
B)  No two rows in a relation are identical. 
C)  There are multivalued attributes in a relation. 
D)  All columns are numeric.

Question 19

Discuss how to map a unary many-to-many relationship.

Accepted Answer

Two relations are created. One represent

Question 20

In the figure below, what type of relationship do the relations depict?

Accepted Answer

A)  Identifying entity/weak entity 
B)  One-to-many 
C)  Ternary 
D)  Many-to-many 
A)  Identifying entity/weak entity 
B)  One-to-many 
C)  Ternary 
D)  Many-to-many

Understanding the steps involved in transforming EER diagrams into relations is important because:

A domain definition consists of all of the following components EXCEPT:

When all multivalued attributes have been removed from a relation, it is said to be in:

A two-dimensional table of data sometimes is called a:

If an identifier is not assigned, the default primary key for an associative relation consists of the two primary key attributes from the other two relations.

How do you convert weak entities to relations?

In the relational data model, associations between tables are defined through the use of primary keys.

Discuss the types of integrity constraints.

In the figure below, each employee has exactly one manager.

When transforming a one-to-one relationship, a new relation is always created.

Explain how subtype/supertype relationships are converted to relations.

A candidate key must satisfy all of the following conditions EXCEPT:

In the SQL language, the ________ statement is used to make table definitions.

When transforming a unary many-to-many relationship to relations, a recursive foreign key is used.

The ________ states that no primary key attribute may be null.

An attribute (or attributes) that uniquely identifies each row in a relation is called a:

A synonym is an attribute that may have more than one meaning.

Which of the following are properties of relations?

Discuss how to map a unary many-to-many relationship.

In the figure below, what type of relationship do the relations depict?

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R 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 4: Logical Database Design and the Relational Model

Understanding the steps involved in transforming EER diagrams into relations is important because:

A domain definition consists of all of the following components EXCEPT:

When all multivalued attributes have been removed from a relation, it is said to be in:

A two-dimensional table of data sometimes is called a:

If an identifier is not assigned, the default primary key for an associative relation consists of the two primary key attributes from the other two relations.

How do you convert weak entities to relations?

In the relational data model, associations between tables are defined through the use of primary keys.

Discuss the types of integrity constraints.

In the figure below, each employee has exactly one manager.

When transforming a one-to-one relationship, a new relation is always created.

Explain how subtype/supertype relationships are converted to relations.

A candidate key must satisfy all of the following conditions EXCEPT:

In the SQL language, the ________ statement is used to make table definitions.

When transforming a unary many-to-many relationship to relations, a recursive foreign key is used.

The ________ states that no primary key attribute may be null.

An attribute (or attributes) that uniquely identifies each row in a relation is called a:

A synonym is an attribute that may have more than one meaning.

Which of the following are properties of relations?

Discuss how to map a unary many-to-many relationship.

In the figure below, what type of relationship do the relations depict?

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R 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