Question 6459 – Nielit Scientist-B IT 4-12-2016
December 3, 2023Question 16243 – UGC NET Dec-2020 and June-2021 Paper-2
December 3, 2023Question 16242 – UGC NET Dec-2020 and June-2021 Paper-2
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:
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.
A and C only
B and C only
B only
C only
Subscribe
Login
0 Comments