Why do normalized tables require more complex SQL when SQL statements are used in application programs?

Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Next Question:
What is the minimum credit score required to process a Mortgage Application?
Posted by:
Nitin Johri
18-December-2016

Question ajoutée par Emad Mohammed said abdalla , ERP & IT Software, operation general manager . , AL DOHA Company
Date de publication: 2014/12/20

Apprécier (0) Vues (2) Suiveurs (1) Réponses (1) Report Question

Ajoutez Une Réponse
Inscrivez-vous ou connectez-vous pour répondre.

1 Réponses

par Emad Mohammed said abdalla , ERP & IT Software, operation general manager . , AL DOHA Company

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.

Apprécier (0)

Déprécier Réponses () Rapport