New Ordering System!

[amaconline]

Hello guys, I am designing a database for a small business. It is a simple database that can be used to record products, orders and stock level. I am using the universal ERD model (customer --< order --< OrderLine >--- Products). In my analysis I realised that product(s) fall under three different categories.

There are altogether 5 main products in the business. These five can be further divided into several other categories. For example:

MainProduct1
MainProduct2
MainProduct3


MainProduct4
MainProduct5

If I now take MainProduct1, it can be divided into further 8 SubProduct and the SubProduct can also be divided into types, example:

MainProduct1 --< SubProduct1 --< SubProductType1 --< SubProductType2 --< FurtherDescription

Now, I am thinking of having four more tables linked to tblProduct to hold these product related information separately. Example:

tblProduct --< tblSubProduct --< tblProductType1 --< tblProductType2 --< tblProductDescription

My question is, how accurate is it?
Shall I just stick to the universal ordering system design and put extra fields to gather information about each product or do you think it is better to have additional tables?

Thanks a lot.

[orange]

You may find this site useful

http://allenbrowne.com/AppInventory.html

[amaconline]

Hey Thank you. I was looking for a solution for stock control. However, I need to understand whether I should record all the information on one single table or create sub tables to collect information that are related to each product...