Database Management System Practice Test 4

1. Which is a bottom-up approach to database design that design by examining the relationship between attributes:

2. Which of the following is not Armstrong's Axiom?

3. Suppose relation R(A,B,C,D,E) has the following functional dependencies:

A -> B
B -> C
BC -> A
A -> D
E -> A
D -> E

Which of the following is not a key?

4. Functional Dependencies are the types of constraints that are based on______

5. The refinement from an initial entity set into successive levels of entity subgroupings represents a ________ design process in which distinctions are made explicit.

6. If a relation is in BCNF, then it is also in

7. Consider a relation R(A,B,C,D,E) with the following functional dependencies:

ABC -> DE and
D -> AB 

The number of superkeys of R is:

8. Inst_dept (ID, name, salary, dept name, building, budget) is decomposed into

instructor (ID, name, dept name, salary)
department (dept name, building, budget)

This comes under

9. The total participation by entities is represented in E-R diagram as

10. A data type that creates unique numbers for key columns in Microsoft Access is: