Why Do Normalized Tables Require More Complex Sql When Sql Statements

1.	Why Do Normalized Tables Require More Complex Sql When Sql Statements Are Used In Application Programs?
Answer» Tables that are NORMALIZED contain DATA that has been distributed among the tables, but which may need to be recombined to answer queries from an application. To recombine the data, the programmer will have to use SUBQUERIES and/or JOINS. These SQL structures are more complex to write than a simple SELECT statement. Tables that are normalized contain data that has been distributed among the tables, but which may need to be recombined to answer queries from an application. To recombine the data, the programmer will have to use subqueries and/or joins. These SQL structures are more complex to write than a simple SELECT statement.

Why Do Normalized Tables Require More Complex Sql When Sql Statements Are Used In Application Programs?

Answer»

Tables that are NORMALIZED contain DATA that has been distributed among the tables, but which may need to be recombined to answer queries from an application. To recombine the data, the programmer will have to use SUBQUERIES and/or JOINS. These SQL structures are more complex to write than a simple SELECT statement.

Tables that are normalized contain data that has been distributed among the tables, but which may need to be recombined to answer queries from an application. To recombine the data, the programmer will have to use subqueries and/or joins. These SQL structures are more complex to write than a simple SELECT statement.

Discussion

No Comment Found

Related InterviewSolutions

What Is Lock Granularity?
In General, How Should The Boundaries Of A Transaction Be Defined?
Explain The Meaning Of The Expression Acid Transaction?
Explain The Necessity Of Defining Processing Rights And Responsibilities. How Are Such Responsibilities Enforced?
Explain How A Database Could Be Recovered Via Reprocessing. Why Is This Generally Not Feasible?
Define Rollback And Roll Forward?
Why Is It Important To Write To The Log Before Changing The Database Values?
Explain The Difference Between A Database Administrator And A Data Administrator?
What Is The Foreign Key?
What Is A Candidate Key?