Answered step by step
Verified Expert Solution
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
S
Tooele
SO
FullFinger Gloves, L
M
L
Seattle
SO
Women's Mountain Shorts, L
A
S
Tooele
SO
Women's Mountain Shorts, S
A
L
Loveland
SO
Women's Mountain Shorts, L
A
L
Loveland
SO
FullFinger Gloves, L
M
L
Seattle
SO
Women's Mountain Shorts, S
A
S
Tooele
SO
Women's Mountain Shorts, L
A
S
Offenbach
SO
Classic Vest, S
S
S
Stamford
SO
FullFinger Gloves, L
M
S
Merritt Island
SO
FullFinger Gloves, L
M
Column Name
Explanation
Column Name
Explanation
CustID
id used for each customer always 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 letters and longest is letter
ProductName
name of product
PostalCode
zip code of shipping address for order always digits
ProductLine
single letter code for differentiating types of products
SalesOrderNum
unique number for each order always letters and digits
ProductListPrice
list price of product
ProductID
id of each product always 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
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