Question

Consider the subschema of a receiving clerk. The receiving clerk needs sufficient rights in her logical view to perform her duties but not be given rights that she does not need. Within her duties, she validates that items being received were ordered from a supplier before she accepts shipments from that supplier. To do so she must be able to see purchases from each supplier. Determine which rights (Create, Read, Update, and Delete) the receiving clerk should have for data corresponding to sales, cash receipts, purchases, and suppliers.

Answer 1

Answer:

In this project question we have to consider sub schema of a receiving clerk. As per the information provided in the case study the receiving clerk needs sufficient rights in her logical view to perform her duties but not given rights that she does not need. On the basis of the information given in the question right to create the receiving clerk should have for data corresponding to sales cash receipts, purchase, and suppliers. In this project question receiving clerk is using her right to create so we can say for the validation for the items received the clerk is using this right. Right to create is important as per the laws of business. Complete information should be presented by both the parties for the successful completion of the order. In this question this right is using by the receiving clerk.