3nf databases Flashcards
1
Q
What is a flat file
A
allows the user to specify data attributes for only one table at a time
2
Q
what is a relational database
A
takes the flat file further by allowing the user to specify information about multiple tables and the relationship between the tables
3
Q
How many normal forms are there
A
there are 3, 1nf 2nf 3nf
4
Q
How to get to 1NF
A
remove duplicate columns
remove any groups or repeating data
separate any attributes which are not “Atomic”
5
Q
How to get to 2NF
A
Check that table is already in 1NF
remove any partial dependencies
fix any many to many relationships
6
Q
How o get to 3NF
A
Check that t is already in 2NF
Check that there are no non-key dependencies
