Some relevant database tables and attributes are presented in the figure designated Problem 4-2 in the chapter. 

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 such as:

Read data from the table

Insert data into the table, 

Modify or edit data in the table

Delete data (attribute values or entire records) from the table

B)  Explain your answers to part (A) above.

Transcribed Image Text:

Table 1 Name Table 2 Name Table Authority Level Read Insert Modify Delete