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...

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’
Image of page 1
Image of page 2

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture