Consider the General Hardware Corp. relational database and the data stored in it, as shown in Figure 5.14. Find the answer to each of the following queries (written in the informal relational command language described in this chapter). a. SelectrowsfromtheCUSTOMEREMPLOYEE relation in which Customer Number = 2198. b. SelectrowsfromtheCUSTOMEREMPLOYEE relation in which Customer Number = 2198. Project Employee Number and Employee Name over that result. c. Select rows from the PRODUCT relation in which Product Number = 21765. d. Select rows from the PRODUCT relation in which Product Number = 21765. Project Unit Price over that result. e. Join the SALESPERSON and CUSTOMER relations using the Salesperson Number attribute of each as the join fields. Select rows from that result in which Salesperson Name = Baker. Project Customer Name over that result. f. Join the PRODUCT relation and the SALES relation using the Product Number attribute of each as the join fields. Select rows in which Product Name = Pliers. Project Salesperson Number and Quantity over that result
Consider the General Hardware Corp. relational
a. SelectrowsfromtheCUSTOMEREMPLOYEE relation in which Customer Number = 2198. b. SelectrowsfromtheCUSTOMEREMPLOYEE
relation in which Customer Number = 2198. Project Employee Number and Employee Name over that result.
c. Select rows from the PRODUCT relation in which Product Number = 21765.
d. Select rows from the PRODUCT relation in which Product Number = 21765. Project Unit Price over that result.
e. Join the SALESPERSON and CUSTOMER relations using the Salesperson Number attribute of each as the join fields. Select rows from that result in which Salesperson Name = Baker. Project Customer Name over that result.
f. Join the PRODUCT relation and the SALES relation using the Product Number attribute of each as the join fields. Select rows in which Product Name = Pliers. Project Salesperson Number and Quantity over that result.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
