Question: 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
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.
Table 1 Name Table 2 Name Table Authority Level Read Insert Modify Delete
Step by Step Solution
3.30 Rating (179 Votes )
There are 3 Steps involved in it
A The table below illustrates the appropriate access privileges for the AP clerk whose job is to rev... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
641-B-M-L-I-T (784).docx
120 KBs Word File
