Results 1 to 3 of 3

Thread: Databases - Normalizing relations

  1. #1
    Join Date
    Nov 2012
    Beans
    43

    Databases - Normalizing relations

    Hello. Can someone please explain step by step how to normalize the following relation.

    Relation: R(ABCDEFG)
    Functional dependencies: F = {ABC -> DEFG, AB -> DFG, B -> EF}
    Assumed primary key: A (I'm not sure what is meant by this.)

    Please find the first(By expanding the primary key), second, and third normal forms. Please explain as much as possible.

    I genuinely want to learn how to solve these kinds of problems. Don't tell me you won't do my homework; IT IS NOT HOMEWORK. You either believe me and help me or don't help me and I don't learn.

  2. #2
    Join Date
    Jan 2006
    Location
    Not heaven... Iowa
    Beans
    Hidden!
    Distro
    Ubuntu

    Re: Databases - Normalizing relations

    Closed for review.
    Last edited by Iowan; April 14th, 2014 at 09:26 PM.
    Linux User #415691 Ubuntu User #8629
    Iowa Team (LoCo): [Wiki] [Launchpad]
    IRC channel: #ubuntu-us-ia on irc.freenode.net

  3. #3
    Join Date
    Jan 2006
    Location
    Not heaven... Iowa
    Beans
    Hidden!
    Distro
    Ubuntu

    Re: Databases - Normalizing relations

    Re-opened.
    Linux User #415691 Ubuntu User #8629
    Iowa Team (LoCo): [Wiki] [Launchpad]
    IRC channel: #ubuntu-us-ia on irc.freenode.net

Bookmarks

Posting Permissions

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