BBB Miscellaneous Purchases BBB also purchases sewage, gar ing. purchases office supplies, hires photo shoot models and photographers, and so on BBB pays its miscellaneous suppliers at the end of the month for all purchases during the month. miscellaneous services and supplies, such as electricity, water bage, phone, and janitorial services. It also pays monthly rent on the build BBB Cash Disbursements BBB assigns sequential numbers to each check issued. All checks for purchases (both fab- ric and miscellaneous) are written on its main bank account. Exercise Requirements . Based on the preceding information and the following attributes list, prepare a UMIL class model and corresponding table listing describing BBB's purchases and payments process.List the tables in the following order: resources, events, agents, type images and linking tables.Identify the primary keys and foreign keys in each table. [optional Prepare a second UML model that combines the fabric and miscellaneous purchases events and the fabric and miscellaneous vendor agents. Show how you might model a way to differentiate among the types of vendors. 2. [optional] Based on the preceding information, prepare a BPMN activity model that describes BBB's purchases and payments process. The model should begin with BBB to the vendors new Access database, and import each worksheet in the spreadsheet into the database. placing orders with its vendors and end when BBB makes payments for the purchases 3. Your instructor will provide an Excel spreadsheet with the BBB information. Create a Set appropriate primary keys. 4. After importing all the data, create relationships among tables to implement your data model. 5. Prepare queries to answer the following questions: a. What were BBB's total purchases of fabric in the second quarter (April to June)? b. What is BBB's accounts payable balance for each fabric as of April 15? c. Based on the information available, what is the quantity on hand in yards for each fabric color code as of April 15? tribute Listing for B88 ank Name ash Account# ash Account Balance Beginning (April 1) sh Account Description Employee# Employee Address Employee City Employee Departm BBB Miscellaneous Purchases BBB also purchases sewage, gar ing. purchases office supplies, hires photo shoot models and photographers, and so on BBB pays its miscellaneous suppliers at the end of the month for all purchases during the month. miscellaneous services and supplies, such as electricity, water bage, phone, and janitorial services. It also pays monthly rent on the build BBB Cash Disbursements BBB assigns sequential numbers to each check issued. All checks for purchases (both fab- ric and miscellaneous) are written on its main bank account. Exercise Requirements . Based on the preceding information and the following attributes list, prepare a UMIL class model and corresponding table listing describing BBB's purchases and payments process.List the tables in the following order: resources, events, agents, type images and linking tables.Identify the primary keys and foreign keys in each table. [optional Prepare a second UML model that combines the fabric and miscellaneous purchases events and the fabric and miscellaneous vendor agents. Show how you might model a way to differentiate among the types of vendors. 2. [optional] Based on the preceding information, prepare a BPMN activity model that describes BBB's purchases and payments process. The model should begin with BBB to the vendors new Access database, and import each worksheet in the spreadsheet into the database. placing orders with its vendors and end when BBB makes payments for the purchases 3. Your instructor will provide an Excel spreadsheet with the BBB information. Create a Set appropriate primary keys. 4. After importing all the data, create relationships among tables to implement your data model. 5. Prepare queries to answer the following questions: a. What were BBB's total purchases of fabric in the second quarter (April to June)? b. What is BBB's accounts payable balance for each fabric as of April 15? c. Based on the information available, what is the quantity on hand in yards for each fabric color code as of April 15? tribute Listing for B88 ank Name ash Account# ash Account Balance Beginning (April 1) sh Account Description Employee# Employee Address Employee City Employee Departm
