Recent questions tagged functional-dependency / GATE Overflow for GATE CSE

0 votes

0 answers

1

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 be prime attribute to be in 3nf) ke hisaab se 3 nf main ni lagra in fd ... ye 3 nf tab ni hota jab D transitively dependent hoti ab pe, par yaha directly bhi dependent hai transitively bhi To isliye samjh nhi aa rha Please help

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 be prime attribute to be in 3nf) ke hisaab se ...

Uchiha Kartik

52 views

Uchiha Kartik asked 2 days ago

0 votes

1 answer

2

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->BC Find 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 ?

Yogesh_Jangde

195 views

Yogesh_Jangde asked Apr 13

6 votes

1 answer

3

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 Name, N: Number of Units, G: GPA, C: Course (of teaching), R ... only one applied? SID determines Rating Rating determines Wage Rating determines Course Rating and First Name determine Wage and Hours of Work

Consider the following database relation: $\mathrm{R}=(\mathrm{SFLNGCRW} \mathrm{H})=(\mathrm{S}$ : SID, F: First Name, L: Last Name, N: Number of Units, G: GPA, C: Cours...

GO Classes

396 views

GO Classes asked Feb 5

0 votes

1 answer

4

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 \\ WX \rightarrow Y \\ WX \rightarrow Z \\ V \rightarrow X \end ... be deduced. Which of the following options is correct? $VW \rightarrow U$ $VW \rightarrow Y$ $VW \rightarrow YZ$ $WX \rightarrow YZ$

Consider a relation R:\[\begin{aligned}& R(U, V, W, X, Y, Z) \\& F=\left\{\begin{array}{l} U \rightarrow V \\ U \rightarrow W \\ WX \rightarrow Y \\�...

GO Classes

241 views

GO Classes asked Feb 4

4 votes

3 answers

5

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. Consider the following statements: Domain of each attribute is an ... $\text{A - BCNF, B - 3NF, C - 2NF, D - 1NF}$

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 at...

GO Classes

498 views

GO Classes asked Jan 21

8 votes

4 answers

6

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$ (where $X^{+}$is the closure of $X).$ ... $2.$ $R$ is in $2 N F$. $R$ is in $3 N F$.

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$ (w...

GO Classes

1.1k views

GO Classes asked Jan 13

0 votes

1 answer

7

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?

Isn’t F$^{+}$ minimal cover? If C $\rightarrow$ A is already there, then why does augmented CD $\rightarrow$ A needs to be?

Mrityudoot

157 views

Mrityudoot asked Jan 12

0 votes

1 answer

8

DBMS Functional Dependencies
Will a single attribute key considered as a prime attribute as well? I know If it is a compound key like (ABC) then my prime attribute set would be {A,B,C,AB,BC,AC} But if I have only 1 Candidate key in my relation (A) then will A ... or not? Also if multiple single attribute keys are there then what happens (Say {A}, {B} are both candidates) with the prime attributes?

Will a single attribute key considered as a prime attribute as well?I know If it is a compound key like (ABC) then my prime attribute set would be {A,B,C,AB,BC,AC}But if ...

Mrityudoot

323 views

Mrityudoot asked Jul 28, 2023

tags	tag:apple
author	user:martin
title	title:apple
content	content:apple
exclude	-tag:apple
force match	+apple
views	views:100
score	score:10
answers	answers:2
is accepted	isaccepted:true
is closed	isclosed:true