write my assignment 10350

•••••••••••••••••••••••While analyzing the application, Jennifer identifies the following entities and their attributes:Customer:Customer_IDCustomer_NameCustomer_AddressPhone_NumberAccount_NumberAccount_TypeAccount:Account_NumberAccount_TypeCustomer_IDAmount_DebitAmonut_CreditBalanceBranch_CodeBranch_NameBranch_AddressEmployee:Emp_IDEmp_NameEmp_SalaryEmp_AddressPhone_NumberDept_IDDept_NameDept_HeadBased on the preceding entities and attributes, Jennifer creates the structure of the table forstoring customer details, as shown in the following table.Similarly, Jennifer creates the structure of the table for storing account details, as shown in thefollowing table.In addition, Jennifer creates the structure of the table for storing employee details, as shown in thefollowing table.1. Analyze the preceding structures of the tables and identify the problems that you may face whileinserting, deleting, or updating data in these. Justify your answer. [4 Marks]2. How can you solve the problems related to the structures of the preceding tables? [6 Marks]