• SQL
• Use MS Access to provide answers to the following problems. Try to come up with best answers. Show only what is asked for.

• Show the relational algebra (both in English and in formal notation) for the following problems.
  0. List the number and name of all consultants. Your answer should be
     • PROJECT Consultant OVER (ConsltNum, LastName, FirstName) GIVING Answer
     • _{ConsltNum, LastName, FirstName}(Consultant)

1. List the order number and client name for each order.
2. List the order number and client name for each order placed by any client represented by consultant 19.