I am modeling an e-commerce related database and am having a question in modeling product category and subcategory tables.
At first I created two tables one of Categoria
and another of Subcategoria
. However, I found a article where the author says do not need to create two tables . What it basically does is in the same table include the category code in the record that will be a subcategory.
What are the advantages of making a template with two tables or one as mentioned in the article?