Enter the tables in Table 4-15 into a relational DBMS package. Write queries to answer = the following questions. Note: For some questions, you may have to create two que- ries-one to calculate a total and the second to answer the question asked. a. Which customers (show their names) made purchases from Martinez? b. Who has the largest credit limit? c. How many salcs wcre made in October? d. What were the item numbers, price, and quantity of each item sold on in voice num- ber 103? e How much did each salesperson sell?

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
Question
I need the answer as soon as possible
Cestemer
Custormer Custorger Name- City State s Credit Limit
Phoenlx
SU Louis
1000 Smith
AZ
2500
1001 Jones
MO
1500
3002 Jeffries
Atlanta
GA
4000
Phoenix
AZ
5000
1003 Gitkéy
1004 Lankord
20s Zele
1006 Paginozzi
1007 Arocha..
Phoenix
Chicaga
Salt Laké City IUT
Chicago
AZ
2000
IL
2000
3000
IL
1000
E Sales Inventory
nvoice Nuraber Rera Number Ouantikya Extensiorn
Recot afs
ubFte. Search
101
1025
Se9.95
SA9.95
S299.85
S25.95
S19.95
SI,399.90
SE95
$95.95
101
102
1015
nventary
103
103
3010
item Desciption -Unit Cost Unli PriceQiuantity on Hind
$14.00
$12.00
$23.00.
S499.00
$799,00,
$699.00
$45.00
$79.00
$0.00
lofikarSearch
1015
$29.95
1010 Blender
1015 Toaster
1020 Mixer
1025 Television
1030 Freezer
1035 Refrigerntor
1040 Radio
1045 Cleck
200
103
1025
1025
1019
2.
$19.95
$a3.95
$699.95
200
300
104
250
204
1.
74
105
. ...
$999.95
$449.95
579.95
$99.95
$0.00
32
$99.95
$399.95
106
3015
25
107
100
107
300
107
S159.50
$193.90
Se99,95
$99.55
$0.00
107
1045
2.
ae o9
108
1015
Recori H17 of 17
hPalSeanth
Sdes
Svolee Murmber r Amoint
Oate SalespersonCustomer Nomber
101
10/3/2018 witsoh
$1549.90
$299.95
10/5/2018 Mahomet.
30/s/2018 Jackeson
202
1003
J03
204
10/15/2018 Drezen
10/15/2018 Maninez
10/16/2018 Martiner
10/29/201s Mahomét.
1/3/201s Martinei
100
5799.90
305
$99.95
$2,209.70
107
1000
H S Sardh
Enter the tables in Table 4-15 into a relational DBMS package. Write queries to answer
4.5
the following questions. Note: For some questions, you may have to create two que-
ries-one to calculate a total and the second to answer the question asked.
a. Which customers (show their names) made purchases from Martinez?
b. Who has the largest credit limit?
c. How many salcs wcre made in October?
d. What were the item numbers, price, and quantity of each item sold on in voice num-
ber 103?
e. How much did each salesperson sell?
f. How many customers live in Arizona?
g. How much credit does cach customer still havc available?
CHAPIER 4 ALLAIIV
h. How much of cach item was sold? (Include the description of each item inyour answer.)
i, Which customers still have more than S1.000 in available credit?
j. For which items are there at least 100 units on hand?
Transcribed Image Text:Cestemer Custormer Custorger Name- City State s Credit Limit Phoenlx SU Louis 1000 Smith AZ 2500 1001 Jones MO 1500 3002 Jeffries Atlanta GA 4000 Phoenix AZ 5000 1003 Gitkéy 1004 Lankord 20s Zele 1006 Paginozzi 1007 Arocha.. Phoenix Chicaga Salt Laké City IUT Chicago AZ 2000 IL 2000 3000 IL 1000 E Sales Inventory nvoice Nuraber Rera Number Ouantikya Extensiorn Recot afs ubFte. Search 101 1025 Se9.95 SA9.95 S299.85 S25.95 S19.95 SI,399.90 SE95 $95.95 101 102 1015 nventary 103 103 3010 item Desciption -Unit Cost Unli PriceQiuantity on Hind $14.00 $12.00 $23.00. S499.00 $799,00, $699.00 $45.00 $79.00 $0.00 lofikarSearch 1015 $29.95 1010 Blender 1015 Toaster 1020 Mixer 1025 Television 1030 Freezer 1035 Refrigerntor 1040 Radio 1045 Cleck 200 103 1025 1025 1019 2. $19.95 $a3.95 $699.95 200 300 104 250 204 1. 74 105 . ... $999.95 $449.95 579.95 $99.95 $0.00 32 $99.95 $399.95 106 3015 25 107 100 107 300 107 S159.50 $193.90 Se99,95 $99.55 $0.00 107 1045 2. ae o9 108 1015 Recori H17 of 17 hPalSeanth Sdes Svolee Murmber r Amoint Oate SalespersonCustomer Nomber 101 10/3/2018 witsoh $1549.90 $299.95 10/5/2018 Mahomet. 30/s/2018 Jackeson 202 1003 J03 204 10/15/2018 Drezen 10/15/2018 Maninez 10/16/2018 Martiner 10/29/201s Mahomét. 1/3/201s Martinei 100 5799.90 305 $99.95 $2,209.70 107 1000 H S Sardh Enter the tables in Table 4-15 into a relational DBMS package. Write queries to answer 4.5 the following questions. Note: For some questions, you may have to create two que- ries-one to calculate a total and the second to answer the question asked. a. Which customers (show their names) made purchases from Martinez? b. Who has the largest credit limit? c. How many salcs wcre made in October? d. What were the item numbers, price, and quantity of each item sold on in voice num- ber 103? e. How much did each salesperson sell? f. How many customers live in Arizona? g. How much credit does cach customer still havc available? CHAPIER 4 ALLAIIV h. How much of cach item was sold? (Include the description of each item inyour answer.) i, Which customers still have more than S1.000 in available credit? j. For which items are there at least 100 units on hand?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
SQL Query
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.
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