Question: JUST MENTION THE SQL PLUS FUNCTIONS NEEDED TO EXECUTE THE FOLLOWING given here are the list of tables which needs to be created according to


JUST MENTION THE SQL PLUS FUNCTIONS NEEDED TO EXECUTE THE FOLLOWING
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) 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
