ORACLE SQL Question 2

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 BH Name Cit B1 England London B2 America New York B3 Royal-Toronto B4 France Paris Customer 20 LondoC3 B3 4000 C3Clark5Pa B3 5000 C4 Your Lastname 20 London 30 Toronto 1. Get names of the banks in which Blake or Clark has accounts using UNION without duplicates 2. Get the name of the customer who does not have any bank account. 3. Get the name of the customer who has an account in every bank. 4. Get the name of the customer who has an account in every bank except France Bank. 5. Get the name of the customer who has an account in every bank that Clark banks without using NOT EXISTS (B MINUS A) 6. Get the name of the customer who has an account in every bank that Clark banks using NOT EXISTS (B MINUS A)