Homework #2

(#1 was the paragraph you turned in on Tuesday)

due  Thursday, January 19th

 

This assignment is to be done in pairs using the pairs assigned in class.

Hand printed names of pairs: ______________________     __________________________

 

These questions use the tables given on the last slide from today’s lecture.  It is slide #26 and shows FIGURE 8-21

Please use Word to create the tables representing your answers and print it out before turning it in.

 

  1. What relation results from the following relational algebra statement?  

SELECT STUDENT WHERE  SID >= 200

 

 

 

  1. What relation results from the following relational algebra statement?

PROJECT ENROLLMENT OVER (PositionNumber)

 

 

 

  1. What relation results from the following relational algebra statement?

STUDENT EQUIJOIN ENROLLMENT

 

 

  1. What relation results from the following relational algebra statement?

PROJECT STUDENT OVER (SID, Major)

 

 

  1. What relation results from the following relational algebra statement?

                     SELECT CLASS WHERE Room = EB210

 

 

  1. What relation results from the following relational algebra statement?

STUDENT  X  CLASS

 

 

  1. What relation results from the following relational algebra statement?

                             STUDENT X ENROLLMENT GIVING TEMP1

 

 

  1. What relation results from the following relational algebra statement performed on your answer to Question 7?

SELECT TEMP1 WHERE SID < 250  GIVING TEMP2

 

 

  1. What relation results from the following relational algebra statement performed on your answer to Question 8?

PROJECT TEMP2 OVER Major, PositionNumber

 

 

  1. What relation results from the following relational algebra statement?

SELECT STUDENT WHERE SID < 300 AND Major = ‘History’