Name: 
 

Chapter Five Study Guide (Part Two)



Multiple Choice
Identify the letter of the choice that best completes the statement or answers the question.
 

1. 

A table that possesses a certain desirable collection of properties is known as being in
a.
relations.
c.
a database.
b.
a DBMS.
d.
normal form.
 

2. 

Taking a table (or a collection of tables) and producing a new collection of tables that represents the same information but that is free of update anomalies is known as
a.
relational databases.
c.
functional dependency.
b.
normalization.
d.
creating keys.
 

3. 

The normalization process is the procedure with which we
a.
create tables in a database.
b.
identify the existence of potential problems.
c.
list the structure of the database.
d.
administer security in a database system.
 

4. 

Potential problems in the design of a relational database are also known as
a.
update anomalies.
c.
modification anomalies.
b.
select anomalies.
d.
relational anomalies.
 

5. 

To correct update anomalies in tables, the tables must be converted to
a.
individual form.
c.
normal form.
b.
data form.
d.
null form.
 

6. 

If B (an attribute) is functionally dependent on A, we can also say that
a.
A functionally determines B.
b.
A functionally determines another attribute in the table.
c.
B functionally determines A.
d.
B does not determine any other attribute.
 
 
chfive2_files/i0080000.jpg
 

7. 

Please refer to the above figure.  Is CustomerName functionally dependent on RepNum in the Customer table?
a.
No, not at all
c.
Yes, but only for certain attributes
b.
Yes, but only for certain rows
d.
Yes, but only for Rep number 20
 

8. 

Please refer to the above figure. What is the primary key to the Customer table?
a.
CustomerNum
c.
RepNum
b.
City
d.
State
 
 
chfive2_files/i0110000.jpg
 

9. 

Please refer to the above figure. On which columns is NumOrdered functionally dependent?
a.
OrderNum
c.
Both OrderNum and PartNum
b.
PartNum
d.
None of the above
 

10. 

Please refer to the above figure. What is the primary key for the OrderLine table?
a.
OrderNum
b.
PartNum
c.
OrderNum and PartNum
d.
OrderNum, PartNum, and NumOrdered
 

11. 

If all columns in a table are functionally dependent on a particular attribute, then this particular attribute is also known as a
a.
foreign key.
c.
major key.
b.
candidate key.
d.
special key.
 

12. 

The way to write B functionally dependent on A is
a.
B -> A
c.
B ->-> A
b.
A ->B
d.
A ->->B
 
 
chfive2_files/i0160000.jpg
 

13. 

Please refer to the above figure. What is the primary key for the Part table?
a.
PartNum
c.
PartNum and Description
b.
Description
d.
PartNum and Class
 

14. 

A candidate key is
a.
a singular primary key; no other columns could serve as a primary key.
b.
a column or several columns that could serve as a primary key.
c.
a composite primary key.
d.
a foreign key.
 

15. 

An alternate key is
a.
a foreign key.
b.
a primary key.
c.
a column that could be a primary key but was not chosen.
d.
a row that could be a primary key but was not chosen.
 
 
chfive2_files/i0200000.jpg
 

16. 

Please refer to the above figure.  Determine the problem with the table shown.
a.
It contains no primary key.
b.
It contains no description from the part table.
c.
It contains repeating groups.
d.
It contains the same date for a number of orders.
 

17. 

A table is in first normal form if
a.
it does not contain repeating groups.
b.
it does not contain repeating data.
c.
it does not contain repeating information.
d.
it does not contain repeating attributes.
 

18. 

A table that contains a repeating group (multiple entries for a single record) is called a(n)
a.
normalized relation.
c.
nominal relation.
b.
unnormalized relation.
d.
non-nominal relation.
 

19. 

A nonkey column can be defined as being
a.
not a part of the primary key.
c.
a composite part of the primary key.
b.
a part of the primary key.
d.
a section of the primary key.
 

20. 

The update anomaly means that a change to one column-row intersection requires
a.
a change to multiple tables.
c.
a change to multiple databases.
b.
a change to multiple rows.
d.
no change at all.
 

21. 

The inconsistent data anomaly means that
a.
an attribute could be listed differently in different tables.
b.
an attribute could be listed differently in different rows.
c.
an attribute could be listed differently in different databases.
d.
there is no problem with the table.
 

22. 

Which anomaly occurs when trying to insert two or more items into the database when each item requires that the other item be inserted first?
a.
Update
c.
Deletion
b.
Addition
d.
Inconsistent data
 

23. 

Which anomaly occurs when an item is removed from the database and then removes all related information from the other tables as well?
a.
Update
c.
Addition
b.
Inconsistent data
d.
Deletion
 

24. 

The anomalies of update, inconsistent data, addition, and deletion occur when
a.
a column is dependent on the primary key.
b.
a column is dependent on only a portion of the primary key.
c.
a column is dependent on an alternate key.
d.
a column is not dependent at all.
 

25. 

A column is a nonkey column when
a.
it is not a part of the primary key.
c.
it is not the primary key.
b.
it is a part of the primary key.
d.
it is the primary key.
 

26. 

A table is in second normal form if
a.
no nonkey column is dependent on only a portion of the primary key.
b.
it is in first normal form and no nonkey column is independent on only a portion of the primary key.
c.
it is in first normal form and no nonkey column is dependent on only a portion of the primary key.
d.
no nonkey column is independent on only a portion of the primary key.
 

27. 

A partial dependency is a dependency on only a portion of the
a.
foreign key.
b.
first column or attribute.
c.
primary key.
d.
similar rows.
 

28. 

If the primary key of a table is a single column, the table is in which highest normal form?
a.
first
c.
third
b.
second
d.
fourth
 

29. 

Any column that determines another column is called a
a.
deterrent.
c.
demeaning column.
b.
decision.
d.
determinant.
 

30. 

A table is in third normal form if it is in what other normal form and the only determinants are candidate keys?
a.
first
c.
third
b.
second
d.
fourth
 
 
chfive2_files/i0360000.jpg
 

31. 

Please refer to the above figure. Explain the problem with the table.
a.
There is no primary key.
b.
The name of the sales rep can occur many times.
c.
There are a number of balances greater than their credit limits.
d.
The CustomerName is part of a repeating group.
 

32. 

The definition of the third normal form is often referred to as which normal form?
a.
Boyce-Codd
c.
Binney-Smith
b.
Boylan-Couder
d.
Burns-Allen
 
 
chfive2_files/i0390000.jpg
 

33. 

What is the problem in the figure above?
a.
All other columns are determined by CustomerNum.
b.
The table contains a determinant that is not a candidate key.
c.
RepNum is a candidate key.
d.
CustomerNum is a primary key.
 

34. 

If a table contains columns A, B, and C, there is what term of column B on column A if each value for A is associated with a specific collection of values for B and furthermore, this collection is independent of any values for C?
a.
multivalued dependence
c.
multiple column
b.
multilisted dependence
d.
multiple row
 

35. 

How is the multivalued dependency of A to B usually written?
a.
A ->-> B
c.
B ->-> A
b.
A -> B
d.
B -> A
 

36. 

A table is in fourth normal form if it is in what normal form and there are no multivalued dependencies?
a.
first
c.
third
b.
second
d.
fourth
 

37. 

A table is in fourth normal form if it's in third normal form and there are no
a.
dependencies.
c.
primary keys.
b.
multivalued dependencies.
d.
candidate keys.
 

38. 

Which normal form has a required condition for no repeating groups?
a.
First
c.
Third
b.
Second
d.
Fourth
 

39. 

Which normal form has the additional condition that no nonkey column is dependent on only a portion of the primary key?
a.
First
c.
Third
b.
Second
d.
Fourth
 

40. 

Which normal form also has the condition that no multivalued dependencies exist?
a.
First
c.
Third
b.
Second
d.
Fourth
 

41. 

Which normal form has the additional condition that only determinants are candidate keys?
a.
First
c.
Third
b.
Second
d.
Fourth
 

42. 

Which normal form is automatically placed into this category if the primary key contains a single column?
a.
First
c.
Third
b.
Second
d.
Fourth
 

43. 

Which normal form is called the Boyce-Codd Normal Form?
a.
First
c.
Third
b.
Second
d.
Fourth
 

44. 

Column B is functionally dependent on column A if
a.
a value of A uniquely determines a value of B at any point in time.
b.
a value of B uniquely determines a value of A at any point in time.
c.
a value of B determines a value of A at any point in time.
d.
a value of A determines a value of B at any point in time.
 

45. 

Which key is a column that all other columns are dependent on?
a.
a foreign key
c.
a primary key
b.
a composite key
d.
a declared key
 

46. 

If there is more than one possible choice for the primary key, one of the possibilities is chosen to be the primary key.  The others are referred to as
a.
cancelled keys.
c.
congealed keys.
b.
candidate keys.
d.
contributory keys.
 

47. 

Another name for a nonkey column is a
a.
nonkey attribute.
c.
nonkey row.
b.
key attribute.
d.
nonkey table.
 

48. 

What is another name for a collection of tables?
a.
columns
c.
rows
b.
relations
d.
collections
 



 
Check Your Work     Reset Help