Register

Recent questions tagged functional-dependency

255
views
4 answers
2 votes
PW DPP DBMS - Functional Dependency
Consider the given FD set for relation R (X, Y, Z, W, U, V) {X → Y, YZ → W, U → Z, W → X} Then the number of prime attributes for the relation are?
User Avatar
158
views
1 answers
0 votes
Topic = fd's and normalization.
Q) In R(A,B,C,D)FD's {AB->CD, C->D}Is it in 3NF?Ans) Vaise to shortcut (in x->y fd either x should be super key or y should ... dependent hoti ab pe, par yaha directly bhi dependent hai transitively bhiTo isliye samjh nhi aa rhaPlease help
User Avatar
321
views
1 answers
1 votes
Minimal Cover
Consider R(A,B,C,D,E,H) be a relational schema with the following functional dependencies:A->BC, CD->E, E->C, D->AEH, ABH->BD, DH->BCFind minimal cover ?
User Avatar
461
views
1 answers
6 votes
GO Classes Test Series 2024 | Mock GATE | Test 14 | Question: 50
Consider the following database relation: $\mathrm{R}=(\mathrm{SFLNGCRW} \mathrm{H})=(\mathrm{S}$ : SID, F: First Name, L: Last ... RatingRating determines WageRating determines CourseRating and First Name determine Wage and Hours of Work
User Avatar
301
views
1 answers
0 votes
Memory Based GATE DA 2024 | Question: 16
Consider a relation R:\[\begin{aligned}& R(U, V, W, X, Y, Z) \\& F=\left\{\begin{array}{l}    U \rightarrow V \\    U \rightarrow W \\ ... $VW \rightarrow Y$VW \rightarrow YZ$WX \rightarrow YZ$
User Avatar
616
views
3 answers
4 votes
GO Classes Test Series 2024 | Mock GATE | Test 12 | Question: 23
An attribute $A$ is called prime if $A$ is in any of the candidate keys. Assume in the following statements, $\mathrm{A}$ is an attribute $\&\;\mathcal{X}$ is a set of attributes ... , D - BCNF}$\text{A - BCNF, B - 3NF, C - 2NF, D - 1NF}$
User Avatar
1.3k
views
4 answers
8 votes
GO Classes Test Series 2024 | Mock GATE | Test 11 | Question: 60
In a relational database relation, we say a non-empty set of attributes $\mathrm{X}$ is closed (with respect to a given set of functional dependencies FD) if $X^{+}=X$ ... $R$ is in $2 N F$.$R$ is in $3 N F$.
User Avatar
188
views
1 answers
0 votes
Made Easy Test Series
Isn’t F$^{+}$ minimal cover? If C $\rightarrow$ A is already there, then why does augmented CD $\rightarrow$ A needs to be?
User Avatar
Page: