Time Left - 15:00 mins

Database Design Starter Quiz-1

Attempt now to get your rank among 74 students!

Question 1

A B is called a transitive dependency if and only if:

Question 2

X->Z is said to be partial dependency iff:

Question 3

Decomposition is called ____________ when the join of the sub relations does not result in the same relation R that was decomposed.

Question 4

Which of the following is a non-trivial functional dependency:

Question 5

Given a set of functional dependencies on R (A, B, C, D, E) find number of candidate keys?

A B

BC E

DE A

Question 6

Given a relation R = {A, B, C, D, E, H} and having the following FD’s:

F = {A → BC, CD → E, E → C, D → AEH, ABH → BD, DH → BC}.

The number of candidate keys for the above relation is ______ [in integer].

  • 74 attempts
  • 0 upvotes
  • 2 comments
May 13GATE & PSU CS