1,258 views

2 Answers

1 1 vote

every time a appears it is matched with same value of B

A     B

1       2

5        6 so if here A =1 is inserted B will be 2 only...

this implies that A->B( as per rule of FD)

and it is said that A is not matched with the same value of C

this mean for same A there can be many different values for C

eg:

A    C

1       2

5        6

1        3

1        4

this is the concept of MD

so A>>C

option B IS THE ANS

• edited by
Position:
Show:

Related questions

14 14 votes
5 5 answers
12.3k
12.3k views
go_editor asked Jul 1, 2016
12,270 views
Consider the following tableThe table is in which normal form?First Normal FormSecond Normal FormThird Normal Form but not BCNFThird Normal Form and BCNF
6 6 votes
2 answers 2 answers
10.8k
10.8k views
Anu asked Jun 28, 2016
10,780 views
An aggregation association is drawn using which symbol?A line which loops back on to the same tableA small open diamond at the end of a line connecting two tablesA small ...
8 8 votes
2 answers 2 answers
6.0k
6.0k views
ajit asked Sep 23, 2015
6,021 views
Let $x,y,z,a,b,c$ be the attributes of an entity set E. If $\{x\} ,\{x,y\}, \{a,b\},\{a,b,c\}, \{x,y,z\}$ are superkeys then which of the following are the candidate keys...
8 8 votes
4 answers 4 answers
8.4k
8.4k views
Nivetha Ravichandran asked Sep 21, 2015
8,354 views
Consider the schema $R (A, B, C, D)$ and the functional dependencies $A\to B$ and $C\to D$. If the decomposition is made as $R_1(A, B)$ and $R_2 (C, D)$, then which of t...