Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2006
    Posts
    1

    Normalization Question

    Good evening to all,

    Quick question. Let's say I have the following schema:

    R(A,B,C,D)

    with FDs:
    A->B
    B->C
    C->D
    D->A
    AB->C

    Question 1:
    Would the candidate keys be CK{A,B,C,D,AB}

    Question 2:
    Would the normal form be BCNF since every determinant is a CK?

    Thanks everyone!

    TJ

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    homework alert!!

    TJ, we don't do homework assignments, sorry

    also, hardly anybody here knows what the heck you're talking about
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Oct 2006
    Posts
    9
    you can get kick out of school for that

  4. #4
    Join Date
    Oct 2006
    Posts
    7
    yeah, BCNF is okay.

  5. #5
    Join Date
    Sep 2006
    Posts
    20

    check this out

    Quote Originally Posted by macdaddy74
    Would the candidate keys be CK{A,B,C,D,AB}
    dont u think {A,B} and {AB} are one and the same? how come uve included both?

Posting Permissions

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