(a) What is SQL? Explain why SQL is not suitable as a language for writing database applications? (b) To overcome the li

[answerhappygod]

A What Is Sql Explain Why Sql Is Not Suitable As A Language For Writing Database Applications B To Overcome The Li 1 (71.96 KiB) Viewed 22 times

(a) What is SQL? Explain why SQL is not suitable as a language for writing database applications? (b) To overcome the limitations of SQL, database application programmers can resort to one of the following three solutions: i. ii. Embed SQL statements in a general-purpose programming language like C or COBOL; Use a call-level interface with a general-purpose programming language; Use an extension of SQL that provides the features of a general- purpose programming language. iii. Describe the features provided by each of these solutions. Illustrate your answer with examples. (0) Describe the DBMS software facilities that are used to support the above security issues in a multi-user system. Give examples (using sql code) of user authentication, user privileges and confidentiality of data. (d) Explain what happens when a weak entity is subject to a cascade delete/update process. (e) Illustrate an example of the use of cascaded delete/update process with diagram and explanation. (1) Explain the integrity rules which are applied in the cascaded delete/update process.