.... 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.
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.
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.