Question 1

Potential problems in the design of a relational database are known as ____.

Accepted Answer

A) select anomalies 
B) update anomalies 
C) modification anomalies 
D) relational anomalies 
A) select anomalies 
B) update anomalies 
C) modification anomalies 
D) relational anomalies B

Question 2

In a table with columns A,B,and C,there is a(n) ____________________ dependence of column B on column A if each value for A is associated with a specific collection of values for B and,further,this collection is independent of any values for C.

Accepted Answer

multivalued

Question 3

Describe the procedure for converting a table to the third normal form.

Accepted Answer

First,for each determinant that is not a candidate key,remove from the table the columns that depend on this determinant (but don't remove the determinant). Next,create a new table containing all the columns from the original table that depend on this determinant. Finally,make the determinant the primary key of this new table.

Question 4

The possibility of data dependence is one of the four categories of update anomalies.

Accepted Answer

A) True 
 B)False

Question 5

____ normal form has an additional condition that the only determinants the table contains are candidate keys.

Accepted Answer

A) First 
B) Second 
C) Third 
D) Fourth 
A) First 
B) Second 
C) Third 
D) Fourth

Question 6

A column is a nonkey column if it is ____.

Accepted Answer

A) in first normal form 
B) in second normal form 
C) a part of the primary key 
D) not a part of the primary key 
A) in first normal form 
B) in second normal form 
C) a part of the primary key 
D) not a part of the primary key

Question 7

An alternate key is a ____.

Accepted Answer

A) surrogate key 
B) natural key 
C) column that could be a primary key but was not chosen 
D) row that could be a primary key but was not chosen 
A) surrogate key 
B) natural key 
C) column that could be a primary key but was not chosen 
D) row that could be a primary key but was not chosen

Question 8

By converting a given collection of tables to an equivalent third normal form collection of tables,you remove any problems arising from ____________________ dependencies.

Accepted Answer

The answer of By converting a given collection of tables...

Question 9

Explain what normalization is,including the goal of normalization.

Accepted Answer

Normalization is a progression in which

Question 10

A column B is ____________________ on another column A if each value for A in the database is associated with exactly one value of B.

Accepted Answer

functional

Question 11

If you have different descriptions for the same item,such as part numbers,then you have the update anomaly known as ____________________.

Accepted Answer

The answer of If you have different descriptions for the...

Question 12

To convert a table to fourth normal form,split the third normal form table into separate tables,each containing the column that ____ the others.

Accepted Answer

A) determines 
B) multidetermines 
C) defines 
D) identifies 
A) determines 
B) multidetermines 
C) defines 
D) identifies

Question 13

The normalization process used to convert a relation or collection of relations to an equivalent collection of third normal form tables is a crucial part of the database design process.

Accepted Answer

A) True 
 B)False

Question 14

A table is in first normal form if it does not contain ____.

Accepted Answer

A) dependencies 
B) repeating groups 
C) a primary key 
D) anomalies 
A) dependencies 
B) repeating groups 
C) a primary key 
D) anomalies

Question 15

A column is a nonkey attribute when it is not part of the primary key.

Accepted Answer

A) True 
 B)False

Question 16

Discuss how candidate keys,primary key,and alternate keys are related.

Accepted Answer

Like a primary key,a candidate key is a

Question 17

A(n) ____ is a column or collection of columns on which all columns in the table are functionally dependent.

Accepted Answer

A) index key 
B) candidate key 
C) major key 
D) special key 
A) index key 
B) candidate key 
C) major key 
D) special key

Question 18

____ contains a repeating group.

Accepted Answer

A) Orders (OrderNum,OrderDate,(PartNum,NumOrdered) ) 
B) Orders (OrderNum ,OrderDate,PartNum,NumOrdered ) 
C) Orders (OrderNum ,OrderDate) 
D) Orders (OrderNum ,PartNum, NumOrdered ) 
A) Orders (OrderNum,OrderDate,(PartNum,NumOrdered) ) 
B) Orders (OrderNum ,OrderDate,PartNum,NumOrdered ) 
C) Orders (OrderNum ,OrderDate) 
D) Orders (OrderNum ,PartNum, NumOrdered )

Question 19

A(n) ____________________ uses arrows to indicate all the functional dependencies present in the table.

Accepted Answer

The answer of A(n) ____________________ uses arrows to indicate all...

Question 20

The definition for ____ also defines a candidate key.

Accepted Answer

A) functional key 
B) natural key 
C) primary key 
D) surrogate key 
A) functional key 
B) natural key 
C) primary key 
D) surrogate key

Potential problems in the design of a relational database are known as ____.

In a table with columns A,B,and C,there is a(n) ____________________ dependence of column B on column A if each value for A is associated with a specific collection of values for B and,further,this collection is independent of any values for C.

Describe the procedure for converting a table to the third normal form.

The possibility of data dependence is one of the four categories of update anomalies.

____ normal form has an additional condition that the only determinants the table contains are candidate keys.

A column is a nonkey column if it is ____.

An alternate key is a ____.

By converting a given collection of tables to an equivalent third normal form collection of tables,you remove any problems arising from ____________________ dependencies.

Explain what normalization is,including the goal of normalization.

A column B is ____________________ on another column A if each value for A in the database is associated with exactly one value of B.

If you have different descriptions for the same item,such as part numbers,then you have the update anomaly known as ____________________.

To convert a table to fourth normal form,split the third normal form table into separate tables,each containing the column that ____ the others.

The normalization process used to convert a relation or collection of relations to an equivalent collection of third normal form tables is a crucial part of the database design process.

A table is in first normal form if it does not contain ____.

A column is a nonkey attribute when it is not part of the primary key.

Discuss how candidate keys,primary key,and alternate keys are related.

A(n) ____ is a column or collection of columns on which all columns in the table are functionally dependent.

____ contains a repeating group.

A(n) ____________________ uses arrows to indicate all the functional dependencies present in the table.

The definition for ____ also defines a candidate key.

Introduction to Database Management

The Relational Model 1: Introduction, QBE, and Relational Algebra

The Relational Model 2: SQL

The Relational Model 3: Advanced Topics

Database Design 2: Design Method

Dbms Functions

Database Administration

Database Management Approaches

Filters

Exam 5: Database Design 1: Normalization

Potential problems in the design of a relational database are known as ____.

In a table with columns A,B,and C,there is a(n) ____________________ dependence of column B on column A if each value for A is associated with a specific collection of values for B and,further,this collection is independent of any values for C.

Describe the procedure for converting a table to the third normal form.

The possibility of data dependence is one of the four categories of update anomalies.

____ normal form has an additional condition that the only determinants the table contains are candidate keys.

A column is a nonkey column if it is ____.

An alternate key is a ____.

By converting a given collection of tables to an equivalent third normal form collection of tables,you remove any problems arising from ____________________ dependencies.

Explain what normalization is,including the goal of normalization.

A column B is ____________________ on another column A if each value for A in the database is associated with exactly one value of B.

If you have different descriptions for the same item,such as part numbers,then you have the update anomaly known as ____________________.

To convert a table to fourth normal form,split the third normal form table into separate tables,each containing the column that ____ the others.

The normalization process used to convert a relation or collection of relations to an equivalent collection of third normal form tables is a crucial part of the database design process.

A table is in first normal form if it does not contain ____.

A column is a nonkey attribute when it is not part of the primary key.

Discuss how candidate keys,primary key,and alternate keys are related.

A(n) ____ is a column or collection of columns on which all columns in the table are functionally dependent.

____ contains a repeating group.

A(n) ____________________ uses arrows to indicate all the functional dependencies present in the table.

The definition for ____ also defines a candidate key.

Introduction to Database Management

The Relational Model 1: Introduction, QBE, and Relational Algebra

The Relational Model 2: SQL

The Relational Model 3: Advanced Topics

Database Design 2: Design Method

Dbms Functions

Database Administration

Database Management Approaches

Filters