New Table Design

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 402,471 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,966 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Database Design advertiser: Programming Forums

New Table Design

•

Join Date: Jan 2006

Posts: 1

Reputation: bridget is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

bridget

Offline

Newbie Poster

New Table Design

Jan 14th, 2006

Hi,
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.