consider the general hardware corp. relational database and the

Project Description:

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.
Skills Required:
Project Stats:

Price Type: Negotiable

Expired
Total Proposals: 8
1 Current viewersl
9 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 3.8
    30 Jobs 19 Reviews
    $0 in 0 Day
  • 4.5
    355 Jobs 236 Reviews
    $0 in 0 Day
  • 4.3
    7 Jobs 3 Reviews
    $20 in 0 Day
  • 2.5
    8 Jobs 6 Reviews
    $0 in 0 Day
  • 4.8
    60 Jobs 32 Reviews
    $0 in 0 Day
  • 4.9
    95 Jobs 45 Reviews
    $0 in 0 Day
  • 0.0
    1 Jobs 0 Reviews
    $0 in 0 Day