582 views
3 votes
3 votes

A prime attribute can be intransitively dependent on a key in a 3NF relation.
True / False 
Pls. Do Explain what does intransitivity actually mean here.

2 Answers

1 votes
1 votes

I think it is TRUE

Because, intransitivity means A -> B , B -> C but A should not gives C

From the given Question if A is a key, and C is a prime attribute  and B is non key

 3NF follows 2 conditions

Key --> anything

anything --> Prime attribute

A -> B (3NF because A is key)

B -> C (3NF because C is prime attribute)

and there must be no relation of A--> C. hence A and C are intransitive.

But still it follows 3NF properties, Hence the statement is true.

Related questions

2 votes
2 votes
2 answers
2
gatecrack asked Dec 10, 2018
581 views
Is minimal set of functional dependency for a functional dependency set is always unique???
0 votes
0 votes
1 answer
3
Raghav Khajuria asked Oct 5, 2018
882 views
Difference between composite and compound key??
1 votes
1 votes
0 answers
4
iarnav asked Nov 24, 2017
738 views
consider:T1: {A11, A12, A13} - key is A11T2: {A21, A22, A11} - key is A21T3: {A21, A23} - key is {A21 A23}T1, T2, T3 all are in which normal form? a) 2nfb) 3nfc) BCNFFUNC...