Results 1 to 15 of 15

Thread: is this correct

  1. #1
    Join Date
    Feb 2004
    Posts
    78

    is this correct

    hi

    i am new to normalisation

    i have normalised the attached document from unf to boyce codd NF can n e 1 tell me whether i have done it correctly

  2. #2
    Join Date
    Feb 2004
    Posts
    78
    and here is the document........................
    Attached Files Attached Files

  3. #3
    Join Date
    Feb 2004
    Posts
    78
    sorry people i've looked at the above one and i think it is wrong i have now changed it to this. Is this correct?
    Attached Files Attached Files

  4. #4
    Join Date
    Feb 2004
    Posts
    78
    please some one help me i am desperate to know whether i am doing this right- so that i can get on with the rest of my work

  5. #5
    Join Date
    Feb 2004
    Posts
    78
    HELLLLLLLLLLOOOOOOOOOOOOOOO is n e 1 going to answer me

  6. #6
    Join Date
    Mar 2004
    Posts
    30
    Originally posted by evilz35
    HELLLLLLLLLLOOOOOOOOOOOOOOO is n e 1 going to answer me
    Here's my version of the third normal form of your original document.

    I didn't notice the later version as it wasn't referenced on the post that your private mail pointed to.

    If you're being utterly rigorous, you should also exclude the city from the address as it's derivable from the postcode, but probably only specialised mailing systems would go this far.
    Attached Files Attached Files

  7. #7
    Join Date
    Mar 2004
    Posts
    30
    Originally posted by evilz35
    HELLLLLLLLLLOOOOOOOOOOOOOOO is n e 1 going to answer me
    Sorry, I left off the 'Cpacity' column from the third table. Here's a corrected version.
    Attached Files Attached Files

  8. #8
    Join Date
    Feb 2004
    Posts
    78
    thank you i really appreciate it- but i think i had made a few errors of my own in the staff table is this correct. i have done it all the way to 3rd normal form


    thanks for this simonw
    Attached Files Attached Files

  9. #9
    Join Date
    Feb 2004
    Posts
    78
    does n e 1 know if the above is correct?

  10. #10
    Join Date
    Mar 2004
    Posts
    30
    No, it's not. You've got duplicate rows in your Vehreg table and you haven't factored out Make, Model and Cpacity. I suggest you take a closer look at my reply.

  11. #11
    Join Date
    Feb 2004
    Posts
    78

    Cool

    Originally posted by SimonW
    No, it's not. You've got duplicate rows in your Vehreg table and you haven't factored out Make, Model and Cpacity. I suggest you take a closer look at my reply.
    thanks simonw i am really greatful for your help this is really helping me.

    could you take a look at this one as well for me. again i hae done it all down to boyce codd NF and would just like it checked. i would realy appreciate it if you could.

  12. #12
    Join Date
    Feb 2004
    Posts
    78
    sorry i keep forgeting to attach the file- here it is
    Attached Files Attached Files

  13. #13
    Join Date
    Mar 2004
    Posts
    30
    Sorry, there isn't really enough information about the business model to say - eg. what exactly is the relationship between staff members and vehicles? Is it always one to one as you've shown? Seems unlikely that someone wouldn't drive a different car if the need arose.

    Here's a document I wrote a while ago with a good example in it. (Ignore the stuff about the associative model.)
    Attached Files Attached Files

  14. #14
    Join Date
    Feb 2004
    Posts
    78
    thanks for that - sorry i wasn't clear about the staff members. the deal with that is . some staff members are car owners and some car owners own more than one car. thatk sfor the document it has helped quite abit especially with my third normal form.

  15. #15
    Join Date
    Feb 2004
    Posts
    78
    after reading you document my normalisation for my table2.doc is correct! ( yipppeeee) can you double check that though please ,just to make sure of that?

Posting Permissions

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