Task for database access "Issuance of bank loans."
Description of the subject area
You are the head of the information and analytical center of a commercial bank. One of the significant activities of your bank is the issuance of loans to legal entities. Your task is to monitor the dynamics of the credit department. Depending on the conditions for obtaining a loan, the interest rate and the repayment period, all credit operations are divided into several main types. Each of these species has its own name. The loan can be obtained by a legal entity (client), who provided the following information upon registration: name, type of property, address, telephone, contact person. Each fact of the loan is registered by the bank, while the loan amount, the client and the date of issue are fixed.
Types of loans (Type Code, Title, Conditions of Receipt, Rate, Term).
Clients (Customer code, Title, Property type, Address, Telephone, Contact person).
Credits (View code, Customer code, Amount, Issue date).
The development of the formulation of the problem
Now the situation has changed. After carrying out of various researches it was found out, that the used system does not allow to trace dynamics of return of credits. In order to eliminate this shortcoming, you decided to take into account the date of the actual refund in the system. It should also be taken into account that the loan can be extinguished in installments, and for the delay in repaying the loan, fines are charged. Add changes to the table structure that take into account these facts, and modify existing queries. Add new queries.