Answered step by step
Verified Expert Solution
Link Copied!

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.
image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introductory Relational Database Design For Business With Microsoft Access

Authors: Jonathan Eckstein, Bonnie R. Schultz

1st Edition

1119329418, 978-1119329411

More Books

Students also viewed these Databases questions