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. | | |
|
|
|
|
|
|
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 | | | | |
|
|
|
|
|
|
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? |