Question: pls adjust these image is not getting horizontal given here are the list of tables which needs to be created according to a set of

pls adjust these image is not getting horizontal
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
Get step-by-step solutions from verified subject matter experts
