Search   Home| Exercises:  Database - Database Types - Normalisation - 1NF - 2NF - 4NF-7NF 

Theory

Exercises

Web Links

Downloads

Discussion

Contact

Glossary

Click on the answer you think is correct.

          1. How is the term Third Normal Form abbreviated?
a)  3NormForm
b)  3NF
c)  3rdNF
d)
  NF3

          2. What is meant by 'consolidation'?
a)  joining all the tables from the Normalisation process together
b) 
adding a new table to a database
c) 
joining 2 tables together

          3. How can a M:N relationship be overcome?
a)  add another key to the table
b) 
delete one of the tables
c) 
add a linking (or intersecting) table

          4. If 3NF is completed, does it mean that 2NF process becomes redundant?
a)  Yes – 3NF automatically resolves 2NF issues
b) 
3NF is more important than 2NF
c) 
2NF is a primary state and covers 3NF
d) 
Only if form is already in 2NF state

            5. Is the following table in 3NF form?

a)  Yes
b)  No
c)  Yes but requires 2NF to be completed
d)  Yes – but requires addition of Customers for completeness.

Other Normal Forms Exercise>>>