User Name Password Register
DaniWeb IT Discussion Community
All
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 426,332 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,397 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.
Please support our Database Design advertiser: Programming Forums

New Table Design

Join Date: Jul 2005
Location: Dallas, TX
Posts: 481
Reputation: campkev is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 19
campkev campkev is offline Offline
Posting Pro in Training

Re: New Table Design

  #2  
Jan 23rd, 2006
on the surface, three hundred fields sounds like a lot, but it depends on the data involved, Does every product have one and only one entry in every column? if so, then your table is fine. if not you need to break it down.
if you are merging 3 different databases, i'm betting that there will be some fields that are exclusively going to be used by certain product types, those need to be in different tables.
You might want to get a intro to database design book as well.
Reply With Quote  
All times are GMT -4. The time now is 11:19 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC