Database Authorization Table The following information is stored in two relational database files:

Employee Master File Social Security number Name Address Date hired Hourly wage rate Marital status Number of exemptions Weekly Payroll Social Security number Hours worked Deductions Bonuses Required:

a. Bogey works in personnel and Bacall works in payroll. Prepare a database authorization table that you feel is appropriate for Bogey and Bacall for these two files.

b. Discuss any potential exposure if the right prevention devices are not in place or if Bogey and Bacall collude.