Hello,
I have a table that has two ID field, one is primary and the other one has duplicates.
I think this table can be made into two as the better database design standard, however I am not sure.
This is an example of how the table looks.
Is this table fine the way it is or it would be more optimal if I break them into two tables as below,
and can you tell me why so.
IDa is unique, IDb is duplicates base on the Fruits field.
Please advise ! Thx