DBMS- Normalization
DBMS- Normalization
21. A relation R is said to be in 2NF
- if it is in 1NF
- every non-prime key attributes of R is fully functionally dependent on each relation key of R.
- if it is in BCNF
- both (a) and (b)
22. A relation R is said to be in 3NF if the
- relation R is in 2NF
- nonprime attributes are mutually independent
- functionally dependent on the primary key.
- all of these.
23. The idea of multi-valued dependency was introduced by
- E.F. Codd
- R.F. Boyce
- R. Fagin
- none of these
24. The expansion of BCNF is
- Boyd-Codd Normal Form
- Boyce-Ccromwell Normal Form
- Boyce-Codd Normal Form
- none of these
25. The fourth normal form (4NF) is concerned with dependencies between the elements of compound keys composed of
- one attribute
- two attributes
- three or more attributes
- none of these
26. When all the columns (attributes) in a relation describe and depend upton the primary key, the relation is said to be in
- 1NF
- 2NF
- 3NF
- 4NF