Where is the answer key for this file?
THQUIZ #1 ACG 4401 Due: April 9, 2013 P IECES B OUTIQUE Bring Requirement #3 to class on April 9, 2013. You are expected to bring a written implementation to class and you will need to complete the quiz prior to completion of the implementation. Pieces Boutique is an ethical, fair trade fashion boutique in Las Vegas, NV that specializes in women's clothing, shoes, and accessories. Pieces Boutique is committed to improving sustainability in the fashion industry and only buys products from designers that have open, transparent supply chains, who care about who and where their collections are made, and ensure that there has been no exploitation during their production. Pieces Boutique currently stocks products from 10 designers. Pieces' storeroom is organized by designer (e.g. People Tree, Komodo, Sika etc.) and sub category (i.e., tops, bottoms, dress shoes, casual shoes, etc.). There is only one code for each designer/sub category pair. Pieces is not currently planning to expand the types of products it carries, and it will only add a new category if it identifies a related product to add to the inventory table. Of course, every item in inventory has exactly one type classification. Pieces' purchasing agents are responsible for maintaining inventory records. Every season (i.e. spring, fall, summer, winter), the purchasing agents receive listings of available items from their designers; the designers also provide periodic updates (i.e. addition and deletions of specific items and changes to list prices) as needed and the purchasing agents use this information to update the inventory records. When a particular inventory item meets its reorder point, Pieces' computer system generates a purchase order and a purchasing agent sends the purchase order to the appropriate designer/supplier. Suppliers fill each order individually; sometimes, however, they are out of stock of an item. In such cases, they immediately ship what is in stock and then make subsequent delivery(s) for items that they have to back order. When a purchasing clerk places an order with a supplier, the quantity ordered and the supplier's quoted unit price are recorded. When the shipment is received, a receiving clerk records the quantity received and the actual unit price. The actual unit price sometimes differs from the supplier's quoted unit price due to sales promotions. Once an inventory order is received and the receiving clerk verifies a valid purchase order, the receipt is counted and sent to inventory. Occasionally, the receiving clerk must return an entire order or individual items within an order because the shipment arrives damaged or the wrong item was shipped. The receiving clerk is able to determine the need for a return immediately upon receipt; therefore, if a purchase is returned it is only associated with one return. When a purchase return is made, Pieces receives a credit memo from the supplier for the returned items. Since Pieces has well established relationships with their suppliers and will place orders with them in the future, no cash is ever received for a purchase return. Pieces Boutique is very aware of the need to maintain good internal controls and purchasing agents are not allowed to receive shipments and receiving clerks are not allowed to place orders; of course a purchase order is related to exactly one purchasing agent and a purchase/delivery is related to exactly one receiving clerk. One of five cashiers process the cash disbursements; one cashier is primarily responsible for purchase disbursements, one is primarily responsible for payroll, one is primarily responsible for cash receipts, and two cashiers cover the other three cashiers on their off/vacation days. Supplier checks are issued at the end of each month (one check per supplier) for purchases that occurred throughout the month. Pieces Boutique also pays its employees; however, the majority of its cash disbursements are for purchases. Pieces Boutique has five bank accounts, two for cash disbursement (one for payroll and one for all other disbursements), and three for cash receipts (one for sales revenue and one for other miscellaneous income and one for short term investments). Of course supplier disbursements are consistent with the receiving reports and each disbursement is related to exactly one cashier and exactly one of Pieces' five bank accounts. Note: This database is well-designed; thus all agents, resources and typifications are added prior to recording events involving them. Required 1. Part 1 - Using the template provided below, construct an REA diagram (entities, relationships, participation cardinalities). The conceptual model should use the model form we have used in classEvents in the middle, Resources on the left and Agents on the right. 2. Part 1 continued - Using the partially complete REA diagram on page 5, identify the remaining entities and cardinalities. There is a Take Home Quiz #1 on your assessment link in Webcourses where you are to record your REA entities and the cardinalities. After you complete this portion of the take home quiz, you will have access to the correct responses. You will need to do Part 1 well before the class assignment is due in order to complete Part 2. 3. Part 2 - Bring a hardcopy of this part to class ON THE DUE DATE. Using the CORRECT responses from #2 above, design a relational database for Pieces Boutique using the attached list of attributes. Please do not add attributes to this list. Use the following conversion chart format for the DB design: Table Name Primary Key/s Other Attributes Foreign Key/s Attribute List: Item # Actual Unit Price PO date Location Category ID Supplier # State Check total Employee street address Supplier street address Check date Quantity returned City Return Date Employee First Name Check # Bank Acct # Employee_Title Item description ReceivingReport# Category Description Supplier phone number Return Authorization # Employee Last Name Selling Price Receiving Date Zip code Quoted Unit Price Total Amount on Purchase PO # Employee ID Base salary Emp phone number PO amount Supplier name Date hired Bank name Quantity_ordered Quantity_received Disbursement# Item return reason Account Type Color Pieces Boutique B Entity #2 A 1 B 2 9 B Entity #8 A A A A A A A Entity #5 4 7 B B A Entity #4 5 B A Entity #6 12 B Entity #9 B B B 6 A B A 8 A B A B A Entity #10 11 Entity #1 Cash B 13 A A Entity #7 14 B Supplier B 18 B 10 3 A 16 B 15 17
