Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

normalization vs de-normalization ? Expand / Collapse
Author
Message
Posted Thursday, January 10, 2013 9:02 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:53 PM
Points: 36,795, Visits: 31,257
opc.three (1/10/2013)
Agreed, not about shooting the test writer but about the nonsensical options. You literally have to rule out all the real choices based on how ambiguous they are. "Compare and contrast normalization and de-normalization with respect to data modifications and the expense of data retrieval."

Now that's a solid question, albeit that approach tends to fall down when writing a multiple choice exam


Did you see the other question concerning the model database? Nah... shoot the test writers.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1405512
Posted Thursday, January 10, 2013 9:11 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:57 PM
Points: 7,094, Visits: 12,583
No, please share. Nothing like a good witch hunt on a Thursday morning.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1405517
Posted Thursday, January 10, 2013 9:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 15, 2013 10:16 PM
Points: 4, Visits: 8
the test was for my semester 3 exams in college. These 2 questions that i posted didnt make much sense to me so I just wanted to know what others thought
Post #1405526
Posted Thursday, January 10, 2013 10:22 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, June 26, 2014 4:08 AM
Points: 708, Visits: 3,286
fearghalreilly (1/9/2013)
i went with answer B but not fully sure if it was the correct decision ....


Sorry to say that you went for the wrong option!

B) de-normalization speeds up data modifications at the expense of data retrieval

When you de-normalise the data you're going to re-introduce some form of data redundancy. Which means modification would be applied to more rows (as data is now duplicated).

On the other hand, data retrieval would be faster when accessing correctly indexed de-normalised data.

BTW, when I read this earlier today I went for option E but like the rest I chose E because I didn't feel comfortable with the other options.


---------------------------------------------------------


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1405547
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse