A relation is in fourth normal form if it is in BCNF, and it has no……….
a) deletion dependencies
b) transitive dependencies
c) multi-value dependencies
d) partial dependencies
A relation is in………. normal form, if it has no join dependency.
a) 3NF
b) 4NF
c) 5NF
d) 1NF
Explanation: 5NF stand for fifth normal form
What does partial dependency mean?
a) some attributes not known
b) right-hand side dependency necessary
c) no dependency exist in entity
d) not all attributes
The anomalies addressed by removing from BCNF to 4NF generally deals with
a) excessive updates
b) inability to uniquely identity
c) inability to reconstruct
d) creation of identical rows
In general, a row in a relation should have all of data about………
a) one instance of relation
b) each instance of relation
c) every instance of relation
d) no instance of relation
Which of the following is a requirement of 3NF?
a) must contain partial dependency
b) must contain composite
c) must contain transitive
d) must contain no partial dependency
