Question: just mention the function for executing the following command given here are the list of tables which needs to be created according to a set

 just mention the function for executing the following command given here

are the list of tables which needs to be created according to

just mention the function for executing the following command

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) 5. Translate all the VIT in landmark column (Bank_MASTER) to VTOP and display. 6. Display the account details, if any balance is null, print as ' 0 ' value. 7. Display the address of customer, if any component is null, print 'not provided'. 8. Print the date time in the format '27th June 202213H:24M. 9. Find the maximum balance and the CID

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!