2. Fill the table by following data: (Insert the dates in this format (DD-MONTH-YYYY) Customer custNo 101 202 303 404 505 606 707 Item Item No 11 22 33 44 55 order_item OrderNo 210 250 220 240 230 cname SARA ABDULAZIZ FATMA ABDULLA OMAR ABDELKAREEM ALI ABDULLA HASSAN ABDULAZIZ SALAH ABDELKAREEM AMMA ABDULAZIZ UnitPrice 1100.75 1200.90 1300.70 1400.95 1500.50 Item No Qty 20 30 40 10 60 11 55 243 22 44 33 City DOHA DOHA KHOR SHAMAL KHOR WAKRA WAKRA Phone 333-444- 111 444-333- 222 555-444- 666 777-444- 222 303-404- 101 404-303- 202 505-404- 606
2. Fill the table by following data: (Insert the dates in this format (DD-MONTH-YYYY) Customer custNo 101 202 303 404 505 606 707 Item Item No 11 22 33 44 55 order_item OrderNo 210 250 220 240 230 cname SARA ABDULAZIZ FATMA ABDULLA OMAR ABDELKAREEM ALI ABDULLA HASSAN ABDULAZIZ SALAH ABDELKAREEM AMMA ABDULAZIZ UnitPrice 1100.75 1200.90 1300.70 1400.95 1500.50 Item No Qty 20 30 40 10 60 11 55 243 22 44 33 City DOHA DOHA KHOR SHAMAL KHOR WAKRA WAKRA Phone 333-444- 111 444-333- 222 555-444- 666 777-444- 222 303-404- 101 404-303- 202 505-404- 606
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
Transcribed Image Text:shipment
Order No WarehouseNo
210
250
220
240
230
Warehouse
WarehouseNo City
WH1
WH2
WH3
WH4
WH5
Orders
Order No
210
220
230
240
250
260
WH1
WH2
WH3
WH4
WH5
270
NAJMA
KHOR
DOHA
MUNTZA
RAYAAN
Odate
06-OCTOBER-
2010
03-APRIL-2002 101
09-MARCH-
2004
23-JANYARY-
2001
11-AUGUST-
2008
20-OCTOBER-
2008
23-FEBRUARY-
Ship_date
2008
11-JANUARY-2002
24-FEBRUARY-2010
13-JUNE-2005
16-SEPTEMBER-2009
28-APRIL-2003
CustNo Ord_amt
10000
202
303
404
505
606
707
11000
14000
16000
20000
30000
55000
Transcribed Image Text:2. Fill the table by following data: (Insert the dates in this format (DD-MONTH-YYYY)
Customer
custNo
101
202
303
404
505
606
707
Item
Item No
11
22
33
44
55
cname
SARA
order_Item
Order No
210
250
220
240
230
ABDULAZIZ
FATMA
ABDULLA
OMAR
HASSAN
ABDULAZIZ
SALAH
ABDELKAREEM
ABDELKAREEM
ALI ABDULLA SHAMAL
AMMA
ABDULAZIZ
UnitPrice
1100.75
1200.90
1300.70
1400.95
1500.50
Item No
11
55
22
44
33
City
DOHA
Qty
20
30
40
10
60
DOHA
KHOR
KHOR
WAKRA
WAKRA
Phone
333-444-
111
444-333-
222
555-444-
666
777-444-
222
303-404-
101
404-303-
202
505-404-
606
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 6 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education