ORDERLINE Order ID ProductID Ordered Quality 1001 1 2 1001 2 2 1001 4 1 1002 3 5 1003 3 3 1004 6 2 1004 8 2 1005 4 4 1006 4 1006 5 2 1006 7 2 1007 1 3 1007 2 2 1008 3 3 1008 8 3 1009 4 2 1009 7 3 1010 8 10 PRODUCT Product ID Product Description | ProductFinish | ProductStandard Price | ProductlineID 1 2 End Table Coffee Table Natural Ash Cherry 175 1 200 2 3 Computer Desk | Natural Ash 375 2 4 Entertainment Natural 650 3 Center Maple 5 Writers Desk Cherry 325 1 B 8-Drawer Desk White Ash 750 2 7 Dining Table Natural Ash 800 2 B Computer Desk Walnut 250 3 CUSTOMER CustomerID CustomerName Customer Address CustomerCity CustomerState CustomerPostalCode 1 Contemporary 1355 S Hines FL Gainesville 32601-2871 Casuals Blvd 2 Value Furniture 15145 S.W. Plaro TX 75094-7743 3 Home 17th St 1900 Allard Albany NY 12209-1125 Furnishings Ave. 4 Eastern Furniture 1925 Beltline Carteret NJ 07006-3188 Rd. 1 5 Impressions 5585 Westcott Sacramento CA 94206-4066 Ct. 6 Furniture 325 Flatiron Dr. Boulder CO 80514-4432 Gallery 7 Period 394 Rainbow Seattle WA 97954-5589 Furniture Dr. 8 Califomia 816 Peach Rd. Santa Clara CA 98915-7754 Classics 9 M and H Casual 3709 First Street Clearwater FL 34620-2314 Furniture 10 Seminole 2400 Rocky Seminole FL 34646-4423 Interiors Point Dr. 11 American 2424 Missouri Prospect NJ 07508-5621 Euro Lifestyles Ave N. Park 12 Battle Creek 345 Capitol Battle Creek M 49015-3401 Furniture 13 Heritage Ave. SW 66789 Colege Carlisle PA 17013-8834 Furnishings Ave. 14 Kaneohe 112 Kiowal St. Kaneohe HI 96744-2537 Homes 15 Mountain 4132 Main Ogden UT 84403-4432 Scenes Street ORDER OrderID OrderDate Customer l 1001 21/Oct/15 1 1002 21/Oct/15 B 1003 22/Oct/15 15 1004 22/Oct/15 5 1006 24/Oct/15 3 1006 24/Oct/15 2 1007 27/Oct/15 11 1008 30/Oct/15 12 1009 05/Now/15 1010 06/Nov/15 4 1
ORDERLINE Order ID ProductID Ordered Quality 1001 1 2 1001 2 2 1001 4 1 1002 3 5 1003 3 3 1004 6 2 1004 8 2 1005 4 4 1006 4 1006 5 2 1006 7 2 1007 1 3 1007 2 2 1008 3 3 1008 8 3 1009 4 2 1009 7 3 1010 8 10 PRODUCT Product ID Product Description | ProductFinish | ProductStandard Price | ProductlineID 1 2 End Table Coffee Table Natural Ash Cherry 175 1 200 2 3 Computer Desk | Natural Ash 375 2 4 Entertainment Natural 650 3 Center Maple 5 Writers Desk Cherry 325 1 B 8-Drawer Desk White Ash 750 2 7 Dining Table Natural Ash 800 2 B Computer Desk Walnut 250 3 CUSTOMER CustomerID CustomerName Customer Address CustomerCity CustomerState CustomerPostalCode 1 Contemporary 1355 S Hines FL Gainesville 32601-2871 Casuals Blvd 2 Value Furniture 15145 S.W. Plaro TX 75094-7743 3 Home 17th St 1900 Allard Albany NY 12209-1125 Furnishings Ave. 4 Eastern Furniture 1925 Beltline Carteret NJ 07006-3188 Rd. 1 5 Impressions 5585 Westcott Sacramento CA 94206-4066 Ct. 6 Furniture 325 Flatiron Dr. Boulder CO 80514-4432 Gallery 7 Period 394 Rainbow Seattle WA 97954-5589 Furniture Dr. 8 Califomia 816 Peach Rd. Santa Clara CA 98915-7754 Classics 9 M and H Casual 3709 First Street Clearwater FL 34620-2314 Furniture 10 Seminole 2400 Rocky Seminole FL 34646-4423 Interiors Point Dr. 11 American 2424 Missouri Prospect NJ 07508-5621 Euro Lifestyles Ave N. Park 12 Battle Creek 345 Capitol Battle Creek M 49015-3401 Furniture 13 Heritage Ave. SW 66789 Colege Carlisle PA 17013-8834 Furnishings Ave. 14 Kaneohe 112 Kiowal St. Kaneohe HI 96744-2537 Homes 15 Mountain 4132 Main Ogden UT 84403-4432 Scenes Street ORDER OrderID OrderDate Customer l 1001 21/Oct/15 1 1002 21/Oct/15 B 1003 22/Oct/15 15 1004 22/Oct/15 5 1006 24/Oct/15 3 1006 24/Oct/15 2 1007 27/Oct/15 11 1008 30/Oct/15 12 1009 05/Now/15 1010 06/Nov/15 4 1
Chapter4: Analyzing And Charting Financial Data
Section: Chapter Questions
Problem 2.12CP
Related questions
Question
100%
First, Download a DBMS software (Oracle, MySQL,…, ) to your
computer, create the schema of FURNITURE
as presented in the handout. Note:You should print out the result of final tables.
Transcribed Image Text:ORDERLINE
Order ID
ProductID
Ordered Quality
1001
1
2
1001
2
2
1001
4
1
1002
3
5
1003
3
3
1004
6
2
1004
8
2
1005
4
4
1006
4
1006
5
2
1006
7
2
1007
1
3
1007
2
2
1008
3
3
1008
8
3
1009
4
2
1009
7
3
1010
8
10
PRODUCT
Product ID Product Description | ProductFinish | ProductStandard Price | ProductlineID
1
2
End Table
Coffee Table Natural Ash
Cherry
175
1
200
2
3
Computer Desk | Natural Ash
375
2
4
Entertainment
Natural
650
3
Center
Maple
5
Writers Desk
Cherry
325
1
B
8-Drawer Desk
White Ash
750
2
7
Dining Table Natural Ash
800
2
B Computer Desk
Walnut
250
3
Transcribed Image Text:CUSTOMER
CustomerID CustomerName Customer Address CustomerCity CustomerState CustomerPostalCode
1 Contemporary
1355 S Hines
FL
Gainesville
32601-2871
Casuals
Blvd
2
Value
Furniture
15145 S.W.
Plaro
TX
75094-7743
3
Home
17th St
1900 Allard
Albany
NY
12209-1125
Furnishings
Ave.
4
Eastern
Furniture
1925 Beltline
Carteret
NJ
07006-3188
Rd.
1
5
Impressions 5585 Westcott Sacramento
CA
94206-4066
Ct.
6
Furniture 325 Flatiron Dr.
Boulder
CO
80514-4432
Gallery
7
Period
394 Rainbow
Seattle
WA
97954-5589
Furniture
Dr.
8
Califomia
816 Peach Rd. Santa Clara
CA
98915-7754
Classics
9
M and H
Casual
3709 First
Street
Clearwater
FL
34620-2314
Furniture
10
Seminole
2400 Rocky
Seminole
FL
34646-4423
Interiors
Point Dr.
11
American
2424 Missouri
Prospect
NJ
07508-5621
Euro
Lifestyles
Ave N.
Park
12
Battle Creek
345 Capitol Battle Creek
M
49015-3401
Furniture
13
Heritage
Ave. SW
66789 Colege
Carlisle
PA
17013-8834
Furnishings
Ave.
14
Kaneohe
112 Kiowal St.
Kaneohe
HI
96744-2537
Homes
15
Mountain
4132 Main
Ogden
UT
84403-4432
Scenes
Street
ORDER
OrderID OrderDate Customer l
1001 21/Oct/15
1
1002 21/Oct/15
B
1003 22/Oct/15
15
1004 22/Oct/15
5
1006 24/Oct/15
3
1006 24/Oct/15
2
1007 27/Oct/15
11
1008 30/Oct/15
12
1009 05/Now/15
1010 06/Nov/15
4
1
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning