Reference no: EM132726789

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.