troubleshooting Question

Question about database design Repeating vaues of foreign keys?

Avatar of bedevi
bedeviFlag for Turkey asked on
Microsoft SQL Server
7 Comments2 Solutions282 ViewsLast Modified:

I have a MSSQL database where I have a customers table which has 35 columns (tried to make data types as good as possible for performance issues)

Now I need to add 30 more fields to hold extra info about customers (a questionnaire results)

My question is should I design so that the repeating values are written repetaedly to columns?
Should I make supporting tables with Primary key info entered to customers table's respective fields as foreign keys

I know the first approach is not effective in means of performance, however I am concerned about 30 odd foreign keys, too.

Which way sould I follow?  Which better in performance?


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros