1. Which of the following is least likely to be an attribute of an employee table in a normalized database?
a. employee name
b. employee address
c. employee number
d. employee supervisor’s name
e. all of these would be attributes of the employee table in a normalized database.
2. The advantages to using a partitioned database approach include all of the following EXCEPT
a. the possibility for the deadlock phenomenon is reduced.
b. user control is increased.
c. transaction processing time is decreased.
d. the potential for wide scale disaster is reduced.
e. these are all advantages of partitioned databases.
3. Of the following, select the attribute that would be the best primary key in an inventory table.
a. ITEM NAME
b. ITEM LOCATION
c. ITEM COST
d. ITEM NUMBER
e. ITEM SUPPLIER