Why is this table not normalized?

I am taking a database course, and I am studying table normalization.

enter image description here

Can someone explain to me why the second table in the first row on the right is not normalized?

+4
source share
4 answers

, , , : 23 CS101 B +
23 B102 C +
, ( ). (, , ).
:
, , , , .


, .
, id, name and DOB , id .
, 1NF, 2NF, 3NF .. , . , .

+2

, . , , .

student_name , students student_id (- , .).

0

, id, student_name ( ), (, id) . (name) , id.

3NF , ", ", ", Codd"!

.

0

23 - j.smith

Codd 1

-1
source

Source: https://habr.com/ru/post/1610892/


All Articles