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 this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Reviews( 0 )
$1.00
Can't find what you want? Try our AI powered Search
Document information
Connected school, study & course
About the document
Uploaded On
Apr 04, 2023
Number of pages
2
Written in
Additional information
This document has been written for:
Uploaded
Apr 04, 2023
Downloads
0
Views
63
