Question
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
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
JUST MENTION THE ALTER COMMANDS AND CONSTRAINTS WHICH IS GETTING ASKED IN THE QUESTION NOTHING MORE NEED NOT GIVE THE ENTIRE CODE
Bank_Master(Code, Name, Address \{doorno, street ,landmark, city, state, pincode\}) Customer ( ID, 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(TID, type, ID, amount, date_time, status) Alter commands and Constraints. 1. Identify the foreign keys and add to the table Account, Loan. 2. Create the table Online deposits and Transactions again with foreign key and not null on amount (Drop the existing table. Store the values in a temporary table and put back to newly created table). 3. Change the data type of status in Transactions table (varchar number or number to varchar), and do the necessary process for updating the table with new values
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started