Results 1 to 8 of 8

Thread: normalisation

  1. #1
    Join Date
    Feb 2004
    Posts
    78

    normalisation

    i really hate normalisation!!!!!!!!!!!!!........


    .... and have an assignment to do where i have to normalise quite a complex datasheet. in all the tutorials and websites i have looked at i have only seen examples of very simple datasheets being normalised.

    does anyone know of any more complex examples or has anyone done any complex normalisation to BCNF that i could take a look at.

    any advise or support would be greatfully recieved.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Any complex thing is actually just a collection of simple things. Take the concepts of the simple examples that you can find, and use those concepts on the more massive project. Like any application of technology, a "divide and conquer" approach works well, and may be your only practical answer in many cases.

    -PatP

  3. #3
    Join Date
    Feb 2004
    Posts
    78

    thanks for that

    i've already thought about that. but thanks anyway.


    just a quick question about normalisation. i f a have 2 seperate tables from the same scenario and i want to normalise them down to BCNF can i take each in turn and then normalise down to BCNF or would i have to normalise them together?

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    You have to reduce (aka factor) the tables separately.

    The only "gotcha" that comes to mind there is to watch for two different tables that spin off the same columns into two other tables. For example, if you spin address columns out of your client, and address columns out of your invoice, at least in most cases the address columns should form one table referenced by both client and invoice instead of a client_address and an invoice_address table.

    -PatP

  5. #5
    Join Date
    Feb 2004
    Posts
    78
    thanks for that my old pedigree chum?

    muchos apreciatos

  6. #6
    Join Date
    Feb 2004
    Posts
    78

    normalisation HELP!!!!!!!!!!

    hi peeps i have had a go at normalising the scenario in my assignment( attached). please can someone take a look at it and tell me where i am going wrong i am having problems going from 2nd to 3rd normal form.

    we were given the scenario and the UNF
    Attached Files Attached Files

  7. #7
    Join Date
    Feb 2004
    Posts
    78
    i think my 1st normal form is wrong i'm going to take a lok at it again.

    sorry for bothering any of you.

  8. #8
    Join Date
    Feb 2004
    Posts
    78
    hi i would like to show this to you stage by stage . here is my 1st normal form . could any one check it for me and see if it;s correct.


    1st Normal Form

    Paper table
    -----------
    Paper No (PK)
    Paper Title
    Decision
    Topic

    Author table
    ------------
    Author_id (PK)
    Author’s Name
    Email
    Phone

    Review_results table
    -------------------
    Review_id (PK)
    Reviewer’s Name
    Relevance
    Originality
    Technical Merit
    Overall Mark

    Manuscript table
    ------------------
    Manuscript_no(PK)
    Copyright OK
    Received OK
    Length OK
    Format OK

Posting Permissions

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