Relational databases suggested answers to discussion questions


e. Which salesperson made the largest sale?



Download 0.89 Mb.
Page10/12
Date16.12.2020
Size0.89 Mb.
#54913
1   ...   4   5   6   7   8   9   10   11   12
rais12 SM CH04 (1)
e. Which salesperson made the largest sale?

Make Table Query



Query Result



Query


Query Result





f. How many units of each product were sold?

Query


Query Result





. Which product was sold most frequently?

Query


Query Result





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 queries—one to calculate a total and the second to answer the question asked.

Answers depend upon the specific DBMS and query language used. Here are suggested answers in QBE (Query By Example) prepared in Microsoft Access.


  1. Which customers (show their names) made purchases from Martinez?

Query




Query Result





  1. Download 0.89 Mb.

    Share with your friends:
1   ...   4   5   6   7   8   9   10   11   12



The database is protected by copyright ©ininet.org 2024
send message
    Main page
internal auditor