(JUST 4 IGNORE 3)

JUST MENTION THE SQL PLUS FUNCTIONS NEEDED TO EXECUTE THE FOLLOWING COMMANDS

given here are the list of tables which needs to be created according to a set of constraints

which are given below [code in Bank_Master should be like SBI_VLR, SBI_KPD for State Bank for India and IND_VIT, IND_CHN for Indian Bank etc. Country need not be added in address, considering bank and customer only in India. CID of customer is a unique number generated instead of using the aadhar number in other tables. Anyremarks of customer is a description of the customer like School Teacher or Farmer. Account type should be savings/ current/ or any relevant. Loan type should be vehicle/house/education/personal. Online deposits type is RD/VRD/PPF/FD and refno is a unique number. In Transactions_withinbank TID is a unique number of each transaction, and ID will be like AID,LNO,Refno meaning that it is related to that account/loan/deposits and type will be credit or debit(C/D). And status will be declined or failed or success. after creating the tables make the following alterations which is mentioned in the question

Bank_Master(Code, Name, Address \{doorno, street ,landmark, city, state, pincode\} Customer (CID, Aadharno, Name, Address \{doorno, street, landmarks, city, state, pincode\}, DoB, anyremarks) Account( AID, type, balance, bank_code, CID) Loan (LNO, type, Amount_sanctioned, balance,bank_code,CID) Online_deposits(Refno, Type, startdate, period, CID, Int_percen,bank_code) Transactions_withinbank(ID , type, ID, amount, date_time, status) 3. Print the CID, customer name( with left padding c 4. Print the bank codes replacing B with K. 10. Find the average balance of a given CID. 11. Find the maximum length of customer name available in the database. 12. Print the amount_santioned of the loan as a rounded value.[rounded to 2 decimal points] and balance as a ceiled value. 13. Print the standard deviation in balance of account in CUB(city union bank). 14. Insert date to startdate column in the format dd/mm/yyyy' using function. 15. Find the number of loans a customer have