NIC-NIELIT Scientist-B 2020
October 3, 2023Environment
October 3, 2023Database-Management-System
|
Question 4
|
Which of the following is NOT a superkey in a relational schema with attributes V, W, X, Y, Z and primary key VY?
|
VXYZ
|
|
|
VWXZ
|
|
|
VWXY
|
|
|
VWXYZ
|
Question 4 Explanation:
It is given that “VY” is a primary key of the relational schema.
Any superset of “VY” is a super key. So, option (B) does not contain “Y”.
Any superset of “VY” is a super key. So, option (B) does not contain “Y”.
Correct Answer: B
Question 4 Explanation:
It is given that “VY” is a primary key of the relational schema.
Any superset of “VY” is a super key. So, option (B) does not contain “Y”.
Any superset of “VY” is a super key. So, option (B) does not contain “Y”.