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.

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

See Also: MDM Chapter 11 Problem and Excercise 2