1. You are working as a database architect for your organization. An application programmer using the database has a performance problem. The application you are writing has a loop structure that triggers an SQL statement for each iteration of the loop. In each SQL statement, only the WHERE statement is modified. What would you recommend to her? If the database in question supports batch processing, the loop structure could instead be used to create a batch of SQL statements one by one, which will then be executed together once the loop ends. Since the changes in each instruction are minimal, implementing program logic to achieve this would be relatively simple and performance would be considerably better.2. In class we discussed Logical Units of Work (LUW) and transaction management. How many logical units of work can you have in a stored procedure? Also, discuss transaction management and how LUWs relate to triggers. It is generally inadvisable/not standard practice to use commit statements within a stored procedure, which means...