2 added 59 characters in body
source | link

If you use only a table, how would you keep several notes? You would fail further normalisation, by having repeating attributes, and you would either need a nightmarish dynamic structure (implemented in application code, to make it worse) or an almost equally nightmarish limit on user notes.

You do not even need a surrogate key. Product number seems a decent natural key already for the product table, and a composite natural key for the notes table seem easily feasible, for instance (Product number, Entered by, Entered date).

If you use only a table, how would you keep several notes? You would fail further normalisation, by having repeating attributes, and you would either need a nightmarish dynamic structure (implemented in application code, to make it worse) or an almost equally nightmarish limit on user notes.

You do not even need a surrogate key. Product number seems a decent natural key already for the product table, and a composite natural key for the notes table seem easily feasible.

If you use only a table, how would you keep several notes? You would fail further normalisation, by having repeating attributes, and you would either need a nightmarish dynamic structure (implemented in application code, to make it worse) or an almost equally nightmarish limit on user notes.

You do not even need a surrogate key. Product number seems a decent natural key already for the product table, and a composite natural key for the notes table seem easily feasible, for instance (Product number, Entered by, Entered date).

1
source | link

If you use only a table, how would you keep several notes? You would fail further normalisation, by having repeating attributes, and you would either need a nightmarish dynamic structure (implemented in application code, to make it worse) or an almost equally nightmarish limit on user notes.

You do not even need a surrogate key. Product number seems a decent natural key already for the product table, and a composite natural key for the notes table seem easily feasible.