Hi

I am trying to normalise a 'zoo' Acccess database.

The UnNormalised table has the following
ZooId (PK)
Animals
Name
Sex
DOB
Age
Diet
Order
family
Genus
Species
Classification
Vertebrate
Section
Continent
Origin
Habitats


My First Normal Form is:
Zoo (table)
ZooID (PK)
Animal (lion, tiger, etc)

Animal (table)
AnimalID (PK)
Animal
OrderID
FamilyID
GenusID
SpeciesID
ClassID
Vertebrate (Y/N)
Diet

Order_
OrderID
Order
FamilyID
Family
GenusID
Genus
SpeciesID
Species
ClassID
Class

Name (table)
ZooID (FK)
Name (Pumba, Timon, etc)
Sex (Male/female)
Age

Relationships:

Zoo(table) Linked Type(table) Animal(table) Habitat(table) Name (table)
ZooID (PK)------> ZooID
AnimalID-----> AnimalID -----> AnimalID

ZooID ------------------------------------> ZooID

Is this a good design??
What changes could be suggested??

What changes to made a Second Normal Form?????

I would appreciate any advice!!!

Clive