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