GATE 2023 Databases Rank Booster Quiz 39

In E-R model, Y is specialized entity and X is generalized entity

Which of the following statement is true about views ?

A set of FDs is given for a relation R (A, B, C, D)

A → AB

AC → D

ABD → C

Then number of elements in {A, C}⁺ closure?

The subset of a super key is a candidate key under what condition?

For finding out the minimal cover we need to remove:

Consider the following functional dependencies on the relation R(A,B,C,D)

AB → CD;

ABD → C ;

ABC → D ;

AC → D

which the highest possible normal form for the above relation ?

Third normal form is based on the concept of ______.