Database Management > QUESTION PAPER (QP) > Quiz 2 CSE 3241 | Download for quality grades | (All)
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: 1 year ago
Preview 1 out of 2 pages
Instant download
Buy this document to get the full access instantly
Instant Download Access after purchase
Add to cartInstant download
Connected school, study & course
About the document
Uploaded On
Apr 04, 2023
Number of pages
2
Written in
This document has been written for:
Uploaded
Apr 04, 2023
Downloads
0
Views
41
In Browsegrades, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.
We're available through e-mail, Twitter, Facebook, and live chat.
FAQ
Questions? Leave a message!
Copyright © Browsegrades · High quality services·