True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
The
normalization process enables you to identify the existence of potential problems.
|
|
|
2.
|
Potential problems that can occur within tables are called disbursement
anomalies.
|
|
|
3.
|
To
correct update anomalies in a database, tables must be converted into various types of normal
forms.
|
|
|
|
|
|
4.
|
Please refer to the above figure. It can be said that the CustomerName in the Customer
table is functionally dependent on RepNum.
|
|
|
|
|
|
5.
|
Please refer to the above figure. We can say that NumOrdered in the OrderLine table is
functionally dependent on OrderNum.
|
|
|
6.
|
Please refer to the above figure. We can see that NumOrdered in the OrderLine table is
functionally dependent on both columns OrderNum and PartNum.
|
|
|
7.
|
Please refer to the above figure. It can be said that NumOrdered, from the OrderLine
table, is functionally dependent on PartNum.
|
|
|
8.
|
Please refer to the above figure. OrderNum is the primary key for the OrderLine
table.
|
|
|
9.
|
Please refer to the above figure. The combination of OrderNum and PartNum is the
primary key for the OrderLine table.
|
|
|
10.
|
Please refer to the above figure. In the table OrderLine, NumOrdered is
functionally dependent on QuotedPrice.
|
|
|
11.
|
Attribute B is functionally dependent on attribute A if the value for A determines a
single value for B.
|
|
|
12.
|
Functional dependencies can be determined by looking at sample data.
|
|
|
|
|
|
13.
|
Please refer to the above figure. Class is the primary key for the Part
table.
|
|
|
14.
|
Please refer to the above figure. The combination of PartNum and Description is the
primary key for the Part table.
|
|
|
|
|
|
15.
|
Please refer to the above figure. CustomerNum is the primary key for the Customer
table.
|
|
|
16.
|
A
table that contains a repeating group is in first normal form.
|
|
|
17.
|
A
column is a nonkey column if it is not a part of the primary key.
|
|
|
18.
|
If
the primary key of a table contains only a single column, the table is automatically in second normal
form.
|
|
|
19.
|
Any
column (or collection of columns) that determines another column is called a
determinant.
|
|
|
20.
|
A
table is in third normal form if it is in second normal form and the only determinants are a single
primary key.
|
|
|
21.
|
To
put a table in the third normal form, you must remove the determinant.
|
|
|
22.
|
To
put a table into third normal form, make the determinant the primary key of the new
table.
|
|
|
23.
|
A
valid decomposition of tables is one in which the functional dependence has been split across two
different tables.
|
|
|
24.
|
A
table is in fourth normal form if it is in third normal form and has no multivalued
dependencies.
|
|
|
25.
|
In a
table with columns A, B, and C, there is a multivalued dependency 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.
|
|
|
26.
|
Given
the definition of a multivalued dependency, we can also write it as A ->-> B.
|
|
|
27.
|
If a
table is in third normal form and has multivalued dependencies, then it is considered to be in fourth
normal form.
|
|
|
28.
|
To
better normalize a table, all you need is a more sophisticated method for converting an unnormalized
table to first normal form.
|
|
|
29.
|
If
there are two or more repeating groups, place each repeating group in a separate table.
|
|
|
30.
|
If
there are two or more repeating groups and you place each repeating group in its own table, then the
primary key for each table will be the primary key of the original table.
|
Modified True/False
Indicate
whether the sentence or statement is true or false. If false, change the identified word or
phrase to make the sentence or statement true.
|
|
|
31.
|
The
normalization process enables you to identify the existence of potential problems.
|
|
|
32.
|
Potential problems that can occur within tables are called disbursement
anomalies.
|
|
|
33.
|
To
correct update anomalies in a database, tables must be converted into various types of normal
forms.
|
|
|
|
|
|
34.
|
Please refer to the above figure. Class is the primary key for the Part
table.
|
|
|
35.
|
A
column is a(n) nonkey column if it is not a part of the primary key.
|
|
|
36.
|
If
the primary key of a table contains only a single column, the table is automatically in second
normal form.
|
|
|
37.
|
Any
column or collection of columns that determines another column is called a(n) determinant.
|
|
|
38.
|
A
table is in third normal form if it is in first normal form and the only determinants it
contains are candidate keys.
|
|
|
39.
|
The
most recent definition of a third normal form is to refer to it as the Bornes-Culan normal
form.
|
|
|
40.
|
A
table is in fourth normal form if it is in third normal form and has no multivalued
dependencies.
|
|
|
41.
|
The
correct notation to write that B is dependent on A would be A -> ->B.
|
|
|
42.
|
The
correct notation to write that A multidetermines B is A->->B.
|
|
|
43.
|
In
order to convert a table from third to fourth normal form, you must split the table into separate
columns.
|
|
|
44.
|
The
conversion of an unnormalized table to first normal form requires the removal of individual
groups.
|
|
|
45.
|
If
there are two or more repeating groups in a table, then each group must be placed in a(n)
separate table.
|
|
|
46.
|
When
a table has been split into two tables, the primary key to each new table consists of the
concatenation of the original primary key and the primary key to the system groups.
|
|
|
47.
|
To
summarize the concept of the first normal form, no repeating groups must exist.
|
|
|
48.
|
To
summarize the concept of the second normal form, it must be in first normal form and no data
column can be dependent on any portion of the primary key.
|