Given the following Bank-Customer database with three tables that represent banks, customers, and customers' accounts in...

Transcribed Image Text:

Given the following Bank-Customer database with three tables that represent banks, customers, and customers' accounts in banks. The primary keys are underlined and foreign keys are obvious. Write an Embedded SQL program that uses Dynamic SQL method 1 to create the database. You can hard code all create table statements in the program using the execute immediate statement. Bank B# Name City B1 England London B2 Deutsche Berlin B3 Royal Toronto B4 France Paris Customer C# Name Age City C1 Adams 20 London Paris C2 Blake 30 C3 Clark 25 Paris C4 Jones 20 London C5 Smith 30 Toronto Account C# B# CI BI C1 B2 C1 B3 C1 B4 C2 B1 C2 B2 C2 B3 C3 B1 C3 B2 C4 B1 C4 B2 Balance 1000 2000 3000 4000 2000 3000 4000 3000 4000 4000 5000 Given the following Bank-Customer database with three tables that represent banks, customers, and customers' accounts in banks. The primary keys are underlined and foreign keys are obvious. Write an Embedded SQL program that uses Dynamic SQL method 1 to create the database. You can hard code all create table statements in the program using the execute immediate statement. Bank B# Name City B1 England London B2 Deutsche Berlin B3 Royal Toronto B4 France Paris Customer C# Name Age City C1 Adams 20 London Paris C2 Blake 30 C3 Clark 25 Paris C4 Jones 20 London C5 Smith 30 Toronto Account C# B# CI BI C1 B2 C1 B3 C1 B4 C2 B1 C2 B2 C2 B3 C3 B1 C3 B2 C4 B1 C4 B2 Balance 1000 2000 3000 4000 2000 3000 4000 3000 4000 4000 5000

Answer rating: 100% (QA)

Hi I am running three execute immediate commands to create three tab... View the full answer