Scribd
Upload
12 views2 pages

Ice Task 3

Uploaded by

muaazabdoolgaffoor123
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
12 views2 pages

Ice Task 3

Uploaded by

muaazabdoolgaffoor123
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

GIVEN TABLE 1F

OrderID CustomerID CustomerName CustomerAddress ProductID ProductName Category


O330 C567 Ian Holmes 123 Main St P101 Laptop Electronics
O338 C862 Patrick Doe 62 Elm St P544 Office Chair Furniture

O339 C835 Sabrina Gnome 58 Pine St P103 SmartPhone Electronic

FINAL 3F TABLE CustomerNam


OrderID CustomerID OrderDate CustomerID CustomerAddress
e
O330 C567 2024/03/01 C567 Ian Holmes 123 Main St
O338 C862 2024/03/09 C862 Patrick Doe 62 Elm St
O339 C835 2024/03/09 C835 Sabrina Gnome 58 Pine St

ProductID ProductName Category Supplier Supplier SupplierContact


P101 Laptop Electronics TechCorp TechCorp 787 484 918
P544 Office Chair Furniture KingFurn KingFurn 787 484 918
P103 SmartPhone Electronic TechCorp

OrderID ProductID Quantity


O330 P101 1
O338 P544 9
O339 P103 2
Supplier SupplierContact OrderDate Quantity
TechCorp 787 484 918 2024/03/01 1
KingFurn 787 484 918 2024/03/09 9

TechCorp 787 484 918 2024/03/09 2

You might also like