Dark Mode

Recent questions tagged data-dependency

0 votes

1 answer

1

#DBMS #dependency
What is the number of redundent FD’s possible for given set of FD , A->B, B->C,C->D for relation R(ABCD)?? please explain in detail.

Abhishek tarpara asked in Databases Sep 17, 2021

by Abhishek tarpara

425 views

3 votes

2 answers

2

UGC NET CSE | October 2020 | Part 2 | Question: 14
Consider a relational schema $S=(U,V,W,X,Y,Z)$ on which the following functional dependencies hold: $(U \rightarrow V, VW \rightarrow X, Y \rightarrow W, X \rightarrow U)$ Which are the candidate keys among following options? $UY, VY$ $UY, VY, XY$ $UYZ, VYZ, VWZ$ $UYZ, VYZ, XYZ$

go_editor asked in Databases Nov 20, 2020

1.8k views

2 votes

2 answers

3

NIELIT 2016 MAR Scientist C - Section C: 4
A functional dependency of the form $x\to y$ is trivial if $y\subseteq x$ $y\subset x$ $x\subseteq y$ $x\subset y\:\text{and}\:y\subset x$

Lakshman Patel RJIT asked in Databases Apr 2, 2020

by Lakshman Patel RJIT

4.3k views

0 votes

2 answers

4

NIELIT 2016 MAR Scientist C - Section C: 34
Given the following relation instance: $\begin{array}{ccc} X & Y & Z \\ \hline 1 & 4 & 2 \\ 1 & 5 & 3 \\ 1 & 6 & 3 \\ 3 & 2 & 2 \end{array}$ Which of the following functional dependencies are ... $YZ \rightarrow X \text{ and } X \rightarrow Z$ $XZ \rightarrow Y \text{ and } Y \rightarrow X$

Lakshman Patel RJIT asked in Databases Apr 2, 2020

by Lakshman Patel RJIT

460 views

0 votes

1 answer

5

NIELIT 2016 MAR Scientist C - Section C: 35
Consider the schema $R=(\text{S T U V})$ and the dependencies $ S \rightarrow T, T \rightarrow U, U \rightarrow V$, and $V \rightarrow S.$ If $R=(R1 \text{ and } R2)$ be a decomposition such that $R1 \cap R2= \phi$ ... $\text{3 NF}$ in $\text{3 NF}$ but not in $\text{2 NF}$ in both $\text{2 NF}$ and $\text{3 NF}$

Lakshman Patel RJIT asked in Databases Apr 2, 2020

by Lakshman Patel RJIT

512 views

0 votes

1 answer

6

NIELIT 2017 OCT Scientific Assistant A (IT) - Section B: 10
Which of the following is a desirable property of module? Independency Low cohesiveness High Coupling Multifunctional

Lakshman Patel RJIT asked in CO and Architecture Apr 1, 2020

by Lakshman Patel RJIT

701 views

0 votes

1 answer

7

NIELIT 2017 OCT Scientific Assistant A (CS) - Section C: 5
Which of the following is a desirable property of module? Independency Low cohesiveness High Coupling Multifunctional

Lakshman Patel RJIT asked in CO and Architecture Apr 1, 2020

by Lakshman Patel RJIT

356 views

0 votes

0 answers

8

UGC NET CSE | December 2006 | Part 2 | Question: 18
Which statement is false regarding data independence ? Hierarchical data model suffers from data independence Network model suffers from data independence Relational model suffers only from logical data independence Relational model suffers only from physical data independence

go_editor asked in Databases Mar 27, 2020

280 views

0 votes

1 answer

9

KPGCET-CSE-2019-27
The undesirable multivalued dependency in a relation arises if there exist Two one-to-many relationships between attributes of a relation One one-to-one and one one-to many one relationships between attributes within a relation Two one-to-one relationships between attributes of a relation One one-to-many relationship between attributes across relation

gatecse asked in Databases Aug 4, 2019

156 views

1 vote

4 answers

10

Madeeasy- Types of Dependencies
Please clarify along with the names.

Markzuck asked in CO and Architecture Jan 9, 2019

864 views

0 votes

2 answers

11

Data forwarding in pipelining
Data forwarding is used to avoid which type of conflict?? (1) RAW (2) WAR (3) WAW (4) RAR

Abhilash Mishra asked in CO and Architecture Jan 2, 2019

by Abhilash Mishra

1.0k views

0 votes

1 answer

12

Avoiding pipeline Hazards
Please Confirm.

smsubham asked in CO and Architecture Dec 27, 2018

377 views

0 votes

3 answers

13

NIELIT 2018-58
Consider the following functional dependencies in a database: $A \rightarrow B$ $B \rightarrow C$ $D \rightarrow E$ $E \rightarrow D$ $F \rightarrow G$ $F \rightarrow H$ $(E,F) \rightarrow I$ The relation $(E,D,A,B)$ is $2$ NF $3$ NF BCNF None of the above

Arjun asked in Databases Dec 7, 2018

by Arjun

1.7k views

0 votes

1 answer

14

Data Hazards
Find the data hazards(RAW,WAW,WAR) in the given instructions

Vishnathan asked in CO and Architecture Nov 17, 2018

766 views

0 votes

2 answers

15

Sum of Data dependencies
$I_1 : MUL \ \ \ \ \ R_1, R_2, R_3$ // $R_1 \leftarrow R_2 \times R_3$ $I_2 : ADD \ \ \ \ \ R_4, R_4, R_1$ $I_3 : MUL \ \ \ \ \ R_1, R_5, R_6$ $I_4 : SUB \ \ \ \ \ R_4, R_4, R_1$ Sum of RAW, WAR and WAW dependencies is _____.

Mk Utkarsh asked in CO and Architecture Oct 23, 2018

486 views

2 votes

1 answer

16

Pipeline : Number of RAW dependencies
Consider the below instructions executed on a 5 stage(IF,ID,EX,MA,WB) RISC pipeline with operand forwarding. I1: ADD R0,R1,R2 (R0=R1+R2) I2: SUB R3,R0,R2 I3:MUL R4,R3,R0 I4:DIV R5,R4,R0 How many RAW dependencies?

Mk Utkarsh asked in CO and Architecture Oct 23, 2018

1.7k views

0 votes

1 answer

17

Data dependancies
Anti- dependency will not ALWAYS create stall because we can use register renaming to remove stall. Please confirm below statement: Anti-dependency MAY create stall (True/False)

Suneel Padala asked in CO and Architecture Sep 23, 2018

by Suneel Padala

271 views

0 votes

0 answers

18

please solve my Q
24. Consider the following instructions. I 1 : R 1 = 100 I 2 : R 1 = R 2 + R 4 I 3 : R 2 = R 4 + 25 I 4 : R 4 = R 1 + R 3 13 I 5 : R 1 = R 1 + 30 Calculate sum of (WAR, RAW and WAW) dependencies the above instructions. (a) 10 (b) 12 (c) 6 (d) 8

kallu singh asked in CO and Architecture Sep 18, 2018

117 views

3 votes

0 answers

19

MadeEasy Test Series: CO & Architecture - Data Dependency
I'm getting 6,1,2 but the answer given is 5,1,2

charul asked in CO and Architecture Jan 7, 2018

by charul

296 views

1 vote

1 answer

20

RAW, WAR, WAW hazards
J1: R1 = 100 J2: R1 = R2 + R4 J3: R2 = R4 + 25 J4: R4 = R1 + R3 J5: R1 = R1 + 30 Give the no of RAW, WAR and WAW hazards

Tuhin Dutta asked in CO and Architecture Dec 3, 2017

1.8k views

5 votes

1 answer

21

WAR amd WAW dependency
R4 <- R1 + R4 R4 <- R2 + R4 R4 <- R3 + R5 Number of WAR and WAW dependencies?

Rajesh R asked in CO and Architecture Nov 4, 2017

673 views

0 votes

0 answers

22

Database #1NF
R(ABCDE) { A,BC,CD} are candidate key of relation R after 1 NF design which one is possible multi valued attributes before 1 NF design ???

air1ankit asked in Databases Oct 27, 2017

259 views

3 votes

1 answer

23

Number of WAR
Number of WAR dependencies possible R1 <- R3 + R2 R3 <- R3 + R5 R3 <- R2 + R3 Is it 2 or 3?

Rajesh R asked in CO and Architecture Oct 26, 2017

372 views

1 vote

2 answers

24

Database
1- R(ABCD) FD'S ARE {AB->C ,C->D,D->EA ,DE->F,EF->B} 2-R(ABCD) FDS ARE { A->BC, CD->E, B->D,E-A} 3- R(ABCD) {AB-> CD,C->B,D->C} Find the candidate key ??? For above questions and please explain too.

air1ankit asked in Databases Oct 17, 2017

337 views

Page:

Recent questions tagged data-dependency