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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!