7.   Given the Tables Below, Match them with the normalized form (NOT in 1NF, 1NF, 2NF, 3NF, BCDNF, 4NF, 5NF) they are in:

 

__2__ Table A

__4__ Table B

__5__ Table C

__2__ Table D

__3__ Table E

 

 

 1.   Not in Normal Form

 2.   1NF

 3.   2NF

 4.   3NF

 5.   BCNF

 6.   4NF

 7.   5NF

 

Notes: 

 

TABLE A still has partial dependencies

TABLE B has Editing Anomolies

TABLE E has Transitive dependencies