Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2012
    Posts
    1

    Normalization Table Help

    im trying to normalize all these tables.i dont quite understand how to normalize it.can someone please check for me and correct me if im wrong.
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    tip: forget the lines for a while, until you have nailed down the FKs

    after that, you can draw the lines easily

    but the main step is determining your PKs, followed immediately by your FKs

    the trick to doing it is really simply -- the FK always goes in the "many" table of a one-to-many relationship, and the FK always refers to the "one" table's PK

    i think if you look at your student payment table, you'll see an error in this regard
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Tags for this Thread

Posting Permissions

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