Database Management > QUESTION PAPER (QP) > Quiz 2 CSE 3241 | Download for quality grades | (All)

Quiz 2 CSE 3241 | Download for quality grades |

Document Content and Description Below

1. (10 Points) Identify minimum number of operands needed for each of the following relational algebra operators and place an X in appropriate slot. Use of same table twice is considered as two ta ... bles. 1 table Any 2 tables 2 tables with same number of attributes with compatible domains 3 tables Union X Intersect X Difference X Product X Project X Join X Division X 2. Find the names and addresses of employees who work on at least one project located in Houston but whose department has no location in Houston. Use the database schema on page 2. 2a. Write the query in Relational Algebra E_P_HOU(SSN) ESSN (WORKS_ON ⋈(PNO),(PNUMBER) ( PLOCATION=’Houston’ (PROJECT))) [Show More]

Last updated: 2 years ago

Preview 1 out of 2 pages

Buy Now

Instant download

We Accept: