I am new to db admin and would appreciate some help with a design issue.
We currently have 3 applications all with their own DB which all contain a product table. It is different in all 3 DB's and I need to replace all 3 with one enterprise wise table. This table has around 300 fields in it which when analysed fall into about 8 logical groups. Would it be better design practice to break this table up into 8 smaller tables with the product code as the key in each?
Like I said, I am very new to this and want to do it right.
Thanks for any help.