|
Home > Archive > General Discussion > October 2004 > normalisation
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| DOS on NOS 2004-10-20, 2:26 pm |
| i'm creating a relational database and i have to normalise 4 different forms for the database. Do i normalise each form seperatly? Or do normalise all the forms as one?????
also i need a program to use to draw diagrams such as DFD's and ERD's and stuff like that... | |
|
| You would normalize 4 different forms of the database because each particular normal form satisfies a certain set of constraints. (1NF, 2NF, 3NF, etc).
In other words, put your relational database in first normal form, then put it in second, then third, then boyce/codd if your book diferentiates between 3NF and BCNF.
Good luck | |
| DOS on NOS 2004-10-21, 3:29 pm |
| ummm i don't mean 1st normal form 2nd normal form bcnf etc
i mean i have 4 forms such as a public building inspection form, a complaints form, a industrial building inpsection form and an investigation form.
do i normalise each form sepereatlyy or put all of them together and normalise all at once? | |
|
| I would put them all together and then normalize. |
|
|
|
|