Database design and Normalization I have a question regarding database table design.

I have a product master table which has all the details of a product.

User would be adding notes against each product (product number) and for each product there would be multiple notes.

Proposed columns for notes against product.

Subject
Description
Entered BY
Updated By
Entered Date
Updated Date.


Should I create two tables, one to keep the product no and another table to keep the notes and the other columns or one table to keep the product no and other columns?
Two tables, Product and Product Notes. Link them by ProductId, primary key of your Product table.