Register

Dbms 2nf self doubt

1,021 views
0 0 votes
Consider the following.Let A and B be two candidate keys.Let X be a proper subset of A.Let n be a non prime attribute.Does the following violate 2NF?

. AB->n

. XB->n

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← Previous · Made easy test serie...Next → · me test
← Previous in category · Gateforum Test Serie...Next in category → · MadeEasy Test Series...
Position:
Show:

Related questions

3 3 votes
1 1 answer
134
134 views
GO Classes asked Sep 17
134 views
GO Classes DPP | GATE CS, DA | DBMS | 2NF Decomposition
Consider $R(A,B,C,D,E,F,G,H,I,J)$ with $F=\{AB\to CD,\ D\to EFG,\ FG\to H,\ A\to I,\ AB\to EG,\ AI\to IJ\}$. The candidate key is $AB$.Which of the following is a valid $...
3 3 votes
1 1 answer
108
108 views
GO Classes asked Sep 17
108 views
GO Classes DPP | GATE CS, DA | DBMS | 2NF Decomposition
Consider $R(A,B,C,D,E,F,G,H,I,J)$ with $F=\{AB\to C,\ A\to DE,\ B\to F,\ F\to GH,\ D\to IJ\}$. The candidate key is $AB$.Which of the following is a valid $\text{2NF}$ de...
2 2 votes
1 1 answer
116
116 views
GO Classes asked Sep 17
116 views
GO Classes DPP | GATE CS, DA | DBMS | 2NF Decomposition
After representing the attributes atomically, consider $\text{Inventory(PartNbr, Warehouse, Location, QOH, Weight, PartColor)}$ with $\text{PartNbr} \to \text{Weight, Par...
2 2 votes
1 1 answer
104
104 views
GO Classes asked Sep 17
104 views
GO Classes DPP | GATE CS, DA | DBMS | 2NF Decomposition
Consider $\text{CLASS(CourseNo, SectionNo, RoomNo, Capacity)}$ with candidate key $\text{(CourseNo, SectionNo)}$ and functional dependency $\text{RoomNo} \to \text{Capaci...