The management of Colonial Adventure Tours wants to upgrade its database and wants you to help select a different DBMS. To help management, they would like you to complete the following exercises. You do not use the Colonial Adventure Tours database for any of these exercises.
Use computer magazines and/or the Internet to investigate one of these DBMSs: DB2, SQL Server, MySQL, Oracle, or Sybase. Prepare a report that explains how that DBMS handles the following DBMS functions: concurrent update, data recovery, and security. (Note: For concurrent update, you might need to review the concurrency control features of the DBMS.) Could Colonial Adventure Tours upgrade to the DBMS that you researched? Why or why not?