Creating Tables

[jjones100]

I am wondering which design would be better for my new tables. In the past I have just had one table with ALOT of fields. I am creating a new db and am wondering if I should split the info into multiple tables. I have a ckt id field that all other fields relate to, such as customer address, ckt type, service type etc. I screen scrape information from a mainframe to populate my fields. The join would be the ckt id(obviously this would be a dup in each table), but i am wondering what the benefit of multiple tables would be. Less corruption, better performance? Thanks

 

[PHV]

I have a ckt id field that all other fields relate to
Are the other fields all populated in every row ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jjones100]

Not ever record has every field populated. It depends on the ckt type. I am just debating having to open several tables for the screen scraping and having all of those joins.

 

[PHV]

It depends on the ckt type
Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jjones100]

Will do. Thanks!