Tag Info

New answers tagged


There could be many way possible to store data for such scenario, as with your design attempt it seems that you are looking to have unique Id to identify each product and if that is the case the you are right with having a productstable and make that product_id an auto increment key. Now the next thing to make sure that what ever the attributes of all these ...


Generally, it's better practice to encapsulate the data as you did in your second approach. This is because... When a fully normalized database structure is extended to allow it to accommodate new types of data, the pre-existing aspects of the database structure can remain largely or entirely unchanged. As a result, applications interacting with the ...

Top 50 recent answers are included