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?