Discuss any potential exposure if the right prevention devices are not in place or if Bogey and… 1 answer below »

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 File

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 think 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.

 

Looking for a Similar Assignment? Hire our Top Uk Tutors while you enjoy your free time! All papers are written from scratch and are 100% Original. Try us today! Active Discount Code FREE15