Please answer the following questions in your own words:

1) A booking agency uses a database application program to manage seats on a boat cruise. Consider an application program that books passengers on a cruise to Highland Fund Land. Describe the steps that must be performed to book this cruise. Be sure that your answer covers all steps.

2) Discuss why an organization may want to use a Three-tier Client-Server Architecture versus a Two-tier Client-Server Architecture.

3) You have been hired as a new Database Administrator (DBA). There is no formal documentation about the database system that you will be managing. Alice creates a new database and wants Bob to have access to it. Alice works in Spartanburg, while Bob works in Greenville.

a) Identify three (3) of the Database Management System (DBMS) functions that may need to be modified. State what must be done to each function to provide Bob with access to the database.

4. Suppose we consider an ATM system that has a transaction that deposits money and another transaction that withdraws money. Suppose a malicious user figures out how to use the ATM at USC Upstate to withdraw $180.00 from your account. At the same time, you are also depositing $155.00 at an ATM at Westgate Mall.

Task: Assume that the initial balance is $550.00. You are to draw a concurrency table that represents when the two transactions can run and leave the database in a consistent state. Use the below Concurrency Table

Concurrency Table

Time	T1	T2	Balx
T0			$550.00