Some relevant database tables and attributes are presented in the figure designated Problem 12 on the following page.

Required
a. Create a database authorization table for an accounts payable clerk. Structure your response similar to the example below: 

Indicate the name of each table the AP clerk may access and the degree of access privilege as defined below:

Read existing records in the table
Insert new record into the table
Modify or edit existing records in the table
Delete existing attribute values or entire records from the tableb. Explain your answers to part (a) above.

b. Explain your answers to part (a) above.

Transcribed Image Text:

Authority Level Table 1 Name Table 2 Name Table ..... Read Insert Modify Delete Y Y Y Y Z < N Y N