Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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 Martincz? b. Who has the largest credit limit? c. How many sales were made in October? d. What were the item numbers, price, and quantity of cach 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 each customer stillI have available?

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 Martincz? b. Who has the largest credit limit? c. How many sales were made in October? d. What were the item numbers, price, and quantity of cach 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 each customer stillI have available?

Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter11: Database Performance Tuning And Query Optimization
Section: Chapter Questions
Problem 2P: Problem 1 and 2 are based on the following query: SELECT EMP_LNAME, EMP_FNAME, EMP_AREACODE, EMP_SEX...
See similar textbooks
icon
Related questions
Question
4.5 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 sales were 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 each customer stillI have available? Customer Customer - Customer Name. 1000 Smith 1001 Jones 1002 Jeffries 1003 Gilkey City State -Credit Limit - Phoenix AZ 2500 St. Louls Atlanta мо 1500 GA 4000 Phoenix AZ 5000 1004 Lankford Phoenix AZ 2000 1005 Zeile 1006 Pagnozzi 1007 Arccha Chicago Salt Lake City UT Chicago 2000 3000 IL 1000 Sales inventory Record 69 Search Invoice Number. - Quantity Item Number Extension. 101 1025 S99.95 $849.95 $299.85 $29.95 101 1035 102 1045 eventory 103 1010 1 - Description- 1010 Blender 1015 Toaster 1020 Mixer 1025 Television 1030 Freezer Item# Unit Cost. Unit Price. Quantity on Hand. 103 1015 $19.95 $14.00 $12.00 $23.00 S499.00 $29.95 200 103 1025 $1,399.90 SE99.95 $99.95 $849.95 $19.95 300 104 1025 $33.95 250 1045 1035 104 S699.95 74 105 S799.00 S999.95 32 106 1045 $99.95 S999.95 $849.95 Se99.00 $349.95 1015 Refrigerator 1040 Radio 1045 Clock 25 107 1030 S45.00 S79.95 100 107 1035 1. $79.00 $0.00 $99.95 300 107 $159.90 $199.90 $699.95 1040 $0.00 107 1045 2. Record 4 of9 hofe Search 108 1025 108 1045 $99.95 $0.00 Recond 17 of 17 ie fites earch Sales Invoice Number Salesperson- Customer Number 10//2018 WIbon Date Amount 101 1000 102 10/5/2018 Mahomet 10/5/2018 Jackson 10/15/2018 Dreaen 10/15/2018 Martinez 10/16/2018 Martinaz 10/29/20 Mahomet 11//2018 Martinez 1003 S295.95 103 1002 1000 104 S.90 105 1005 $345.95 106 1007 107 1002 $2.20 100 1000 S779.90 SC.00 49af9 FiteSerch
Transcribed Image Text:4.5 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 sales were 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 each customer stillI have available? Customer Customer - Customer Name. 1000 Smith 1001 Jones 1002 Jeffries 1003 Gilkey City State -Credit Limit - Phoenix AZ 2500 St. Louls Atlanta мо 1500 GA 4000 Phoenix AZ 5000 1004 Lankford Phoenix AZ 2000 1005 Zeile 1006 Pagnozzi 1007 Arccha Chicago Salt Lake City UT Chicago 2000 3000 IL 1000 Sales inventory Record 69 Search Invoice Number. - Quantity Item Number Extension. 101 1025 S99.95 $849.95 $299.85 $29.95 101 1035 102 1045 eventory 103 1010 1 - Description- 1010 Blender 1015 Toaster 1020 Mixer 1025 Television 1030 Freezer Item# Unit Cost. Unit Price. Quantity on Hand. 103 1015 $19.95 $14.00 $12.00 $23.00 S499.00 $29.95 200 103 1025 $1,399.90 SE99.95 $99.95 $849.95 $19.95 300 104 1025 $33.95 250 1045 1035 104 S699.95 74 105 S799.00 S999.95 32 106 1045 $99.95 S999.95 $849.95 Se99.00 $349.95 1015 Refrigerator 1040 Radio 1045 Clock 25 107 1030 S45.00 S79.95 100 107 1035 1. $79.00 $0.00 $99.95 300 107 $159.90 $199.90 $699.95 1040 $0.00 107 1045 2. Record 4 of9 hofe Search 108 1025 108 1045 $99.95 $0.00 Recond 17 of 17 ie fites earch Sales Invoice Number Salesperson- Customer Number 10//2018 WIbon Date Amount 101 1000 102 10/5/2018 Mahomet 10/5/2018 Jackson 10/15/2018 Dreaen 10/15/2018 Martinez 10/16/2018 Martinaz 10/29/20 Mahomet 11//2018 Martinez 1003 S295.95 103 1002 1000 104 S.90 105 1005 $345.95 106 1007 107 1002 $2.20 100 1000 S779.90 SC.00 49af9 FiteSerch
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

SEE SOLUTIONCheck out a sample Q&A here
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS