The simplicity of SQL syntax leads some database developers to become overconfident with their SQL prowess. Potential
Fantastic news! We've Found the answer you've been seeking!
Question:
The simplicity of SQL syntax leads some database developers to become overconfident with their SQL prowess. Potential problems may arise because the relational data model uses implicit relationships, not explicit ones. For instance, two tables may be joined using common domains (e.g., positive integers) but noncommon roles (e.g., two tables can be joined on equal values of quantity-on-hand of a product and number of employees in a department).
Could you find another example to demonstrate that logically and syntactically correct SQL queries can be constructed that do not accomplish the intended data manipulation and maybe dangerously incorrect?
Related Book For
Accounting Information Systems
ISBN: 978-0133428537
13th edition
Authors: Marshall B. Romney, Paul J. Steinbart
Posted Date: