Accounting Information System Analyze Mr. Z’s financial data from the first quarter of this fiscal year (Excel sheet is attached). Correct errors in the data files and study present trends and...

78319 - shop erd/ERD.png
78319 - shop erd/report.docx
The provided Excel sheet can be used as the database for a shop. This is basically information about shopping complex which has different types of product and they maintain inventory. This Excel sheet contains information about the customers, employees, suppliers, inventory and many other related information. It shows information about the credit card and the purchase done by the admin or inventory. It stores information about the cash receipts, schedule of the employee, transfer of the money, information about each store and also the promotions done for the product. It is hard to maintain the data in Excel so now we can implement it into a database. The data present in Excel sheet can be directly transferred into the database but for that we have to create tables and understand the relationship between each table. There are few errors in the current Excel sheet. The Excel sheet contains supplier information twice. There are few different columns in each of the supplier table. We can combine both the sheets and extract the distinct column from it. Another error which I found was in the purchase admin sheet. In this sheet it shows the name of the supplier, but we can get it into the...