Question: 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

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. Select rows from the CUSTOMER EMPLOYEE relation in which Customer Number = 2198.

b. Select rows from the CUSTOMER EMPLOYEE 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.

Step by Step Solution

★★★★★

3.48 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Database Management Systems Questions!

Use Figure 6.17 above to answer the following questions: 5. In the General Hardware Corp. relational database of Figure 6.17: a. How many foreign keys are there in each of the six relations? b. List...

Use the following tables to answer the questions: WRITE OUT THE SQL COMMANDS NEEDED TO LIST OR RETRIEVE THE BELOW INFORMATION (use SELECT, FROM, WHERE, JOIN, ON, etc) - write the full SQL commands 7....

PROJ6000: Principles of Project Management Assessment 3 - Project Charter Report. Length 2,000 words (+/- 10%) Task Summary After reading the project case study, use it to develop a 2,000-word...

PROJ6000: Principles of Project Management Assessment Assessment 2 - this is actually a case study and its called a Individual Report: PMBoK versus PRINCE2 or Agile in contemporary projects . so one...

this is my assessment which are am going to send you and i need some things about my assessment : Adding some more detail and diving into the case study a bit deeper would really make your points...

1. Read the case study below. This will form the basis for your Project Charter, because you will assume that you are the project manager for this project. 2. After reading the case study, begin to...

Prepare a research paper as part of a marketing research committee for your organization about current microeconomic thought and theory. Identify the fundamental lessons the Ten Principles of...

Prove that cos(y-7)+sin(y+) = 0.

Question 2 5 The relationship between an interface and the class that implements it is None Inheritance Composition Aggregation

Factorize the following polynomial functions and sketch their graphs: (a) x 3 2x 2 11x + 12 (b) x 3 + 2x 2 5x 6 (c) x 4 + x 2 2 (d) 2x 4 + 5x 3 x 2 6x (e) 2x 4 9x 3 + 14x 2 9x + 2 (f) x 4 +...

According to your author, what issues should nonprofit boards of directors consider when deciding to participate in a partnership with a for-profit organizations.

If you were a government official, would you prefer to contract with a small community-based nonprofit organization or with a for-profit company that might have greater resources?

If given the option, would you prefer that your nonprofit organization receive a government grant or a contract? Why?

From the following particulars, calculate the following material variances and give their relationships: (a) Material cost variance (b) Material usage varlance (c) Material price variance (d)...

22 Price ($) Quantity 0 50 45 15 40 30 35 45 30 60 25 75 20 90 15 105 10 120 5 135 3 pts Refer to the Table above. If the current price is $45 per calculator and the seller wishes to increase...

Gross sales in the women's shoe department were $1,715,000. Customer returns totaled 6.5%. Calculate net sales. $9,432,500 $111,475 $1,603,525 $1,826,475 Question 11 (3 points) Which of the following...