Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dewacorp.alliances
452 Posts |
 Posted - 2010-10-22 : 00:27:08
|
| HiIn the survey, there is a type of question called Matrix which it's like this: | Is Friendly | Weather | Comments===========================================Sydney | Y | 5 | 'bla'-------------------------------------------Singapore | Y | 10 | 'test'-------------------------------------------Jakarta | N | 0 | 'test2-------------------------------------------Try to get a feedback in term of designing SQL table for question and answer. I could have a design that you can only have 3 label sets (Is Friendly, Weather, Comment) or maybe extended to 10 to be save which means I have 10 columns.What do you think about this approach, I know this is not relation database in such but at least from query point of view for answer to pull out.Your thought? |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-10-26 : 19:29:54
|
| I have never run into a situation where going full normalized was an issue. You will never paint yourself into a corner this way.______________________________________________Talk sense to a fool and he calls you foolish. |
 |
|
|
|
|
|
Need a feedback for designing Matrix question