Cs Revision / Notion > databases normalisation > Flashcards
characteristics of first normal form
data is atomic , and has a primary key
characteristis of second normal form
already in 1nf and every field is dependent on the primary key
characteristics of 3rd normal form
it is already in 2nf and contains no attributes that depend on another attribute in the table (apart from the primary key)