Question 1

In data normalization terminology, an attribute is functionally dependent on its determinant.

Accepted Answer

A) True 
 B)False

Question 2

Converting a ternary relationship into a relational database from an E-R diagram ____.

Accepted Answer

A)  can be done by placing the unique identifier of one of the tables into the others 
B)  can be done by creating a single table that combines the attributes of the three entities 
C)  requires the creation of an additional table beyond the three that represent the three entities in the relationship 
D)  a & b above 
E)  a & c above 
A)  can be done by placing the unique identifier of one of the tables into the others 
B)  can be done by creating a single table that combines the attributes of the three entities 
C)  requires the creation of an additional table beyond the three that represent the three entities in the relationship 
D)  a & b above 
E)  a & c above

Question 3

Converting a one-to-one binary relationship into a relational database from an E-R diagram ____.

Accepted Answer

A)  can be done by placing the unique identifier of one of the tables into the other 
B)  can be done by creating a single table that combines the attributes of the two entities 
C)  requires the creation of an additional table beyond the two that represent the two entities in the relationship 
D)  a & b above 
E)  a & c above 
A)  can be done by placing the unique identifier of one of the tables into the other 
B)  can be done by creating a single table that combines the attributes of the two entities 
C)  requires the creation of an additional table beyond the two that represent the two entities in the relationship 
D)  a & b above 
E)  a & c above

Question 4

Converting from first to second normal form involves subdividing tables to remove partial functional dependencies.

Accepted Answer

A) True 
 B)False

Question 5

Multivalued attributes are not permitted in unnormalized data.

Accepted Answer

A) True 
 B)False

Question 6

Placing the unique identifier of one database table in another existing or new table in the database ____.

Accepted Answer

A)  creates a foreign key 
B)  may indicate the creation of a one-to-many binary relationship 
C)  may indicate the creation of a many-to-many binary relationship 
D)  All of the above. 
E)  None of the above. 
A)  creates a foreign key 
B)  may indicate the creation of a one-to-many binary relationship 
C)  may indicate the creation of a many-to-many binary relationship 
D)  All of the above. 
E)  None of the above.

Question 7

Data in ____ cannot have partial functional dependencies but can have transitive dependencies.

Accepted Answer

A)  first normal form 
B)  second normal form 
C)  third normal form 
D)  All of the above. 
E)  None of the above. 
A)  first normal form 
B)  second normal form 
C)  third normal form 
D)  All of the above. 
E)  None of the above.

Question 8

Data in ____ has only a single attribute value in every attribute position.

Accepted Answer

A)  first normal form 
B)  second normal form 
C)  third normal form 
D)  All of the above. 
E)  None of the above. 
A)  first normal form 
B)  second normal form 
C)  third normal form 
D)  All of the above. 
E)  None of the above.

Question 9

A one-to-one binary relationship in an E-R diagram can be converted into either one or two tables in a relational database.

Accepted Answer

A) True 
 B)False

Question 10

A relational table in first normal form ____.

Accepted Answer

A)  is also in second normal form 
B)  is also in third normal form 
C)  has no transitive dependencies 
D)  has no determinants 
E)  None of the above. 
A)  is also in second normal form 
B)  is also in third normal form 
C)  has no transitive dependencies 
D)  has no determinants 
E)  None of the above.

Question 11

In third normal form, the exception to the rule that a non-key attribute cannot define another non-key attribute is ____.

Accepted Answer

A)  if the defining attribute is a candidate key 
B)  if the defined attribute is a candidate key 
C)  if the defining attribute is a foreign key 
D)  if the defined attribute is a foreign key 
E)  None of the above. 
A)  if the defining attribute is a candidate key 
B)  if the defined attribute is a candidate key 
C)  if the defining attribute is a foreign key 
D)  if the defined attribute is a foreign key 
E)  None of the above.

Question 12

Logical database design is the process of modifying the physical database design to improve performance.

Accepted Answer

A) True 
 B)False

Question 13

Physical database design is the process of modifying the logical database design to improve performance.

Accepted Answer

A) True 
 B)False

Question 14

Data normalization ____.

Accepted Answer

A)  precedes physical database design 
B)  follows physical database design 
C)  is a physical database design technique 
D)  includes the creation of indexes among its steps 
E)  uses as its main technique the conversion of E-R diagrams into relational tables 
A)  precedes physical database design 
B)  follows physical database design 
C)  is a physical database design technique 
D)  includes the creation of indexes among its steps 
E)  uses as its main technique the conversion of E-R diagrams into relational tables

Question 15

A relational table in third normal form ____.

Accepted Answer

A)  is also in first normal form 
B)  is also in second normal form 
C)  has no transitive dependencies 
D)  All of the above. 
E)  None of the above. 
A)  is also in first normal form 
B)  is also in second normal form 
C)  has no transitive dependencies 
D)  All of the above. 
E)  None of the above.

Question 16

In converting a one-to-one binary relationship in an E-R diagram into two relational tables, the rule is that the unique identifier of the entity on the "many side" of the one-to-many relationship is placed as a foreign key in the table representing the entity on the "one side."

Accepted Answer

A) True 
 B)False

Question 17

The term that describes an attribute whose value establishes the value of another attribute is ____.

Accepted Answer

A)  full functional dependency 
B)  determinant 
C)  partial functional dependency 
D)  transitive dependency 
E)  minimum dependency 
A)  full functional dependency 
B)  determinant 
C)  partial functional dependency 
D)  transitive dependency 
E)  minimum dependency

Question 18

Data normalization is a methodology for organizing attributes into tables so that redundancy among the non-key attributes is eliminated.

Accepted Answer

A) True 
 B)False

Question 19

In the data normalization process, the database's attributes are subdivided into groups that will eventually form the database's tables.

Accepted Answer

A) True 
 B)False

Question 20

First normal form tables are free of data redundancy.

Accepted Answer

A) True 
 B)False

In data normalization terminology, an attribute is functionally dependent on its determinant.

Converting a ternary relationship into a relational database from an E-R diagram ____.

Converting a one-to-one binary relationship into a relational database from an E-R diagram ____.

Converting from first to second normal form involves subdividing tables to remove partial functional dependencies.

Multivalued attributes are not permitted in unnormalized data.

Placing the unique identifier of one database table in another existing or new table in the database ____.

Data in ____ cannot have partial functional dependencies but can have transitive dependencies.

Data in ____ has only a single attribute value in every attribute position.

A one-to-one binary relationship in an E-R diagram can be converted into either one or two tables in a relational database.

A relational table in first normal form ____.

In third normal form, the exception to the rule that a non-key attribute cannot define another non-key attribute is ____.

Logical database design is the process of modifying the physical database design to improve performance.

Physical database design is the process of modifying the logical database design to improve performance.

Data normalization ____.

A relational table in third normal form ____.

In converting a one-to-one binary relationship in an E-R diagram into two relational tables, the rule is that the unique identifier of the entity on the "many side" of the one-to-many relationship is placed as a foreign key in the table representing the entity on the "one side."

The term that describes an attribute whose value establishes the value of another attribute is ____.

Data normalization is a methodology for organizing attributes into tables so that redundancy among the non-key attributes is eliminated.

In the data normalization process, the database's attributes are subdivided into groups that will eventually form the database's tables.

First normal form tables are free of data redundancy.

Data: the New Corporate Resource

Data Modeling

The Database Management System Concept

Relational Data Retrieval: SQL

The Relational Database Model: Introduction

The Relational Database Model: Additional Concepts

Physical Database Design

Object-Oriented Database Management

Data Administration, Database Administration, and Data Dictionaries

Database Control Issues: Security, Backup and Recovery, Concurrency

Clientserver Database and Distributed Database

The Data Warehouse

Database and the Internet

Filters

Exam 7: Logical Database Design

In data normalization terminology, an attribute is functionally dependent on its determinant.

Converting a ternary relationship into a relational database from an E-R diagram ____.

Converting a one-to-one binary relationship into a relational database from an E-R diagram ____.

Converting from first to second normal form involves subdividing tables to remove partial functional dependencies.

Multivalued attributes are not permitted in unnormalized data.

Placing the unique identifier of one database table in another existing or new table in the database ____.

Data in ____ cannot have partial functional dependencies but can have transitive dependencies.

Data in ____ has only a single attribute value in every attribute position.

A one-to-one binary relationship in an E-R diagram can be converted into either one or two tables in a relational database.

A relational table in first normal form ____.

In third normal form, the exception to the rule that a non-key attribute cannot define another non-key attribute is ____.

Logical database design is the process of modifying the physical database design to improve performance.

Physical database design is the process of modifying the logical database design to improve performance.

Data normalization ____.

A relational table in third normal form ____.

In converting a one-to-one binary relationship in an E-R diagram into two relational tables, the rule is that the unique identifier of the entity on the "many side" of the one-to-many relationship is placed as a foreign key in the table representing the entity on the "one side."

The term that describes an attribute whose value establishes the value of another attribute is ____.

Data normalization is a methodology for organizing attributes into tables so that redundancy among the non-key attributes is eliminated.

In the data normalization process, the database's attributes are subdivided into groups that will eventually form the database's tables.

First normal form tables are free of data redundancy.

Data: the New Corporate Resource

Data Modeling

The Database Management System Concept

Relational Data Retrieval: SQL

The Relational Database Model: Introduction

The Relational Database Model: Additional Concepts

Physical Database Design

Object-Oriented Database Management

Data Administration, Database Administration, and Data Dictionaries

Database Control Issues: Security, Backup and Recovery, Concurrency

Clientserver Database and Distributed Database

The Data Warehouse

Database and the Internet

Filters