Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Part 1. SQL Queries (60 marks) Use Oracle-VM SQL Data Definition Language to create the following Bank-and-Customer database. You should properly define primary keys and
Part 1. SQL Queries (60 marks) 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 2 marks. Bank BName City B1 England London B2 America New York B3 Roval Toronto B4 FranceParis Account BBalance CI B1 1000 CI B2 2000 C1 B3 3000 C1 B4 4000 C2 B1 2000 C2 B2 3000 C2 B34000 Customner CH Name Age . City C1 Adams 20 London C2 Blake 30 ParisC C3 Clark 25 Paris C4 Jones 20 London C5 Smith 30 Toronto C3 B24000 C4 B4000 C4 B25000
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started