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

Click on the answer you think is correct.

1. How is the term Second Normal Form abbreviated?

a) 2NormForm
b) 2NF
c) 2ndNF
d) NF2

2. What is the aim of Second Normal Form.

a) To remove non-key attributes that only depend on part of the key, to form a new table.
b) To remove non-key attributes that are dependant on other non-key attributes.
c) To remove repeating groups

3. Which of the following tables in is Second Normal Form. (Click on the title TABLE A or TABLE B)

TABLE A
Cust ID	Surname	First Name	Address	Town	County	Postcode
1	Coleman	Jo	22 Green St	Bootle	Merseyside	L15 1AA
2	George	Dave	33 Brown Rd	Preston	Lancashire	PR1 1BB
3	Laidler	Greg	44 White Ave	Bootle	Merseyside	L15 1CC
4	Owen	Andy	55 Blue Crest	Preston	Lancashire	PR1 1DD

TABLE B
Cust ID	Surname	First Name	Address	Postcode
1	Coleman	Jo	22 Green St	L15 1AA
2	George	Dave	33 Brown Rd	PR1 1BB
3	Laidler	Greg	44 White Ave	L15 1CC
4	Owen	Andy	55 Blue Crest	PR1 1DD

Third Normal Form Exercise >>>