Consider the General Hardware Corp. relational database. Using the informal relational command language described in this chapter,

Question:

Consider the General Hardware Corp. relational database. Using the informal relational command language described in this chapter, write commands to:

a. List the product name and unit price of all of the products.

b. List the employee names and titles of all the employees of customer 2198.

c. Retrieve the record for office number 1284.

d. Retrieve the records for customers headquartered in Los Angeles.

e. Find the size of office number 1209.

f. Find the name of the salesperson assigned to office number 1209.

g. List the product name and quantity sold of each product sold by salesperson 361.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: