Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning C# 2005 Databases

Authors: Karli Watson

1st Edition

0470044063, 978-0470044063

More Books

Students also viewed these Databases questions

Question

Explain the contribution of Peter F. Drucker to Management .

Answered: 1 week ago

Question

What is meant by organisational theory ?

Answered: 1 week ago

Question

What is meant by decentralisation of authority ?

Answered: 1 week ago

Question

Briefly explain the qualities of an able supervisor

Answered: 1 week ago

Question

Know how to use reservations systems to inventory demand.

Answered: 1 week ago