Normal Form Flashcards
1
Q
What is Normalisation
A
Normalisation is the process of coming up with the best possible layout for a relational database.
2
Q
What is First Normal Form
A
- All fields names must be unique
- Values in fields should be from the same domain
- Values in fields should be atomic
- No two records may be identical
- Every table must have a primary key
Atomic = each field having only one item of data
3
Q
Second Normal Form
A
- The data must already be in 1NF
- Remove any partial dependencies
- Fix any M:M relationship created as a result
4
Q
Third Normal Form
A
If the database is in second normal form and contain no non-key dependencies, it is in third normal form. Meaning the attributes only depends on the value of the primary key and nothing else.
4
Q
Third Normal Form
A
- The data must already be in 2NF
- Remove any transitive dependcies (In other words, ensure that non-key fields are not dependent on each other.
5
Q
A