data normalisation

0.0(0)
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Get a hint
Hint

1NF (3)

Get a hint
Hint
  • contain atomic values

  • have no repeating groups

  • have a unique identifier (primary key)

Get a hint
Hint

2NF (4)

Get a hint
Hint
  • meet 1NF requirements

  • only apply to tables with a compound primary key

  • have full functional dependency (non-prime attributes being fully dependent on the primary key)

  • have no partial dependencies (non-prime attributes cannot depend on only part of a primary key, separate tables should be created if they do)

Card Sorting

1/3

Anonymous user
Anonymous user
flashcard set

Earn XP

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

4 Terms

1
New cards

1NF (3)

  • contain atomic values

  • have no repeating groups

  • have a unique identifier (primary key)

2
New cards

2NF (4)

  • meet 1NF requirements

  • only apply to tables with a compound primary key

  • have full functional dependency (non-prime attributes being fully dependent on the primary key)

  • have no partial dependencies (non-prime attributes cannot depend on only part of a primary key, separate tables should be created if they do)

3
New cards

3NF (2)

  • meet all 2NF requirements

  • have no transitive dependencies (non-prime attributes cannot depend on other non-prime attributes, only the primary key) - create a separate table and use a foreign key

4
New cards

holder

holder