|
|
|
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 >>>
|
|
