Please follow the above-given instructions. Thank you so much!
Background Information Brock Ltd. sells home furniture purchased from various furniture manufacturers to customers through the company's sales force in the GTA, Ontario, Canada. Purchases The purchasing clerk runs an inventory report everyday to identify the items that should be purchased based on the reorder point of each inventory item. When employees from various departments need to purchase something, they fill in a purchase requisition form and send it to the purchasing clerk. Brock Ltd. creates a purchase order for each purchase requisition of inventory items, office supplies, or services. For each purchase order, there is one receipt. For each receipt, there is one purchase order. All the vendors are required to create one invoice for each purchase order after goods are delivered and received in good condition. Accounts Payable The accounts payable clerk prepares checks for payments to various vendors. Brock normally pays for purchases at the end of each month for all the purchases from each vendor during the month. If multiple purchases from the same vendor were made, the accounts payable clerk will combine payments. However, each purchase invoice is either unpaid or paid in full. If an invoice is received after the checks are prepared, they will hold it until the end of the following month before sending payment. The accounts payable clerk stamps each invoice with the check number, the check amount, and the date paid. After the check is prepared and sent out to the vendor, they package all of the source documents and file them. Some cash disbursements involve parties other than vendors (e.g. bank loans). Sales Each type of furniture inventory is given a unique identification number and a suggested selling price. Each sale includes one or more pieces of furniture and can be paid for in one of the following three ways: (1) immediately in cash; (2) on the 15th of the following month; (3) over the period of six months. When customer data is initially entered into Brock's information system, the customer is immediately assigned to a salesperson. When a salesperson is hired, he or she is immediately assigned to a group of customers. No more than one salesperson participates in making a particular sale. A salesperson may negotiate with a customer and agree on a selling price that is lower than that furniture's suggested selling price, especially if the customer is a high-volume customer or if that furniture is a slow seller (i.e., it has been in stock for a long time). Sales Each type of furniture inventory is given a unique identification number and a suggested selling price. Each sale includes one or more pieces of furniture and can be paid for in one of the following three ways: (1) immediately in cash; (2) on the 15th of the following month; (3) over the period of six months. When customer data is initially entered into Brock's information system, the customer is immediately assigned to a salesperson. When a salesperson is hired, he or she is immediately assigned to a group of customers. No more than one salesperson participates in making a particular sale. A salesperson may negotiate with a customer and agree on a selling price that is lower than that furniture's suggested selling price, especially if the customer is a high-volume customer or if that furniture is a slow seller (i.e., it has been in stock for a long time). Salesperson commission rate is determined per contractual arrangement with each salesperson and, for a particular salesperson, it is the same percentage rate no matter what items he or she sells. Salespersons' responsibilities include determining whether credit card sales are approved, approving credit sales, and approving sales returns. Cash Receipts Although the vast majority of cash receipts come from customers (any particular cash receipt would be from only one customer) for sales, some cash receipts come from other sources (e.g. interests received from banks). Every cash receipt is processed by exactly one of Brock's several cashiers and is deposited into one of Brock's bank accounts. Other Information about furniture, employees, and customers often needs to be entered into the database before any transactions involving them have occurred. Ignore purchase discounts and HST. Phase I Instructions Based on the information given, prepare an integrated UML class diagram for Brock Ltd. with a MS Office application (e.g. PowerPoint, Word etc.). Use the REA model to help you determine the entities. Assign each of the following attributes to the appropriate class and include them in your UML class diagram: Sale_Inv_Num Reorder_Point AR_Balance Cust_Address Vendor_Num Cust_Postal Code Inventory_Num Empl_First Name Cust_City Empl_DOB PO_Date Bank_Type Vendor_Address Actual_Sale_Price PO_Num Bank_Balance Amount_Applied Empl_SIN Sale_Date Inventory_Unit_of_Measure Inventory_Category Sale_Amount Commission_Rate Bank_Name Qty_On_Hand Bank_Acct_Num Cust_Num PO_Amount Bank_Location Cust_Name Purchase_Description Item_Unit_Cost Ven_Name CR_Date Empl_Position CD_Date Item_Description Suggested_Selling Price Ven_City CR_Amount CD_Amount Actual_Sale_Qty Cust_Province Empl_Last Name Vendor_Province CD_Num CR_Num AP_Balance 1 Empl_Num Actual_Purchase_Price Actual_Purchase_Qty Submission: Upload your UML class diagram to the "Term Project Phase I" under the "Online Submissions" module on Sakai by 11:59 p.m on Sunday, November 7, 2021. Make sure to include the following in your UML class diagram: 1. Classes 2. Associations 3. Multiplicities 4. Attributes: You may present the attributes in one of the following ways: a. Attach the attributes to the corresponding class in your UML class diagram b. List the attributes for each class in a separate table and submit it together with your UML class diagram c. Create a list of schemas for all the classes and submit it together with your UML class diagram Notes: CD: cash disbursement CR: cash receipts Empl: employee Cust: customer Background Information Brock Ltd. sells home furniture purchased from various furniture manufacturers to customers through the company's sales force in the GTA, Ontario, Canada. Purchases The purchasing clerk runs an inventory report everyday to identify the items that should be purchased based on the reorder point of each inventory item. When employees from various departments need to purchase something, they fill in a purchase requisition form and send it to the purchasing clerk. Brock Ltd. creates a purchase order for each purchase requisition of inventory items, office supplies, or services. For each purchase order, there is one receipt. For each receipt, there is one purchase order. All the vendors are required to create one invoice for each purchase order after goods are delivered and received in good condition. Accounts Payable The accounts payable clerk prepares checks for payments to various vendors. Brock normally pays for purchases at the end of each month for all the purchases from each vendor during the month. If multiple purchases from the same vendor were made, the accounts payable clerk will combine payments. However, each purchase invoice is either unpaid or paid in full. If an invoice is received after the checks are prepared, they will hold it until the end of the following month before sending payment. The accounts payable clerk stamps each invoice with the check number, the check amount, and the date paid. After the check is prepared and sent out to the vendor, they package all of the source documents and file them. Some cash disbursements involve parties other than vendors (e.g. bank loans). Sales Each type of furniture inventory is given a unique identification number and a suggested selling price. Each sale includes one or more pieces of furniture and can be paid for in one of the following three ways: (1) immediately in cash; (2) on the 15th of the following month; (3) over the period of six months. When customer data is initially entered into Brock's information system, the customer is immediately assigned to a salesperson. When a salesperson is hired, he or she is immediately assigned to a group of customers. No more than one salesperson participates in making a particular sale. A salesperson may negotiate with a customer and agree on a selling price that is lower than that furniture's suggested selling price, especially if the customer is a high-volume customer or if that furniture is a slow seller (i.e., it has been in stock for a long time). Sales Each type of furniture inventory is given a unique identification number and a suggested selling price. Each sale includes one or more pieces of furniture and can be paid for in one of the following three ways: (1) immediately in cash; (2) on the 15th of the following month; (3) over the period of six months. When customer data is initially entered into Brock's information system, the customer is immediately assigned to a salesperson. When a salesperson is hired, he or she is immediately assigned to a group of customers. No more than one salesperson participates in making a particular sale. A salesperson may negotiate with a customer and agree on a selling price that is lower than that furniture's suggested selling price, especially if the customer is a high-volume customer or if that furniture is a slow seller (i.e., it has been in stock for a long time). Salesperson commission rate is determined per contractual arrangement with each salesperson and, for a particular salesperson, it is the same percentage rate no matter what items he or she sells. Salespersons' responsibilities include determining whether credit card sales are approved, approving credit sales, and approving sales returns. Cash Receipts Although the vast majority of cash receipts come from customers (any particular cash receipt would be from only one customer) for sales, some cash receipts come from other sources (e.g. interests received from banks). Every cash receipt is processed by exactly one of Brock's several cashiers and is deposited into one of Brock's bank accounts. Other Information about furniture, employees, and customers often needs to be entered into the database before any transactions involving them have occurred. Ignore purchase discounts and HST. Phase I Instructions Based on the information given, prepare an integrated UML class diagram for Brock Ltd. with a MS Office application (e.g. PowerPoint, Word etc.). Use the REA model to help you determine the entities. Assign each of the following attributes to the appropriate class and include them in your UML class diagram: Sale_Inv_Num Reorder_Point AR_Balance Cust_Address Vendor_Num Cust_Postal Code Inventory_Num Empl_First Name Cust_City Empl_DOB PO_Date Bank_Type Vendor_Address Actual_Sale_Price PO_Num Bank_Balance Amount_Applied Empl_SIN Sale_Date Inventory_Unit_of_Measure Inventory_Category Sale_Amount Commission_Rate Bank_Name Qty_On_Hand Bank_Acct_Num Cust_Num PO_Amount Bank_Location Cust_Name Purchase_Description Item_Unit_Cost Ven_Name CR_Date Empl_Position CD_Date Item_Description Suggested_Selling Price Ven_City CR_Amount CD_Amount Actual_Sale_Qty Cust_Province Empl_Last Name Vendor_Province CD_Num CR_Num AP_Balance 1 Empl_Num Actual_Purchase_Price Actual_Purchase_Qty Submission: Upload your UML class diagram to the "Term Project Phase I" under the "Online Submissions" module on Sakai by 11:59 p.m on Sunday, November 7, 2021. Make sure to include the following in your UML class diagram: 1. Classes 2. Associations 3. Multiplicities 4. Attributes: You may present the attributes in one of the following ways: a. Attach the attributes to the corresponding class in your UML class diagram b. List the attributes for each class in a separate table and submit it together with your UML class diagram c. Create a list of schemas for all the classes and submit it together with your UML class diagram Notes: CD: cash disbursement CR: cash receipts Empl: employee Cust: customer
