oh is it. thanks for the information. i only learned up to 4NF. so thats y. anyway thanks.

is it non trival FD ?

true. need to know all the fields in that table so then can tell what should split

there are three type of normal forms

First normal form ( 1NF)
second normal form (2NF)
third normal form (3NF)

this comes in normalisation

nomalisation theory is based on the observation that relations with certain properties are more effective in inserting, updating and deleting data than other sets of...

i will read this tomorrow. i have Normalisation so that i can get a good idea about it after talking here. so tomorrow ill tell what my idea is about this thread. thanks..

if you can describe more about the question. i can give a good answer

i wil try to do this and put it in here soon

wow. this gives more info about ER. even im learning about it. thanks a lot