I thought I understood normal forms

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?

+4
source share
4 answers

, , . 3NF, ( , ):

  • .

  • , , .

  • , .

  • - . , , , / ( Telco).

  • , , , ( , ).

: , @philipxy : " - , ".

+5

.

+2

, , . " ? ?" "? - , , --- ..? - (, , - , , - - ?)?

0

. , 3NF, : " , , 3NF ". , 3FN .

, , -:

, , ?

, .

, , , , , , 3NF , .

0

All Articles