Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

. (Normalize these tables). Store System Table Name: Product ProductCode Product_name Unit_Price P1 Noodles 30 P2 Rice 900 P3 Coffee 400 P4 Oil 200 P5

. (Normalize these tables). 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

More Books

Students also viewed these Databases questions