Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
|
|
|
1.
|
Please refer to the above figure. What is the primary key of the Sales
table? a. | RepNum | b. | CustomerNum | c. | PartNum | d. | RepNum, PartNum, and CustomerNum | | |
|
|
|
2.
|
A set
of requirements that is necessary to support the operations of a particular database user is known as
a a. | user
view. | c. | user
attribute. | b. | user table. | d. | user field. | | | | |
|
|
|
3.
|
A
design that supports all the user views encountered in the design process is known as
a a. | merged
design. | c. | defined
design. | b. | cumulative design. | d. | listed design. | | | | |
|
|
|
4.
|
What
is the first step needed in designing a user view? a. | Represent the
user view as a collection of tables | b. | Normalize these tables | c. | Identify all
keys in these tables | d. | Merge the result into the cumulative
design | | |
|
|
|
5.
|
When
a correct design is not obvious, what is the first step in creating a user view? a. | Determine the
entities involved and create a separate table for each type of entity | b. | Determine the
primary key for each table | c. | Determine the properties for each
entity | d. | Determine relationships among the
entities | | |
|
|
|
6.
|
When
determining the properties for each entity as you design the user view, these properties will become
what in the table? a. | rows | c. | data | b. | columns | d. | DBMS | | | | |
|
|
|
7.
|
One
of the basic relationships among tables is a. | one-to-many. | c. | one-to-one. | b. | many-to-many. | d. | all of the
above | | | | |
|
|
|
8.
|
After
establishing the relationships among the entities, what normal form should the tables ideally be
in? a. | first | c. | third | b. | second | d. | none of the above | | | | |
|
|
|
|
|
|
9.
|
Please refer to the above figure. What does the entry FK DepartmentNum ->
Department represent? a. | a first key | c. | a fourth key | b. | a foreign
key | d. | a fifth
key | | | | |
|