Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create the insert quieres for the checking and saving table with the sql query provided and the excell spreed sheet for each Column. Over draft
Create the insert quieres for the checking and saving table with the sql query provided and the excell spreed sheet for each Column.
Over draft fee Account ID 35 35 35 35 35 35 35 35 35 35 35 35 1 Account Number 2 9104-3652-1244-3666 3 9104-3652-1244-3667 4 9105-0366-9855-6214 s 9106-1566-1423-3698 6 9110-1234-5678-0909 7 9111-4578-3695-5419 8 9110-1234-5678-0911 9 9111-4578-3695-5422 10 9001-1478-2536-9031 11 9111-4578-3695-5417 12 6 9 10 13 9 17 6 9111-4578-3695-5412 13 9111-4578-3695-5414 14 15 18 19 Customer Accounts MoneytMarket Loanoffer Loan Loandayments Branch Banker Cheching 1 Account_number 2 9104-3652-1244-3670 0.015 3 9104-3652-1244-3672 0.015 4 9111-4578-3695-5430 0.015 5 9111-4578-3695-5418 0.025 6 9002-5846-2513-5845 0.025 7 9002-5846-2513-5033 0.025 Interest rate Account ID 8 12 14 15 [9111-4578 3695 5413 10:015 10 15 Customer Accounts MoneyMarket Loanoffer Loan LoanPayments Branch Banker ChechingSavings 90 o Create Table Checking ( 91 Account Number Varchar (45) Not Null, 92 over_Draft_Fee Int (5) Not Null, 93 Account ID Int Not Null, 94 Foreign Key (Account _ID) 95 References Accounts (Account _ID) 96 On Delete Cascade on Update Cascade 97): 98 99 Create Table Savings ( 100 Account Number Varchar (45) Not Null, 101 Interest Rate Decimal (5,) Not Null, 102 Foreign Key (Account _ID) 103 References Accounts (Account ID) 104 On Delete Cascade On Update Cascade 105) 106 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