Question 6459 – Nielit Scientist-B IT 4-12-2016
December 3, 2023UGC NET Dec-2020 and June-2021 Paper-2
December 3, 2023UGC NET Dec-2020 and June-2021 Paper-2
|
Question 22
|
Given a relation scheme R(x,y,z,w) with functional dependencies set F={x- > y, z- > w}. All attributes take single and atomic values only.
A. Relation R is in First Normal FORM
B. Relation R is in Second Normal FORM
C. Primary key of R is xz
Choose the correct answer from the options given below:
A. Relation R is in First Normal FORM
B. Relation R is in Second Normal FORM
C. Primary key of R is xz
Choose the correct answer from the options given below:
|
A and C only
|
|
|
B and C only
|
|
|
B only
|
|
|
C only
|
Question 22 Explanation:
The Primary Key is xz.
There is Partial dependency from x – > y and z – > w. It is Given that all attributes take single and atomic values only.
So the relation is in 1NF but not in 2NF and the key is xz.
There is Partial dependency from x – > y and z – > w. It is Given that all attributes take single and atomic values only.
So the relation is in 1NF but not in 2NF and the key is xz.
Correct Answer: A
Question 22 Explanation:
The Primary Key is xz.
There is Partial dependency from x – > y and z – > w. It is Given that all attributes take single and atomic values only.
So the relation is in 1NF but not in 2NF and the key is xz.
There is Partial dependency from x – > y and z – > w. It is Given that all attributes take single and atomic values only.
So the relation is in 1NF but not in 2NF and the key is xz.