Create tables and their relationship entities

Using Microsoft Access as tool to input data entry.
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.

Product Data entries:


In category table, there are 2 columns :

• catID: contains a unique number for each product type.
• catName: contains a name of a product type.

Category Data entries:



Relationship entity between category table and product table: