943,955 Members | Top Members by Rank

Ad:
Nov 13th, 2007
0

Is this a correct decomposition (functional dependency question)?

Expand Post »
I have this relation:

R(A,B,C,D,E,G)
F = { AB -> C
AC -> D
AD -> E
B -> D
BC -> A
E -> G }

I need to project the original relation's functional dependencies onto the decomposed relations below. My question is, can I say that R3 carries E->G even though E->G is a deducted functional dependency based on a rule carried by R2? (AD->E)
And if so, is it correct to say that the key for R3 is A, D?

Or that.... no original FDs can pe projected onto R3 (since AD->E is not in THIS relation) and the key is ADG?


R1 (A, B, C) --- AB ->C, BC -> A
R2 (A, C, D, E) --- AC ->D, AD ->E
R3 (A, D, G) – AD->E (given) so E->G (transitive rule)
Last edited by Ratte; Nov 13th, 2007 at 1:00 pm.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Light Poster
Ratte is offline Offline
38 posts
since Oct 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Database Design Forum Timeline: Database Conceptual & Logical Design
Next Thread in Database Design Forum Timeline: SQL Books





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC