week 3 discussion answers.docx - BITS Corporation Exercises Relational Algebra In the following exercises you will use the data in the BITS Corporation

# week 3 discussion answers.docx - BITS Corporation Exercises...

• Homework Help
• 2
• 84% (38) 32 out of 38 people found this document helpful

This preview shows page 1 - 2 out of 2 pages.

BITS Corporation Exercises: Relational Algebra In the following exercises, you will use the data in the BITS Corporation database shown in Figure 2-1. In each step, indicate how to use relational algebra to obtain the desired results.1List the number and name of all consultants. PROJECT Consultant OVER (ConsltNum, LastName, FirstName) GIVING Answer 2 List all information from the Tasks table for item WC19. SELECT Tasks WHERE TaskID=’WC19’ GIVING Answer 3List the order number, order date, client number, and client name for each order. JOIN WorkOrders Client WHERE WorkOrder.ClientNum=Client.ClientNum GIVING Temp PROJECT Temp OVER (OrderNum, OrderDate, ClientNum, ClientName) GIVING Answer 4 List the order number, order date, client number, and client name for each order placed by any client represented by the consultant whose last name is Turner. JOIN WorkOrders, Client WHERE WorkOrder.ClientNum=Client.ClientNum GIVING Temp1 PROJECT Temp1 OVER (ClientNum, ClientName) GIVING Temp2 SELECT Client WHERE ConsltNum=’19’