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.

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

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?

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

thanks for that my old pedigree chum?

muchos apreciatos

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

i think my 1st normal form is wrong i'm going to take a lok at it again.

sorry for bothering any of you.

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