So the detail is I am developing bookshop system, so I have two tables that have relation with my project. First one is table book which has price attribute, same goes with table stationary and it has price attribute too so my question is since both of them have price attribute inside it so they will be foreign key right? and should I create price attribute for book table as BookPrice while stationary StationaryPrice?
I am expecting for suggestion of my book and stationary table for prices attributes
if there are same columns in both the tables, then it is not good idea to have two different tables. Simply create a single table with the extra column for the product category. If this does not solve your problem, share the table descriptions so that we can figure out the actual problem.