List State, Sales Year, Current Year Sales, Last Year Sales, and Change in Total Yearly Sales for Nike between years 2014 and 2015. As the focus is on Nike sales in each state for years 2014 and 2015, for the Last Year Sales and Change in Total Yearly Sales columns include ‘NA’ for sales year 2014. Display result set in ascending order of State. (Note – Please refer to the Department, SKU, Transact, and Store tables.) (Screenshot shown)

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
icon
Related questions
icon
Concept explainers
Question

List State, Sales Year, Current Year Sales, Last Year Sales, and Change in Total Yearly Sales for Nike between years 2014 and 2015. As the focus is on Nike sales in each state for years 2014 and 2015, for the Last Year Sales and Change in Total Yearly Sales columns include ‘NA’ for sales year 2014. Display result set in ascending order of State. (Note – Please refer to the Department, SKU, Transact, and Store tables.) (Screenshot shown)

 

 

 

States
AL
AL
AR
AR
AZ
AZ
CA
CA
co
CO
FL
FL
13 GA
1234N
5
6
7
8
a
9
10
FARMASPO***852
11
12
14 GA
15
IA
IA
ID
10 ID
IL
19
20 IL
16
17
21
IN
IN
23 KS
22
26
27
29
30
31
32
KS
KY
KY
LA
LA
MO
MO
MS
MS
Sales Year
2014
2015
2014
2015
2014
2015
2014
2015
2014
2015
2014
2015
2014
2015
2014
2015
2014
2015
2014
2015
2014
2015
2014
2015
2014
2015
2014
2015
2014
2015
2014
2015
Current YearNike Sales
$107.487.30
$123,758.42
$563.152.42
$678,992.33
$393.539.14
$453,398.51
$97.456.05
$117,018.20
$102.180.28
$101.844.88
$561,224.05
$554.666.05
$207,827.94
$215.854.23
$25,718.96
$31.717.25
$32,201.64
$37.668.00
$45.382.76
$43.624.02
$25.547.44
$26,623.37
$116.673.26
$118,759.27
$154.244.22
$162,262.62
$290.357.91
$306,774.05
$139,190.44
$143.523.40
$71,190.55
$79.080.05
Last YearNike Sales
ΝΑ
$107,487.30
NA
$563,152.42
NA
$393,539.14
NA
$97,456.05
NA
$102,180.28
NA
$561.224.05
NA
$207.827.94
NA
$25.718.96
NA
$32.201.64
NA
$45,382.76
NA
$25,547.44
NA
$116,673.26
$154,244.22
$290,357.91
NA
ΝΑ
ΝΑ
$139,190.44
NA
$71.180.55
Change in Nike Total Yearly Sale
ΝΑ
$16,271.12
NA
$115,839.91
NA
$59,859.37
NA
$19,562.15
NA
($335.40)
NA
($6.558.00)
NA
$8.026.29
NA
$5.990.29
ΝΑ
$5,467.16
ΝΑ
($1,757.94)
NA
$1,075.93
NA
$2,086.01
NA
$8,018 40
NA
$16,416.14
NA
$4.332.96
ΝΑ
$7.899.50
Transcribed Image Text:States AL AL AR AR AZ AZ CA CA co CO FL FL 13 GA 1234N 5 6 7 8 a 9 10 FARMASPO***852 11 12 14 GA 15 IA IA ID 10 ID IL 19 20 IL 16 17 21 IN IN 23 KS 22 26 27 29 30 31 32 KS KY KY LA LA MO MO MS MS Sales Year 2014 2015 2014 2015 2014 2015 2014 2015 2014 2015 2014 2015 2014 2015 2014 2015 2014 2015 2014 2015 2014 2015 2014 2015 2014 2015 2014 2015 2014 2015 2014 2015 Current YearNike Sales $107.487.30 $123,758.42 $563.152.42 $678,992.33 $393.539.14 $453,398.51 $97.456.05 $117,018.20 $102.180.28 $101.844.88 $561,224.05 $554.666.05 $207,827.94 $215.854.23 $25,718.96 $31.717.25 $32,201.64 $37.668.00 $45.382.76 $43.624.02 $25.547.44 $26,623.37 $116.673.26 $118,759.27 $154.244.22 $162,262.62 $290.357.91 $306,774.05 $139,190.44 $143.523.40 $71,190.55 $79.080.05 Last YearNike Sales ΝΑ $107,487.30 NA $563,152.42 NA $393,539.14 NA $97,456.05 NA $102,180.28 NA $561.224.05 NA $207.827.94 NA $25.718.96 NA $32.201.64 NA $45,382.76 NA $25,547.44 NA $116,673.26 $154,244.22 $290,357.91 NA ΝΑ ΝΑ $139,190.44 NA $71.180.55 Change in Nike Total Yearly Sale ΝΑ $16,271.12 NA $115,839.91 NA $59,859.37 NA $19,562.15 NA ($335.40) NA ($6.558.00) NA $8.026.29 NA $5.990.29 ΝΑ $5,467.16 ΝΑ ($1,757.94) NA $1,075.93 NA $2,086.01 NA $8,018 40 NA $16,416.14 NA $4.332.96 ΝΑ $7.899.50
Relationship Diagram for DILLARDS Database
SKU (dbo) (Read-
SKU
DEPT
SKU_CLASS
SKU_STYLE
UPC
COLOR
SKU_SIZE
BRAND NAME
CLASSIFICATION
PACKSIZE
TRANSACT (dbo) (
TRANSACTION_ID
TRAN_DATE
STORE
REGISTER
TRAN_NUM
TRAN_TIME
CUST ID
TRAN_LINE_NUM
MIC
TRAN_TYPE
ORIG_PRICE
SALE_PRICE
TRAN_AMT
TENDER TYPE
SKU
DEPARTMENT (dbo)
DEPT
DEPT_DESC
DEPTDEC
DEPTDEC_DESC
DEPICENT
DEPTCENT_DESC
SKU STORE (dbo)
8 STORE
SKU
RETAIL
COST
CUSTOMER (dbo) (Read-on
8 CUST.JD
CITY
STATE
ZIP CODE
ZIP SECSEG
DISTANCE TO NEAREST STORE
PREFERRED STORE
-STORE (dbo) (Rea
STORE
DIVISION
CITY
STATE
ZIP CODE
ZIP SECSEG
Transcribed Image Text:Relationship Diagram for DILLARDS Database SKU (dbo) (Read- SKU DEPT SKU_CLASS SKU_STYLE UPC COLOR SKU_SIZE BRAND NAME CLASSIFICATION PACKSIZE TRANSACT (dbo) ( TRANSACTION_ID TRAN_DATE STORE REGISTER TRAN_NUM TRAN_TIME CUST ID TRAN_LINE_NUM MIC TRAN_TYPE ORIG_PRICE SALE_PRICE TRAN_AMT TENDER TYPE SKU DEPARTMENT (dbo) DEPT DEPT_DESC DEPTDEC DEPTDEC_DESC DEPICENT DEPTCENT_DESC SKU STORE (dbo) 8 STORE SKU RETAIL COST CUSTOMER (dbo) (Read-on 8 CUST.JD CITY STATE ZIP CODE ZIP SECSEG DISTANCE TO NEAREST STORE PREFERRED STORE -STORE (dbo) (Rea STORE DIVISION CITY STATE ZIP CODE ZIP SECSEG
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Query Syntax
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education