INSTRUCTION Need to develop application using C \# as programming language and MSSQL as database. Students are required to develop a system that must have database manipulations such as add, update, delete and view. The system that is required to be developed is as follows: Bank Curiduit Berhad gives loans to the public. A member of the public can go to a branch of the bank to abolv for a loan. The tvoe of loans aiven varies: The current Base Lending Rate (BLR) for Malaysia is 6.40%. A client is considered ineligible if the minimum monthly payment for a type of loan exceeds the percentage of the monthly income. When a client is eligible to take a loan, the system needs to find the following information and put them inside a table: Month, Starting Balance, Principal Paid, Interest Paid, Total Interest and New Balance. The formulae for all those are as follows: There are 3 main things you need when calculation amortization. They are the principal amount of the loan, the interest rate, and the loan term. You also need the amount of the monthly payment amount. For the purpose, the loan details can be said as follows: - Principal amount outstanding = RM100,000. Thus, P=100000. - Interest rate is 6% yearly. The monthly interest rate is mir =0.06/12=0.005 - Loen term is 3 years or 36 months, therefore numMonths =36. Putting in these values, you should be getting the monthly instalment amount by using this formula: Monthly Instalment Amount =P[(1+mir)rumNMonths1mir(1+mir)mumMonths] Or, in this case A=100000[(1+0.005)2610.005(1+0.005)20]=3040.47 Besides finding the monthly instalment amount, you need to find the - Opening (Starting) balance of each month (reducing value) = Starting Balance = Closing Balance of the Previous Month - Principal Paid (increasing value) = Monthly Instalment Amount - Interest Paid - Interest Paid (reducing value) = Monthly Interest Rate * Opening Balance - Total Interest (increasing value), and = Previous Interest Value + Current Month Interest value - Closing (New) balance of each month (reducing value) = Opening Balance - Principal Paid for the Current Month An example of the output can be seen as the figure below Principal Interest Rate Yeas Monthly lnstalnent $3.042.19 You need to put also the Client ID, the name of the client and place them (besides other important information) into a table. The bank officer may delete, update and view the record of a client. Need to identify the core modules or functionalities to be developed for the project specified