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:

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

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

1 Expert Approved Answer
Step: 1 Unlock

A The table below illustrates the appropriate access privileges for the AP clerk whose job is to rev... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

641-B-M-L-I-T (784).docx

120 KBs Word File

Students Have Also Explored These Related Management Leadership Questions!