database SQL

 five pages to answer this 3 questions

1. Chapter 9 noted that CASE tools provide database administrators with a 
cost and time effective way of developing databases. Write a paper that 
compares some CASE technology vendors. Compare and contrast at 
least three examples of CASE products. In addition, discuss the 
advantages and disadvantages of using CASE tools to build a database. 

2. Using library resources or the Internet, identify a database management 
system that processes database transactions. Briefly describe what 
happens to the application when deadlocking occurs. Explain some of the 
adverse effects of deadlocking, and conclude by listing recommended 
actions that can be taken to avoid deadlocking on this application. 

3. SQL Server is Microsoft’s popular database engine that uses the Structured Query  Language (SQL) to accept requests for data access. Learn about SQL Server’s  backup strategies. Mention the types of data corruption that might occur in an  environment using SQL Server. Discuss some database backup requirements that a database administrator should consider when devising a backup strategy for her organization’s DBMS. Describe the different types of backup techniques 
supported by SQL Server. Conclude by explaining why it is essential to have a 
solid backup strategy as part of an organization’s efforts to maintain database 
transaction integrity