1. rovide the Data Definition for the purchase requisition entity using the example in Figure 7.3 of the text as a guide.

Definition of Product "A product is a physical thing that is offered for sale by Match Lighting to retailers. It includes items that are purchased by Match Lighting directly from its suppliers, individual parts that are manufactured by Match Lighting using a design specification and collections of parts that are packaged as a final product for retailers to sell to consumers Key: Potential entity and business rules. Business rules from the definition include: A product is offered for sale to retailers. A product includes items. An item is purchased from suppliers. A product includes parts. A part is manufactured using a design specification. Parts are packaged to form a product. Figure 7.3 Business Rules in a Data Definition The Scenario: You are designing a workflow process to handle a purchase requisition for your organisation. When an employee creates a purchase requisition, his/her supervisor must approve it. When an approved purchase requisition reaches the purchasing department, a purchasing agent evaluates the record, and then performs one of the following steps: Rejects the requisition Creates a request for quotation to receive bids for the purchase Creates a purchase order from the requisition The purchase requisition contains name, total price, quantity, and purpose (assume that the requisition is for one type of items). Depending on the price, additional approval may be need as described below. Type A purchase requisition: If the total price is $500 or less, no further approval is needed and the requisition is routed to the purchasing department. Type B purchase requisition: If the total price exceeds $500, the requisition then requires the approval of the department manager (after the approval of the supervisor) before it can be routed to the purchasing department. Type C purchase requisition: If the total price exceeds $1,000, the requisition then requires the approval of a vice president (after the approval of the department manager) before it can be routed to the purchasing department