solve this

Question 4. (40 points) A start-up is working on an online personal financial management system. The goal of the system is to provide the users an opportunity to obtain item-level purchase data from as many sources as possible in order to improve the accuracy of budget management and control activities (instead of only at the level of the total of each purchase). For example, let's assume a customer purchases three books from a major online bookseller. For most financial management software systems, the system only receives the total of the purchase from a bank or other financial institution. In the case of this start-up, the intent is to create a link between the financial transaction and the vendor's system data so that the financial management system retrieves product details from the vendor. Now it will be easy for the customer to classify one book as self-help, the other one as a business expense, and the third one as entertainment without having to resort to an analysis of receipts. To provide this capability, the system maintains the following data regarding the transactions: TransactionID, CustomerlD, CustomerName, CustomerEmiail, TransactionDate, TransactionTime, TransactionTotalAmount, TransactionTax, ProductlD, ProductDeseription, ProductCategory, ProductManufacturerlD, ManufacturerName, ProductlistPrice, ProductPurchasePrice, ProductQuantity, TransactionProductTotal Sample data for this set of attributes is as follows: 823434434582, 2434254, Silver Patrick, psilver@mail.net, 9/2/2018, 10.28.34, $167.23, $10.37, (78234, \"Achieving One's Fullest Potential," self-help, 145432, Brown and Gray, 529.95, 524.75, 1, 524.75 | 4782349, \"Programming Server-side Solutions with Python," Programming, 63453632, Green Yellow, $47.95, $39.99, 2, $79.98 | 242343, "Murder at Eleven," fiction, 145432, Brown and Gray, 514.95, 512.50, 5, 562.50} Note that information regarding specific products is repeated multiple times in the sample data set and each repeated set is separated by the \"|" symbol