I created 2 tables :
- "category": contains product types
- "product": contains products details such as product ID, product name, etc.

In product table, I have 7 columns that are:

- proID: contains a unique number for each product in the table.
- proName: contains a name of a product.
- proDes: contains full description of the product.
- price: contains the product's current price.
- image: contains a path to the picture of the product.
- catID: contains the category of the product.
- status : check the product is still in stock or temporarily out of stock.
In category table, there are 2 columns :
- catID: contains a unique number for each product type.
- catName: contains a name of a product type.
Relationship entity between category table and product table: