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 | | | | |
|
|
|
10.
|
An
alternative to the primary key of a table (another possible primary key) is listed with what
abbreviation in DBDL?
|
|
|
11.
|
What
type of diagram visually represents the structure of a database?
|
|
|
12.
|
An
entity that does not require a relationship to another entity for identification is called
a(n) a. | alternative
entity. | c. | independent
entity. | b. | foreign entity. | d. | single entity. | | | | |
|
|
|
|
|
|
13.
|
Please refer to the above figure. Which table can be considered a dependent
entity? a. | Customer
table | c. | OrderLine
table | b. | Rep table | d. | Part table | | | | |
|
|
|
14.
|
In
the design diagram, independent entities are distinguished by a. | square
corners. | c. | cut
corners. | b. | rounded corners. | d. | chipped corners. | | | | |
|
|
|
15.
|
In
the design diagram, dependent entities are distinguished by a. | square
corners. | c. | cut
corners. | b. | rounded corners. | d. | chipped corners. | | | | |
|
|
|
16.
|
A
relationship that is necessary for identification is called a(n) a. | objectifying
relationship. | c. | identifying
relationship. | b. | merging relationship. | d. | referential relationship. | | | | |
|
|
|
17.
|
After
the information level design is completed, what is the next step? a. | the physical
level design | c. | the DBMS level
design | b. | the modality level design | d. | the table level design | | | | |
|
|
|
18.
|
What
is the easiest way to produce the design for the DBMS, given that the final information-level design
already exists in a relational format? a. | design a new database | c. | use the same tables and columns | b. | use new
tables | d. | use a different
DBMS | | | | |
|
|
|
19.
|
When
a DBMS cannot enforce the restrictions you place on tables, who should enforce them? a. | the users of the
system | c. | the
manufacturers of the DBMS | b. | the database administrators | d. | no one | | | | |
|
|
|
20.
|
Aside
from the user, who else can enforce restrictions when the DBMS cannot? a. | the
programmer | c. | the
CEO | b. | the
administrator | d. | the
DBDL | | | | |
|
|
|
21.
|
What
is the letter "n" used for in an E-R diagram? a. | one | c. | many | b. | two | d. | nothing | | | | |
|
|
|
22.
|
When
there is a many to many relationship, what should you do? a. | merge all
columns into one table | c. | define a new
database | b. | create an additional table | d. | change column names | | | | |
|
|
|
23.
|
In a
many to many situation, what letters are used to denote this relationship? a. | m and
n | c. | n and
n | b. | m and
m | d. | m and
y | | | | |
|
|
|
24.
|
In
most E-R diagrams, what is the shape used to denote an entity? a. | circle | c. | rectangle | b. | square | d. | diamond | | | | |
|
|
|
25.
|
In
most E-R diagrams, what is the shape used to denote the implementation of the
relationship? a. | circle | c. | rectangle | b. | square | d. | diamond | | | | |
|
|
|
26.
|
When
an entity exists to implement a relationship, it is called a a. | composite
entity. | c. | complicated
entity. | b. | complex entity. | d. | circular entity. | | | | |
|
|
|
27.
|
What
does the crow's foot denote in an E-R diagram? a. | a one-to-one relationship | c. | a many-to-many relationship | b. | a one-to-many
relationship | d. | no relationship
listed | | | | |
|
|
|
28.
|
When
using the crow's foot in an E-R diagram, which end of the relationship does that crow's foot
represent? a. | the one
end | c. | either
end | b. | the many
end | d. | both
ends | | | | |
|
|
|
29.
|
The
number of items that must be included in a relationship in an E-R diagram are known
as a. | entities. | c. | DBDL. | b. | cardinality. | d. | composites. | | | | |
|
|
|
30.
|
The
number closest to the entity represents what cardinality? a. | maximum | c. | midvalue | b. | minimum | d. | smallest | | | | |
|
|
|
31.
|
The
number closest to the relationship represents what cardinality? a. | maximum | c. | midvalue | b. | minimum | d. | largest | | | | |
|
|
|
32.
|
What
does it mean when an entity has a minimum cardinality of zero? a. | The entity has a
mandatory role in the relationship. | b. | The entity is not required in the
relationship. | c. | The entity should not be in the relationship as an
attribute. | d. | The entity must be listed with all zeroes in the data
fields. | | |
|
|
|
33.
|
What
does it mean when an entity has a minimum cardinality of one? a. | The entity is
required in the relationship. | b. | The entity is not required in the
relationship. | c. | The entity should not be in the relationship as an
attribute. | d. | The entity must be listed with all ones in the data
fields. | | |
|
|
|
34.
|
The
design strategy in which specific user requirements are synthesized into a design is known as
a. | top-down design
methodology. | c. | bottom-up design
methodology. | b. | listing design methodology. | d. | original design methodology. | | | | |
|
|
|
35.
|
The
design strategy in which a general database design that models the overall enterprise, and that
repeatedly refines the model to achieve a design that supports all necessary applications, is known
as a. | top-down design
methodology. | c. | bottom-up design
methodology. | b. | listing design methodology. | d. | original design methodology. | | | | |
|
|
|
36.
|
The
best way to obtain required information from the user is to complete a a. | user
form. | c. | relational
form. | b. | database form. | d. | survey form. | | | | |
|
|
|
37.
|
Which
type of information collected on the survey form contains the name and description and identifies any
synonyms for each entity? a. | attribute information | c. | relationships | b. | entity
information | d. | functional
dependencies | | | | |
|
|
|
38.
|
Which
type of information collected on the survey form contains the attributes for the name, a description,
and synonyms for each entity? a. | attribute information | c. | relationships | b. | entity
information | d. | functional
dependencies | | | | |
|
|
|
39.
|
Which
type of information collected on the survey form contains the type of relationships, the significance
of the relationships, and the restrictions on the relationship? a. | attribute
information | c. | relationships | b. | processing information | d. | functional dependencies | | | | |
|
|
|
40.
|
Which
type of information collected on the survey form indicates how the entities are
related? a. | attribute
information | c. | relationships | b. | entity information | d. | functional dependencies | | | | |
|
|
|
41.
|
Which
type of information collected on the survey form describes how the data is updated? a. | attribute
information | c. | relationships | b. | processing information | d. | entity information | | | | |
|
|
|
42.
|
The
first step in obtaining information from an existing document is to identify and list all
a. | rows. | c. | entities. | b. | columns. | d. | groups. | | | | |
|
|
|
43.
|
After
obtaining the column information from an existing document, the next step is to
identify a. | entities. | c. | functional
dependencies. | b. | rows. | d. | columns. | | | | |
|
|
|
44.
|
After
determining the preliminary functional dependencies from an existing document, you can begin to
determine the tables and assign the a. | columns. | c. | entities. | b. | rows. | d. | data. | | | | |
|
|
|
45.
|
After
identifying the columns from an original document and identifying the functional dependencies, the
table must be converted to what normal form? a. | first | c. | third | b. | second | d. | none of the
above | | | | |
|
|
|
46.
|
How
can you force uniqueness in a table? a. | designate foreign keys as alternate
keys | b. | designate
alternate keys as foreign keys | c. | designate primary keys as alternate
keys | d. | designate
foreign keys as primary keys | | |
|
|
|
|
|
|
47.
|
Please refer to the above figure. What term describes the relationship between
the RepNum, CustomerNum, and PartNum? a. | one-to- many | c. | many-to-many-to-many | b. | many-to-many | d. | one-to-one-to-one | | | | |
|
|
|
48.
|
A
null represents a(n) a. | zero in a field. | c. | blank space in a field. | b. | absence of a
value in a field. | d. | single value in
a field. | | | | |
|
|
|
49.
|
When
combining third normal forms, the result does not have to be in a. | first normal
form. | c. | third normal
form. | b. | second normal form. | d. | an entity. | | | | |
|