Answered You can hire a professional tutor to get the answer.
While analyzing the application, Jennifer identifies the following entities and their attributes: Customer:
•••••••••••••••••••••••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]
