EECS 341 Intro to Databases Assignment #4 solution


Original Work


5/5 - (7 votes)

For this assignment, use the same relations provided with assignment 3.
Submit a pdf to Canvas by the due date and time, generated using a word processor of
your choice or by photographing a clean, legible hand written paper.
For the following questions stated in prose, express the answers in all three query
languages we have learned in class.
(a) Relational algebra
(b) Tuple relational calculus
(c) SQL
1. Find the name of users associated with only the area “Cleveland City”
2. Find the name of users associated with every area except “Cleveland City”