I am studying a web development diploma on the Internet, and I just started developing and developing a database. I thought I understood Normal Forms, but I just asked a question that stopped me on my tracks.
Have a look at the following list of attributes for a client object:
Customer(cus_ID, name, address, mobile_phone)
Why is this object not in 3NF?
As far as I can tell, this is at 3NF. All attributes would not be there if it were not for the client, the name, address and mobile datasets require the client to exist.
I just understood the whole concept of 3NF?
source
share