Grasping Relational Table layout MySQL PHP
I have been studying Kevin Yanks book and find it very good for a complete beginer like myself but I am a bit confused on mapping out my database.
I am creating a database of North American birds.
The birds are classified into first a Top Category
then into a Group Category and lastly into a Member Category.
This is an excercise so I dont mind that its going to be a fairly large task but it seems that there should be an easier way than what I am contemplating.
It appears that I would have to create and populate the tables
Top Category (ID, Name)
Group Category (ID, Name)
Member Category (ID, Name, Sci-name, Desc, ...)
Look up Table (TCID, GCID, MCID)
I have 15 Top Categories
Around 80 Group Categoris
and hundreds of Member Categoris
I was thinking I could build a form input that could enter the values of all the tables simultaneously but I dont see any mention of that.
Is there a smart way to do what I am planing above.
Thanks very much for your help