Quote:
Is this the correct way of doing the relationships?
It all depends on the requirements. One way is to try to read out the relationships in natural language. Based on your design, it says
Quote:
each product is made by only one distinct manufacturer, and belongs to only one distinct category.
Does that correctly depict the requirements?
For example:
manufacturer table product table category table
manufacturer_id (PK) +--< manufacturer_id (FK) ...
manufacturer_name product_id (PK) category_name (FK)
... category_id (FK) >---+ category_id (PK)
... ...