The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
31 views

3NF decomposition

Can anyone tell me how and/or why I'm getting stuck here? I have scouted around on the web for examples of 2NF and 3NF decompositions and they all seem to make more sense than the one I'm working on. ...
0
votes
1answer
96 views

Are de-normalised tables preferred in any aspect of a project? [closed]

While going through interview , My Interviewer asked me a question about Denormalization of tables and its usage in applications. On guess, I answered, Yes it might be. Being denormalized , you have ...
1
vote
1answer
136 views

Database denormalization: multiple rows into single column. How bad is it? [duplicate]

We have few join-heavy queries to our SQL Server 2008 database and in an attempt to optimize them I thought of having a view that would produce this OrderID Number Traveller 1 102 ...