Shelly Cashman Series Lab - Designing a Database


Name   ____________________________________


Course and Division _______________________


Date   ___________________     Page 1 of 2


As you step through the Interactive Lab, answer the following
questions in the spaces provided. For multiple choice
questions, enter the appropriate letter on the blank line.

1. In an inventory database, PART NUMBER would be an 
example of a _____________.

a. flat file
b. field
c. record
d. database file

2. A database restricts a user's access to a single file.
True or False? _____________

3. In a hierarchical database, a child can have more than
one parent. True or False? _____________

4. In a _____________ database, data across multiple files
is linked together based on a single field common to each
file.

a. hierarchical
b. object-oriented
c. network
d. relational

5. _____________ are items containing data and the actions
which can be taken on that data.

a. Objects
b. Relations
c. Networks
d. Trees

6. When a user is querying a database, he or she is 
_____________.

a. adding a record to the database
b. modifying a record that already exists in the database
c. deleting a record from the database
d. requesting data from the database to display












Shelly Cashman Series Lab - Designing a Database
Page 2 of 2


7. With QBE, a user enters criteria into one or more
_____________.

a. files
b. records
c. fields
d. children

8. SQL stands for _____________.

a. standard query language
b. stored query language
c. structured query language
d. saved query language

9. What type of field information is stored in a data
dictionary?

__________________________________________________________

__________________________________________________________

10. A(n) _____________ records changes made to the database in
a log, which can be used to reconstruct the database in
the event of an accident or malfunction.

a. query language
b. utility program
c. security program
d. recovery program

11. LAST NAME would be a good choice for a key field.
True or False? _____________ 

12. Explain why default values are used.

__________________________________________________________

__________________________________________________________