Normalization GATE Questions from 1997 to 2021
Which of the following is NOT a super key in a relational schema with attributes V, W, X, Y, Z and primary key VY?
(A) VXYZ
(B) VWXZ
(C) VWXY
(D) VWXYZ
The maximum number of super keys for the relation schema R (E, F, G, H) with E as the key is ___.
A prime attribute of a relation scheme R is an attribute that appears
(A) in all candidate keys of R.
(B) in some candidate key of R.
(C) in a foreign keys of R.
(D) only in the primary key of R.