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

Report this post to a moderator

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

__________________
"I was planning to take over the world, but got distracted by something sparkly..."

Report this post to a moderator

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?

Report this post to a moderator

I would put them all together and then normalize.

__________________
"I was planning to take over the world, but got distracted by something sparkly..."

Report this post to a moderator