Normalisation Flashcards

You may prefer our related Brainscape-certified flashcards:
1
Q

Normalizing to 1NF

A
• Each row is unique - it has a primary key
• Each column has a unique
name
• No columns with similar or
repeated data (i.e. choice1,
choice2 etc.)
• Each data item cannot be
broken up any further - no
commas in the data
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Normalizing to 2NF

A

• 1NF
• If the primary key is a
composite of attributes (contains multiple columns), the non-key attributes (columns) must depend
on the whole key.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Normalizing to 3NF

A
  • 1NF
  • 2NF
  • There are no non-key attributes that depend on other non-key attributes
How well did you know this?
1
Not at all
2
3
4
5
Perfectly