3nf databases

Question 1

What is a flat file

Answer 1

allows the user to specify data attributes for only one table at a time

Question 2

what is a relational database

Answer 2

takes the flat file further by allowing the user to specify information about multiple tables and the relationship between the tables

Question 3

How many normal forms are there

Answer 3

there are 3, 1nf 2nf 3nf

Question 4

How to get to 1NF

Answer 4

remove duplicate columns
remove any groups or repeating data
separate any attributes which are not “Atomic”

Question 5

How to get to 2NF

Answer 5

Check that table is already in 1NF
remove any partial dependencies
fix any many to many relationships

Question 6

How o get to 3NF

Answer 6

Check that t is already in 2NF

Check that there are no non-key dependencies