PLEASEEEEE ANSWER PROBLEM AND QUESTIONS FULLY PLEASEEEEE. MUST GET $100\%$ ON THIS ASSIGNMENT TO ACHIEVE A THIS SEMESTER PLEASEEEEEEEE

Instructions

Q$1)$ A large bank has a headquarters location plus several branches in each of the

cities in a particular region of the country. As transactions are conducted at each

branch, they are processed online against a relational database at headquarters. You

have been hired as the bank's Director of Data Security. Design a comprehensive set

of data security measures to protect the bank's data.

Q$2)$ The bank in previous question, which is totally dependent on its relational

database, must be able to keep running in the event of the failure of any one table on

one disk drive, in the event of a major disaster hitting its headquarters computer, or in

the event of any catastrophe in between these two extremes. Describe the range of

techniques and technologies that you would implement to enable the bank to recover

from this wide range of failures.

Q$3)$

The Tasty Seafood Restaurant is a large restaurant that specializes in fresh fish and

seafood. Because of how important its reputation for freshness is to Tasty, it brings

in a certain amount of each type of fish daily and, while trying to satisfy all of its

customers, would rather run out of a type of fish than carry it over to the next day.

After taking a table's order, a waiter enters the order into a touch$-$screen terminal

that is connected to a computer in the kitchen. The order is sent from the touch$-$

screen terminal to the computer only after all of it has been entered.

At $8$:$00$PM there are $10$ servings of salmon, $15$ servings of flounder, and $8$ orders of

trout left in the kitchen.

At $8$:$03$PM$,$ waiter Frank starts entering an order that includes $5$ servings of salmon, $6$

of flounder, and $4$ of trout.

At the same time, on another touch$-$screen terminal, waitress Mary starts entering an

order that includes $1$ serving of salmon, $3$ of flounder, and $2$ of trout.

At $8$:$05$PM$,$ before the other two have finished entering their orders, waitress Tina

starts entering an order that includes $6$ servings of salmon, $1$ of flounder, and $5$ of

trout.

At $8$:$06$PM Frank finishes entering his order.

At $8$:$07$PM Mary finishes entering her order.

At $8$:$09$PM Tina finishes entering her order.

$1).(10$ pts$)$ Describe what would the result of all of this be in the absence of locks?

$($Hint: refers to slides p$51)$

Answer:

$2).(10$ pts$)$ Describe what would the result be with a locking mechanism in place

$($assume deadlock is dealt with and no deadlock will occur. Deadlock detention

mechanism allows Frank to complete first, then Mary, then Tina$)?$

Answer: