Time Left - 10:00 mins
GATE CS 2018 - Database Quiz- 2 (Database Design)
Attempt now to get your rank among 685 students!
Question 1
The following functional dependencies hold true for the relational schema R{V, W, X, Y, Z}:
Which of the following is irreducible equivalent for this set of functional dependencies?
Which of the following is irreducible equivalent for this set of functional dependencies?
Question 2
Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set ?
Question 3
A relation R(A,B,C,D,E,F) holds the following FDs:
AB→C
C→D
D→EA
E→F
F→B
Find the number of candidate keys of R?
AB→C
C→D
D→EA
E→F
F→B
Find the number of candidate keys of R?
Question 4
Consider a relation R(ABCD) with FD‟s { A->B, A->C, BC->D }.
Answer the following:
(i) What is the highest normal form of this relation?
(ii) Does this relation have any redundancy in it?
Answer the following:
(i) What is the highest normal form of this relation?
(ii) Does this relation have any redundancy in it?
Question 5
F and G are two FDs sets
F: P → Q , R → P, PQ → R and G: P → R, R → Q , QR → P
Which of the following is correct?
F: P → Q , R → P, PQ → R and G: P → R, R → Q , QR → P
Which of the following is correct?
- 685 attempts
- 7 upvotes
- 6 comments
Tags :
GATE & PSU CSDatabasesJul 19GATE & PSU CS
