Concept drill
partial-dependency
GATE CSE & IT · Normalization · 1997-2016
3
PYQs
100%
keyed
0
elite explanations
3
years appeared
Study anchor
Korth — Database System Concepts
Relational model, SQL, normalization, transactions
Practice action
Start latest PYQPYQs in this concept
All concepts →2016 PYQ
A database of research articles in a journal uses the following schema. (VOLUME, NUMBER, STARTPAGE, ENDPAGE, TITLE, YEAR, PRICE) The primary key is (VOLUME, NUMBER, STARTPAGE, ENDP...
mediumanswer key
2013 PYQ
Relation $$R$$ has eight attribution $$ABCDEFGH.$$ Fields of $$R$$ contain only atomic values. $$F = \left\{ {CH \to G,\,\,A \to BC,\,B \to CFH,\,\,E \to A,\,\,F \to EG} \right\}$$...
mediumanswer key
1997 PYQ
For a database relation $$R(a,b,c,d),$$ where the domains of $$a, b, c, d$$ include only atomic values, only the following functional dependencies and those that can be inferred fr...
easyanswer key