Question
. (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
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