GATE 2023 Database Evaluation Quiz 7

For finding out the minimal cover we need to remove:

A table is in 3NF if it is in 2NF and if it has no ____________

Join Operator is derived using which of the basic operators?

Which of the following are the basic operators:

Attributes which does not belong to any of the candidate keys of the relation is termed as?

Consider relation R with five attributes as R (A B C D E), How many super keys are possible if AB is the candidate key?

Suppose relation R is in 3NF. Then an FD: X -> Y is valid on R, if:

S1: X  is a super key of R

S2: R is in 2 NF

Which of the following is true:

Consider the relation R(A, B, C, D) with Functional Dependency set :

F = {AB → C , C → D}

When we decompose the relation into R₁ (ABC) and R₂ (ABD). Check whether the relation is lossy or lossless decomposition?