ORACLE SQL 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 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 BNameCity B1 England London B2 America New York B3 Royal-Toronto B4 France Paris CI BI 1000 CI B2 2000 C1 B33000 C2 B 2000 C2 B2 3000 C3 B2 3000 20 LondoC3 B3 4000 C2 Blake 30 ParisC4 2 4000 Customer C Adams C3Clark5Pa B3 5000 C4 Your Lastname 20 London 30 Toronto Get the name of the customer who banks in Royal bank using EXISTS Get the name of the customer who has an account with balance less than 3000 Get the name of the customer who banks in Royal or America bank. Get the name of the bank that "Your Lastname" banks Get the customer name/bank name pairs such that the indicated customer has an account in the indicated 1. 2. 3. 4. 5. 6. Get the customer name/bank name pairs such that the indicated customer does not an account in the indicated bank