Home » SQL & PL/SQL » SQL & PL/SQL » Denormalization
Denormalization [message #391860] Sat, 14 March 2009 01:54 Go to next message
sharmakranthi
Messages: 14
Registered: February 2009
Location: Bangalore
Junior Member
It is a Interview Question.

Why we need to use Joins? Instead we can create a Single Table with all the data at one place.
To interprete the above question, Why we need to have multiple tables for the data and use Joins Concept to retrieve the data?
Re: Why we need to use Joins [message #391865 is a reply to message #391860] Sat, 14 March 2009 02:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL Reference
Chapter 9 SQL Queries and Subqueries
Section Joins

Join Wiki page.

Regards
Michel
Re: Why we need to use Joins [message #391868 is a reply to message #391860] Sat, 14 March 2009 02:35 Go to previous messageGo to next message
vaibhavk
Messages: 7
Registered: March 2009
Junior Member
sharmakranthi wrote on Sat, 14 March 2009 01:54
It is a Interview Question.

Why we need to use Joins? Instead we can create a Single Table with all the data at one place.
To interprete the above question, Why we need to have multiple tables for the data and use Joins Concept to retrieve the data?

What a stupid interview question. Imagine storing all the data of a company in one table! why do we you need a relational database system then, why not use flat files?
Re: Why we need to use Joins [message #391869 is a reply to message #391860] Sat, 14 March 2009 02:39 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
See Normalization and Denormalize.
Re: Why we need to use Joins [message #391878 is a reply to message #391868] Sat, 14 March 2009 03:13 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
vaibhavk wrote on Sat, 14 March 2009 08:35
What a stupid interview question. Imagine storing all the data of a company in one table! why do we you need a relational database system then, why not use flat files?

That's hardly an answer.
So, tell us. Why would we not use flat files?

I think this is one of the better interview questions I've seen posted here. Instead of checking if the interviewee learned a lot of nonsense questions by heart, it asks for him to show some insight.
Previous Topic: Creating Procedure
Next Topic: Help with this code
Goto Forum:
  


Current Time: Sun Dec 11 02:11:35 CST 2016

Total time taken to generate the page: 0.09783 seconds