Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

CustID Cust Type City PostalCode SalesOrderNum ProductID OrderQty LineTotal ProductName ProductLine ProductListPrice 6 9 7 S Tooele 8 4 0 7 4 SO 5 0

CustID
Cust Type
City
PostalCode
SalesOrderNum
ProductID
OrderQty
LineTotal
ProductName
ProductLine
ProductListPrice
697
S
Tooele
84074
SO50270
863
44
639.3717
Full-Finger Gloves, L
M
37.99
146
L
Seattle
98104
SO67266
869
41
1097.6182
Women's Mountain Shorts, L
A
69.99
697
S
Tooele
84074
SO51783
867
40
1259.82
Women's Mountain Shorts, S
A
69.99
546
L
Loveland
80537
SO57186
869
40
1259.82
Women's Mountain Shorts, L
A
69.99
546
L
Loveland
80537
SO48089
863
39
666.7245
Full-Finger Gloves, L
M
37.99
146
L
Seattle
98104
SO67266
867
38
1196.829
Women's Mountain Shorts, S
A
69.99
697
S
Tooele
84074
SO51783
869
36
1133.838
Women's Mountain Shorts, L
A
69.99
302
S
Offenbach
63009
SO51109
864
36
1028.7
Classic Vest, S
S
63.5
125
S
Stamford
06901
SO46610
863
35
598.3425
Full-Finger Gloves, L
M
37.99
315
S
Merritt Island
32952
SO46673
863
35
598.3425
Full-Finger Gloves, L
M
37.99
Column Name
Explanation
Column Name
Explanation
CustID
id used for each customer -- always 3 digits
OrderQty
quantity of product ordered
Cust Type
single letter code for differentiating types of customer
LineTotal
total charge for product ordered
City
city of shipping address for order (shortest is 5 letters and longest is 15 letter)
ProductName
name of product
PostalCode
zip code of shipping address for order -- always 5 digits
ProductLine
single letter code for differentiating types of products
SalesOrderNum
unique number for each order always 2 letters and 5 digits
ProductListPrice
list price of product
ProductID
id of each product -- always 3 digits
The themes have been identified as:
CUSTOMER
ORDER
PRODUCT
PRODUCT ORDERED
Select ALL columns that belong to the theme: CUSTOMER.
Note: One or more choices is correct. Incorrect choices will be marked negatively

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

SQL Antipatterns Avoiding The Pitfalls Of Database Programming

Authors: Bill Karwin

1st Edition

1680508989, 978-1680508987

More Books

Students also viewed these Databases questions

Question

How is the NDAA used to shape defense policies indirectly?

Answered: 1 week ago