DBMS- Normalization
DBMS- Normalization
11. Multi-valued dependencies are the result of 1NF, which prohibited an attribute from having a set of values.
- TRUE
- FALSE
13. Normalization is formal process of developing data structure in a manner that eliminates redundancy and promites integrity.
- TRUE
- FALSE
15. Normalization is a process of
- decomposing a set of relations
- successive reduction of relation schema.
- deciding which attributes in relation to be
- all of these
16. The normalization process was developed by
- E. F. Codd
- R. F. Boyce
- R. Fagin
- Collin White
17. A normal form is
- a state of a relation that results from applying simple rules regarding FDs.
- the highest normal form condition that it meets
- an indication of the degree to which it has been normalised
- all of these.
18. Which of the following is the formal process of deciding which attributes should be grouped together in a relation ?
- optimization
- normalization
- turning
- none of these
19. In 1NF,
- all domains are simple
- in a simple domain, all elements are atomic
- both (a) & (b)
- None of these