Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2016
    Posts
    2

    Unanswered: Normalisation Help!

    I am new to Normalisation and I can't seem to get my head around it.

    Can Someone help me with this:

    I need to make this UNF in to 1NF,2NF and 3NF as well as adding the resulting entities.
    After I have Normalised i then need to create a partial ER Diagram of the Normalised Form.
    I also have attached the image of some data in the table....


    THE UNF IS CURRENTLY:

    Session Date
    School Session
    Start Time
    End Time
    Student Name
    Attended
    Actual Hours
    Total Cost
    Transport
    Notes

    If Someone can help it would be massive help

    Thanks
    Attached Thumbnails Attached Thumbnails Normalisation.png  

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so what effort have you made so far
    what do you not understand
    on top of your other reading materials haeva look at:-
    http://r937.com/relational.html
    http://www.informationqualitysolutio...tionPoster.pdf
    http://www.tonymarston.net/php-mysql/index.html
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Feb 2016
    Posts
    2
    Thanks for the response

    I have tried to normalised the form myself but am unsure if it is correct, could you please have a look for me and see if I have made errors

    THANKS Again
    Attached Thumbnails Attached Thumbnails Screen Shot 2016-02-29 at 14.34.54.png  

Posting Permissions

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