Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using Oracle SQLPLUS for the following: A. Populate them with given test data to that is relevant to the questions listed below. List the screenshots

Using Oracle SQLPLUS for the following:

A. Populate them with given test data to that is relevant to the questions listed below. List the screenshots of the SQL Command used and the overall rows of the table with image of it resulting output. Include the screenshot of the INSERT SQL Statement used to populate table data along with the TABLE's CONTENT displayed using SELECT statements.

Store System

Table Name: Product

ProductCode

Product_name

Unit_Price

P1

Noodles

30

P2

Rice

900

P3

Coffee

400

P4

Oil

200

P5

Biscuits

60

P6

Dishwasher

90

Table Name: Order Details

Order

_id

Product

_id

Custom

er_id

Customer_nam

e

Customer _address

Order_date

Quantity

Ord1

P3

C1

Saroj Karki

Add1

2020-01-20

3

Ord1

P4

C1

Saroj Karki

Add1

2020-01-20

4

Ord2

P5

C2

Rohit Pandey

Add2

2020-04-05

2

Ord3

P3

C1

Saroj Karki

Add2

2020-04-05

1

Ord4

P2

C3

Santos Katuwal

Add3

2020-06-25

5

Ord4

P4

C3

Santos Katuwal

Add4

2020-06-25

4

Ord4

P1

C3

Santos Katuwal

Add2

2020-06-25

4

Ord5

P6

C4

Bidur Khanal

Add1

2020-07-21

2

Ord6

P6

C5

Kusum Tamang

Add5

2020-07-08

1

Ord7

P3

C3

Santos Katuwal

Add5

2020-04-03

6

Table Name: Address

Address_i d

Country

Zone

City

Add1

Nepal

Koshi

Itahari

Add2

Nepal

Mechi

Jhapa

Add3

Nepal

Bagmati

Kathmandu

Add4

Nepal

Bagmati

Lalitpur

Add5

Nepal

Koshi

Dharan

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

Advances In Databases And Information Systems 22nd European Conference Adbis 2018 Budapest Hungary September 2 5 2018 Proceedings Lncs 11019

Authors: Andras Benczur ,Bernhard Thalheim ,Tomas Horvath

1st Edition

3319983970, 978-3319983974

More Books

Students also viewed these Databases questions

Question

=+1 Is the decision fair to employees?

Answered: 1 week ago