Question: Use Oracle-VM SQL Data Definition Language to create the following Bank-and-Customer database. You should properly define primary keys and foreign keys and then use SQL

 Use Oracle-VM SQL Data Definition Language to create the following Bank-and-Customer

Use Oracle-VM SQL Data Definition Language to create the following Bank-and-Customer database. You should properly define primary keys and foreign keys and then use SQL Query Language to express the following queries. In the document that you submit, you should have the question with its number, SQL query, and query result generated by Oracle-VM for each question. Each query is 3 marks and the result is C#B# | Balance Cl BI 1000 CI B2 2000 C1 B33000 BH Name Cit B1 England London B2 America New York B3 Royal Toronto B4 France Paris C2 BI 2000 C2 B2 3000 Customer 20||London | C3 B2 3000 CB31 4000 C3 B3 4000 CL Adams 2 Blake30 Paris 4000 C4 B35000 C4 Your Lastname 20 London 30 Toronto 1. Get the name of the customer who has an account in every Dank. 2. Get the name of the customer who has an account in every bank except France Bank. 3. Get the name of the customer who has an account in every bank that Clark banks without using NOT EXISTS (B MINUS A) 4. Get the name of the customer who has an account in every bank that Clark banks using NOT EXISTS (B MINUS A)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!