Modern Database Management: Chapter 11 Problem and Exercise 1

Fill in the following two authorization tables for Pine Valley Furniture, based on the following assumptions (Enter Y for yes or N for no):
  • Salespersons, managers, and carpenters may read inventory records but may not perform any other operations on these records.
  • Persons in Accounts Receivable and Accounts Payable may read and/or update (insert, modify, delete) receivables records and customer records.
  • Inventory clerks may read and/or update (modify, delete) inventory records. They may not view receivables records or payroll records. They may read but not modify customer records.
fill-in-the-two-authorization-tables-for-pine-valley-furniture-company-below-based-on-the-following-assumptions-enter-y-for-yes-or-n-for-no

The solution to the Problem

Step 1

Authorization tables for Pine Valley Furniture Company
When analyzing the given assumptions:
  • The salespersons, managers, and carpenters only perform “read” operations within the “inventory records” table. Therefore, “Salespersons” and “Carpenters” read operations are “yes”.
  • The inventory records within the “inventory clerks” table perform “read”, “modify”, and “delete” operations. That's why "delete", "modify" and "read" operations in the “Inventory Records” table are “yes”. Also, the “read”, “modify”, and “delete” operations of “Inventory Clerks” in the “Inventory Records” table are “yes”.
  • The customer records within the “Inventory Records” table perform the “read” operation. That's why the “Customer Records” read operation in “Inventory Records” is “yes”.

Step 2

Therefore, the subsequent two tables are filled by using the given assumptions:
Authorizations for Inventory Clerks:

Inventory Records

Receivable Records

Payroll Records

Customer

Records

Read

Y

N

N

Y

Insert

N

N

N

N

Modify

Y

N

N

N

Delete

Y

N

N

N



Authorizations for Inventory Records:

Salespersons

A/R Personnel

Inventory Clerks

Carpenters

Read

Y

N

Y

Y

Insert

N

N

N

N

Modify

N

N

Y

N

Delete

N

N

Y

N


إرسال تعليق

Post a Comment (0)

أحدث أقدم