Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2007
    Posts
    9

    Functional dependencies

    If I have R<A,B,C,D,E,F,G,H>, with A->BDE, G->CB, CF->H and if I'm asked to find
    1. a canonical "covering" (I don't know the exact term, I hope this is clear enough)
    2. all keys
    3. which functional dependencies violate the 3NF
    4. normalize the schema to 3NF,

    how do I find the canonical "covering"? And only after this, can I proceed to find all keys?

  2. #2
    Join Date
    Jul 2007
    Posts
    9
    Ok, I think the canonical "covering" is simply A->B, A->D, A->E, G->C, G->B, CF->H. And the key simply AFG. Am I right?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •