0 Replies - 3356 Views - Last Post: 10 October 2012 - 02:16 PM Rate Topic: ***-- 2 Votes

#1 satislikev   User is offline

  • New D.I.C Head

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

Functional dependency and normalization

Posted 10 October 2012 - 02:16 PM

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