Which of the following operation perform in third normal form?
a) remove repeating group
b) remove functional dependency
c) remove partial dependency
d) none of these
Which of the following operation perform in fourth normal form?
a) remove repeating group
b) remove functional dependency
c) remove partial dependency
d) remove multi-valued dependency
Which of the following problems in first normal form?
a) updating problem
b) inconsistent data
c) addition problem
d) all of these
A relation is in domain/key normal form if…….
a) constraints and determinants
b) constraints and domains
c) keys and determinants
d) keys and domains
Which of the following is true from functional dependency shown as
(A, B) -> (C, D)?
a) A is determinant of C
b) A and B are determinant by C
c) A and B together determinant D
d) C and D together determinant A
What is the highest normal form a relation is in if every determinant is a candidate key?
a) 1NF
b) 2NF
c) 3NF
d) BCNF
Explanation: BCNF stand for Boyce Codd Normal Form
