The simplicity of SQL syntax leads some database developers to become overconfid

Question

The simplicity of SQL syntax leads some database developers to become overconfident of 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 may be dangerously incorrect?

Explanation / Answer

Solution:

A view is also a one such exampple, view is a virtual table which is used in SQL and it is external part of the database other than what normal SQL queries does, view is not permanently stored in the database and each time the view is referenced in the query its contetns are calculated A view is costly, however, since its contents must be calculated each time that it is requested.

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.