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 mar Account C#B# | Balance B Name City B1 England London Cl BI 1000 B2 America New York C1B2 2000 B3 Royal Toronto B4 France Paris C1 B33000 C1 B4 4000 C2 BI 2000 C2 B2 3000 Customer Name 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 banks in more than two banks using grouping and aggregate function. 2. Get complete information of each customer such that when the customer has an bank account, list bank detail and balance; when the customer does not have an account, just list the customer information. 3. Get customer names and total balance in all banks. If the customer has no account, leave it null

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!