The general background is same as for Assignment 1. However the focus recently has shifted to the loans aspect of the Spock Bank because of the banking royal commission. For your convenience, the following information is provided as part of the domain description: 1. Relevant business rules (slightly altered) 2. A simplified entity-relationship data model for the problem domain. In this, X -Y represents a many-one relationship between object X and object \Y 3. A corresponding relational model/schema is also provided. Business rules applicable to loans at Spock Bank: Each customer is provided with a unique identifier. Details of a customer include: name address, contact number, email address, and join date An account can be one of three types: SAV (savings), CHK (Checking) or LON (Loan) Each type of account has a unique identifier. Each account type needs to include: name (e.g., SAV/ CHK/ LON), a description, interest rate that customers receive on deposits, and a yearly service fee. No interest is paid for any money left in Loan accounts. * An account is identified by a combination of BSB and an account number. Details of account such as type of the account and current balance are stored. A loan can be one of three types: HL (Home Loan), IL (Investment Loan) and PL (Personal Loan). Each type of loan has a unique identifier. Each loan type needs to include: name (e.g., HL/IL/ PL) and description A loan is identified by a unique identifier. Details of loan such as interest rate customers pay and total (original, not outstanding) loan amount are stored. * Every loan repayment is identified by a repayment identifier. Other details of the repayment would include: the loan that the repayment is for, repayment amount, and date and time of repayment. An account type may have multiple accounts. An account will be of only one particular type. * A customer may have multiple accounts. An account could be shared by multiple customers joint account) A loan type may have multiple loans. A loan will be of only one particular type Every loan is associated with an account. An account may not be linked with a loan. A repayment is done for a particular loan. A loan may have multiple repayments. * * *