{"id":32699,"date":"2022-02-14T03:13:36","date_gmt":"2022-02-14T03:13:36","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/acc-simple-question-have-answer-on-it\/"},"modified":"2022-02-14T03:13:36","modified_gmt":"2022-02-14T03:13:36","slug":"acc-simple-question-have-answer-on-it","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/acc-simple-question-have-answer-on-it\/","title":{"rendered":"Acc simple question, have answer on it"},"content":{"rendered":"
\n

2. Database Authorization <\/span><\/strong><\/p>\n

Some relevant database tables and attributes are presented in the figure designated Problem 4-2 in the chapter.\u00a0 <\/span><\/p>\n

\u00a0<\/span><\/p>\n

Required:<\/span><\/p>\n

A)\u00a0 Create a database authorization table for an Accounts payable clerk.\u00a0 Structure your response similar to the example below: <\/span><\/p>\n

\u00a0<\/span><\/p>\n\n\n\n\n\n\n\n\n
\n

\u00a0<\/span><\/p>\n<\/td>\n

\n

Table 1\u00a0 Name<\/span><\/p>\n<\/td>\n

\n

Table 2 Name<\/span><\/p>\n<\/td>\n

\n

Table \u2026..<\/span><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Authority Level<\/span><\/strong><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Read<\/span><\/strong><\/p>\n<\/td>\n

\n

Y<\/span><\/p>\n<\/td>\n

\n

Y<\/span><\/p>\n<\/td>\n

\n

Y<\/span><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Insert<\/span><\/strong><\/p>\n<\/td>\n

\n

Y<\/span><\/p>\n<\/td>\n

\n

N<\/span><\/p>\n<\/td>\n

\n

N<\/span><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Modify<\/span><\/strong><\/p>\n

Delete<\/span><\/strong><\/p>\n<\/td>\n

\n

Y<\/span><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\u00a0<\/span><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/p>\n

Indicate the name of each table the AP clerk may access and the degree of access privilege such as:<\/span><\/p>\n

Read<\/span><\/strong> data from the table<\/span><\/p>\n

Insert<\/span><\/strong> data into the table,\u00a0 <\/span><\/p>\n

Modify <\/span><\/strong>or edit data in the table<\/span><\/p>\n

Delete <\/span><\/strong>data (attribute values or entire records) from the table<\/span><\/p>\n

\u00a0<\/span><\/p>\n

B)\u00a0 Explain your answers to part (A) above.<\/span><\/p>\n

\u00a0<\/span><\/strong><\/p>\n

Response:<\/span><\/p>\n

A)\u00a0 The table below illustrates the appropriate access privileges for the AP clerk whose job is to review the supplier\u2019s invoice and set up a liability, which will later be paid.\u00a0 <\/span><\/p>\n

\u00a0<\/span><\/p>\n

\u00a0<\/span><\/p>\n\n\n\n\n\n\n\n
\n

Database Table<\/span><\/strong><\/p>\n<\/td>\n

\n

Purchase Order<\/span><\/strong><\/p>\n<\/td>\n

\n

Receiving Report<\/span><\/strong><\/p>\n<\/td>\n

\n

Vendor Invoice<\/span><\/strong><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/strong><\/p>\n<\/td>\n<\/tr>\n

\n

Authority Level<\/span><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/strong><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/strong><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/strong><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/strong><\/p>\n<\/td>\n<\/tr>\n

\n

Read<\/span><\/p>\n<\/td>\n

\n

Y<\/span><\/strong><\/p>\n<\/td>\n

\n

Y<\/span><\/strong><\/p>\n<\/td>\n

\n

Y<\/span><\/strong><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/strong><\/p>\n<\/td>\n<\/tr>\n

\n

Insert<\/span><\/p>\n<\/td>\n

\n

N<\/span><\/strong><\/p>\n<\/td>\n

\n

N<\/span><\/strong><\/p>\n<\/td>\n

\n

Y<\/span><\/strong><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/strong><\/p>\n<\/td>\n<\/tr>\n

\n

Modify<\/span><\/p>\n

Delete<\/span><\/p>\n<\/td>\n

\n

N<\/span><\/strong><\/p>\n

N<\/span><\/strong><\/p>\n<\/td>\n

\n

N<\/span><\/strong><\/p>\n

N<\/span><\/strong><\/p>\n<\/td>\n

\n

N<\/span><\/strong><\/p>\n

N<\/span><\/strong><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/strong><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\u00a0<\/span><\/p>\n

B) The process involves performing a three-way-match of the PO, receiving report, and the Vendor Invoice.\u00a0 Before setting up an account payable the clerk will verify the items invoiced were ordered (PO), received in good condition (receiving report), and that the invoice charges are correct.\u00a0 To do this the clerk needs \u201cRead\u201d access to the PO and receiving report tables and \u201cRead\u201d and \u201cInsert\u201d \u00a0access to the Vendor Invoice table.\u00a0 Once the three-way-match is complete, the clerk transcribes the details from the supplier\u2019s hard copy invoice to the Vendor Invoice table and assigns a due date.\u00a0 This establishes the liability. \u00a0The unpaid invoices at any point in time constitute the accounts payable.<\/span><\/p>\n

\u00a0<\/span><\/p>\n

The AP clerk normally would not have \u201cmodify\u201d or \u201cdelete\u201d access to the Vendor Invoice table.\u00a0 Editing and deleting existing records in a table should be a supervisor function.\u00a0 <\/span><\/p>\n

\u00a0<\/span><\/p>\n

\u00a0<\/p>\n

Also, the clerk should not have insert, modify, or delete access to the PO and receiving report tables.\u00a0 Such access would allow the AP clerk to enter fraudulent PO and receiving report records. The clerk\u2019s legitimate \u201cinsert\u201d privileges would then allow him to create a fraudulent supplier\u2019s invoice (on behalf of himself or a conspirator) and set up a false liability, which would later be paid.<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\u00a0<\/span><\/p>\n

To do:<\/span><\/p>\n

1. rewrite the question (B) answer, use your own word. That answer is correct answer, i copy from internet.\u00a0<\/span><\/p>\n

2. zero plagiarism, not page require<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

2. Database Authorization Some relevant database tables and attributes are presented in the figure designated Problem 4-2 in the chapter.\u00a0 \u00a0 Required: A)\u00a0 Create a database authorization table for an Accounts payable clerk.\u00a0 Structure your response similar to the example below: \u00a0 \u00a0 Table 1\u00a0 Name Table 2 Name Table \u2026.. \u00a0 Authority Level \u00a0 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-32699","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/32699","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=32699"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/32699\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=32699"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=32699"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=32699"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}