Functional dependency and normalization

Page 1 of 1

0 Replies - 2678 Views - Last Post: 10 October 2012 - 02:16 PMRate Topic: 2 Votes //<![CDATA[ rating = new ipb.rating( 'topic_rate_', { url: 'http://www.dreamincode.net/forums/index.php?app=forums&module=ajax&section=topics&do=rateTopic&t=295112&amp;s=bc39fdf91c1aa7612ff038418cca6f44&md5check=' + ipb.vars['secure_hash'], cur_rating: 3, rated: 0, allow_rate: 0, multi_rate: 1, show_rate_text: true } ); //]]>

#1 satislikev

Reputation: 0
• Posts: 12
• Joined: 25-November 09

Functional dependency and normalization

Posted 10 October 2012 - 02:16 PM

Hello.
I'm studying database and there is something that is unclear for me if we have R1(A,B,C), R2(B,D) and we have functional dependencies as A→B, A→C, B→A, and A→D and those that can be derived from these functions. Is it possible for this schema to be BCNF?
I mean this schema is decomposition of a major relation. but how we can found the first relation and how is possible to find out if this one is decomposed by BCNF?
Also i see the link between R1 and R2 is A→D, and i can derive A→BC and AB is key, can someone help me understand this better?
Thank you.

Is This A Good Question/Topic? 0

Page 1 of 1

 .related ul{list-style-type:circle;font-size:12px;font-weight:bold;}.related li{margin-bottom:5px;background-position:left 7px!important;margin-left:-35px;}.related h2{font-size:18px;font-weight:bold;}.related a{color:blue;}