Assignment:
Assume that Morgan personnel are the owner (Morgan), an office administrator, one full-time salesperson, and two part-time salespeople. Morgan and the office administrator want to process data in all tables. Additionally, the full-time salesperson can enter purchase and shipment data. The part-time employees can only read shipment data; they are not allowed to see InsuredValue, however.
Create a 3 to 5-page memo for the owner that addresses the below issues:
1. The need for database administration at Morgan.
2. Your recommendation as to who should serve as database administrator. Assume that Morgan is not sufficiently large that it needs or can afford a full-time database administrator.
3. Describe the nature of database administration activities at Morgan. As an aggressive consultant, keep in mind that you can recommend yourself for performing some of the DBA functions.
B. For the employees described in part A, define users, groups, and permissions on data in these five tables. Use the security scheme shown in Figure as an example.
C. Suppose that you are writing a stored procedure to record new purchases. Suppose that you know that while your procedure is running, another stored procedure that records shipment data can be running, and a third stored procedure that updates shipper data can also be running.
1. Give an example of a dirty read, a nonrepeatable read, and a phantom read among this group of stored procedures.
2. What concurrency control measures are appropriate for the stored procedure that you are creating?
3. What concurrency control measures are appropriate for the two other stored procedures?