Question: Create the insert quieres for the account table with the sql query provided and the excell spreed sheet for each Column. 40 Create Table Accounts
40 Create Table Accounts ( 41 Account ID Int (12) Not Null Primary Key, 42 Account Number Varchar (45) Not Null, 43 Balance Decimal (15,2) Not Null, 44 Cust ID Int (12), 45 Category ENUM ("Checking", "Saving"), 46 Branch ID Varchar (10), 47 Foreign Key (Cust_ID) 48 References Customer (Cust ID) 49 On Delete Cascade on Update Cascade, 50 Foreign Key (Branch ID) 51 References Branch (Branch ID) 52 On Delete Cascade On Update Cascade 53); Balance Customer Id Category Branch ID Account ID Account Number NOVA1 NOVA1 2 Checking NOVA2 NOVA3 3 Saving NOVA3 4 Checking NOVA6 NOVAS 1 9104-3652-1244-3666 5000.5 1 Checking 1 Saving 3 Checking 5Checking 29104-3652-1244-3670 10000.35 400.75 3 9104-3652-1244-3667 49105-0366-9855-6214 1785.25 5 9104-3652-1244-3672 15000.62 300 6000 76 9106-1566-1423-3698 9110-1234-5678-0909 8 9111-4578-3695-543012500 9 9111-4578-3695-5419 900.5 9 Saving NOVA 10 Checking NOVAS 10 9110-1234-5678-0911 250000 7 Checking NOVA4 NOVA9 NOVA7 NOVA5 13 SavingNOVA5 12 13 1413 9001-1478-2536-9031 15 11 9111-4578-3695-5422 12 9111-4578-3695-5418 200 1500 450000 15.95 15.35 8 Checking 8 Saving 13 CheckingNO 149002-5846-2513-5845 15 9002-5846-2513-5033 169111-4578-3695-5417 17 9111-4578-3695-5412 18 9111-4578-3695-5413 19 9231-4578-3695-5414 8000 SavingNOVA8 9 Checking NULL 12 CheckingNULL 17 1000 250 20 6 Checking NULL 20 9231-4578-3695-5415 15500.5 219231-4578.3695-5416| 59950.35| 22 9231-4578 3695 5417985000 23 9231-4578-3695-54184550 24 9231-4573695-5419 25 9231-4578-3695-5420 26 9231-4578-3695-5421 2555501 17 Money MarketNOVA8 19|Money MarkeNOVA1 18 Money Market NOVAS 15 Money Marke NOVA7 1800000.414 Money Market NOVA4 2 Money Marke NOVAS 4 Money Market NOVA6 3600 Customer Accounts MoneyMarket LoanOffer Loan LoanPayments Branch Banke
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
