Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2005
    Posts
    1

    Urgent Normalisation help..

    hi, i would be grateful if i could have your opinions on how this set of data can be normalised to 3rd normal form. thanks.


    Payment Date
    Payee
    Fee
    Deductions
    Payment method
    Net payment


    cheers!

  2. #2
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    The information you are providing is inadequate.

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Ask your teacher, that's what they're paid for.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  4. #4
    Join Date
    Aug 2004
    Posts
    330
    A good start would be to identify the ENTITIES and the ATTRIBUTES. Identify the candidate primary KEYS for each entity and a detailed definition of each entity and attribute. This will help identify what the dependencies are.

  5. #5
    Join Date
    Jan 2006
    Posts
    20
    I keep seeing these questions all over this forum, so I will answer it this one time:


    1. Teachers are there to help. If you go to a big university, talk to the teaching assistant. This should be obvious knowledge.

    2. You have a connection to the internet. Start using it. It isn't hard to come up with search terms, so try expending SOME energy:

    Database Introduction
    Normalization
    MySQL manual
    Oracle manual

    Those took me a whole half second to think up.

    3. If you aren't getting the info you need, look at (ohmigawd I'm gonna say it) the COURSE BOOK. You paid for it. If it's a poor book, you are also paying for the campus library, so go there. If they don't have it, buy another book.


    I am using 8 books, 3 online manuals, the MSDN library, random webpages, this forum, and old college class material for the project I'm currently working on. Don't think you have exhausted your resources.

Posting Permissions

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