Sy's Fish Project The Problem Sy hired business (Sy's Fish Company), construct a prototype system in Micr provide some related accounting process will not be able to support his rapidly growing business. He also understands the importance of an accounting system that can provide timely management information as well as standard accounting functions. The Sy's Fish account is very important to your firm, so your boss expects your group to impress Sy with the quality of your performance under the time your accounting and consulting firm to design a database accounting system for his s advice. He recognizes that his current d Deli 1. Elicitation of requirements Your will then needs to understand the details of Sy's business. Your supervisor interviewed Sy and some select Sy's Fish employees to discern aspects of his business. The results of those interviews are available in a separate document. Sy's processes include (but may not limited to) purchasing fish, selling fish, purchasing miscellaneous operating supplies and services, and paying employees. You should focus on 1) the structure of data necessary to support those processes in a database system, and 2) the sequence of activity in Sy's current business processes. Sy also wants advice on a) identifying and managing risks as his business grows and b) better use of information technology to make his business more efficient. II. REA Data model. Using the information gained from the interviews and other sources, you will prepare an integrated UML class diagram that incorporates the data requirements of all of Sy's business processes. Consider updating the REA data model as you go so you can submit an impressive professional-looking model with your final report. Ill. Process activity diagrams using BPMN After gaining an understanding of Sy's business processes, you are to document each current process with a business process activity diagram using business process modeling notation (BPMN). At this point, you expect to prepare at least five separate activity diagrams corresponding to known Sy's Fish business processes IV. Access Database Preparation Using a copy of the EXCEL spreadsheet that Sy has prepared (the spreadsheet(s) will be available when appropriate), you are to transfer Sy's data to Access, establish efficient tables, and link the tables together on the relationships screen, enforcing referential integrity. You should make your relationships screen look like your REA data model so Sy can compare the database to your UML class diagram. You should assume that the data may contain inefficient tables and occasional typographical errors. You will need to correct those if necessary. Remember you're the accountant. V. Access Queries After establishing appropriate relationships among the tables, you will prepare queries as necessary to provide the following. 1. Information for Sy's income statement. Determine overall sales revenue, gross profit and corresponding gross profit percentage, general and administrative expenses, and net profit for Sy's Fish for the first quarter based on the information available. Information for Sy's balance sheet. Determine balances in asset, liability, and equity accounts at the end of the first quarter Information for store financial performance. Determine which store earned the greatest net profit for the first quarter (be sure to show all the stores and sort in descending net profit order). Information for accounts receivable. Determine the accounts receivable balance for each customer at the end of the first quarter (show all customers). Information for accounts payable. Determine the accounts payable balance for each fisher and miscellaneous vendor at the end of the first quarter. . . . 2. Be sure to clearly identify the final query (the one that provides the required information) in each set. 3. In preparing the queries, you should remember that Sy operates on a calendar fiscal year, so the first quarter will include activity from January 1t to March 31t. There may be transactions that did not occur during the first quarter, so you must handle those transactions appropriately VI. Risk assessment and recommendations for risk management, Based on your models and your understanding of his business, describe the threats, vulnerabilities, and risk profile of Sy's Fish. Describe the potential consequences of Sy's risk exposure. Recommend actions to mitigate those risks Evaluate information technology. Assess benefits from Sy's plans for use of information technology-based on the process documentation-and provide recommendations for alternatives. Link your evaluation and recommendations to your business process activity diagrams to describe how the use of technology could streamline his processes. In particular, describe which uses of information technology would be cost-effective and which would not. VIl. Sy's Fish Project The Problem Sy hired business (Sy's Fish Company), construct a prototype system in Micr provide some related accounting process will not be able to support his rapidly growing business. He also understands the importance of an accounting system that can provide timely management information as well as standard accounting functions. The Sy's Fish account is very important to your firm, so your boss expects your group to impress Sy with the quality of your performance under the time your accounting and consulting firm to design a database accounting system for his s advice. He recognizes that his current d Deli 1. Elicitation of requirements Your will then needs to understand the details of Sy's business. Your supervisor interviewed Sy and some select Sy's Fish employees to discern aspects of his business. The results of those interviews are available in a separate document. Sy's processes include (but may not limited to) purchasing fish, selling fish, purchasing miscellaneous operating supplies and services, and paying employees. You should focus on 1) the structure of data necessary to support those processes in a database system, and 2) the sequence of activity in Sy's current business processes. Sy also wants advice on a) identifying and managing risks as his business grows and b) better use of information technology to make his business more efficient. II. REA Data model. Using the information gained from the interviews and other sources, you will prepare an integrated UML class diagram that incorporates the data requirements of all of Sy's business processes. Consider updating the REA data model as you go so you can submit an impressive professional-looking model with your final report. Ill. Process activity diagrams using BPMN After gaining an understanding of Sy's business processes, you are to document each current process with a business process activity diagram using business process modeling notation (BPMN). At this point, you expect to prepare at least five separate activity diagrams corresponding to known Sy's Fish business processes IV. Access Database Preparation Using a copy of the EXCEL spreadsheet that Sy has prepared (the spreadsheet(s) will be available when appropriate), you are to transfer Sy's data to Access, establish efficient tables, and link the tables together on the relationships screen, enforcing referential integrity. You should make your relationships screen look like your REA data model so Sy can compare the database to your UML class diagram. You should assume that the data may contain inefficient tables and occasional typographical errors. You will need to correct those if necessary. Remember you're the accountant. V. Access Queries After establishing appropriate relationships among the tables, you will prepare queries as necessary to provide the following. 1. Information for Sy's income statement. Determine overall sales revenue, gross profit and corresponding gross profit percentage, general and administrative expenses, and net profit for Sy's Fish for the first quarter based on the information available. Information for Sy's balance sheet. Determine balances in asset, liability, and equity accounts at the end of the first quarter Information for store financial performance. Determine which store earned the greatest net profit for the first quarter (be sure to show all the stores and sort in descending net profit order). Information for accounts receivable. Determine the accounts receivable balance for each customer at the end of the first quarter (show all customers). Information for accounts payable. Determine the accounts payable balance for each fisher and miscellaneous vendor at the end of the first quarter. . . . 2. Be sure to clearly identify the final query (the one that provides the required information) in each set. 3. In preparing the queries, you should remember that Sy operates on a calendar fiscal year, so the first quarter will include activity from January 1t to March 31t. There may be transactions that did not occur during the first quarter, so you must handle those transactions appropriately VI. Risk assessment and recommendations for risk management, Based on your models and your understanding of his business, describe the threats, vulnerabilities, and risk profile of Sy's Fish. Describe the potential consequences of Sy's risk exposure. Recommend actions to mitigate those risks Evaluate information technology. Assess benefits from Sy's plans for use of information technology-based on the process documentation-and provide recommendations for alternatives. Link your evaluation and recommendations to your business process activity diagrams to describe how the use of technology could streamline his processes. In particular, describe which uses of information technology would be cost-effective and which would not. VIl