5. Get customer names for customers who have an account in every bank.

6. Get customer names for customers who have an account in every bank except Royal and France.

7. Get customer names for customers who have an account in every bank that Clark banks without using NOT EXISTS (B MINUS A).

8. Get customer names for customers who have an account in every bank that Clark banks using NOT EXISTS (B MINUS A).

Part1. SQL Queries (60 marks) Use Oracle-VM SOL 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 2 marks. Bank B#Name City Bl England London B2 America New York Account C#B# Balance CI BI1000 B2 2000 B3 3000 B4 4000 C2 BI 2000 2 B2 3000 2 B3 4000 C3 B1 3000 B2 4000 4 B1 4000 C4 B2 5000 B3 Royal Toono B4 France Paris Customer Name Age City Cl Adams 20 London Blake 30 Paris C3 Clark 25 Paris C4 Jones 20 London C3 Smith 30 Toronto