Normalization in Relational Databases

0.0(0)
studied byStudied by 0 people
0.0(0)
linked notesView linked note
full-widthCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/4

flashcard set

Earn XP

Description and Tags

Flashcards about database normalization.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

5 Terms

1
New cards

Normalization

Organizing data in a database following specific rules to create multiple tables and establish relationships between them.

2
New cards

Data Redundancy

The presence of the same data in multiple locations within a database, leading to wasted disc space and maintenance issues.

3
New cards

First Normal Form

A form of normalization that states a database should have no repeating groups in a table, a separate table for related data, and each set identified with a key.

4
New cards

Second Normal Form

A form of normalization where all attributes depend on the entire primary key.

5
New cards

Third Normal Form

A form of normalization that states you should eliminate fields in a table that do not depend on the key.