Write queries using operations of relational algebra for the

Write queries using operations of relational algebra for the questions listed below. Make sure to combine operators together to create more advanced queries to retrieve data. Given tables: CUSTOMER (CUST_ID (PK), CUST_LAST, CUST_FIRST, CUST_PHONE, CUST_EMAIL, CUST_ADDRESS, CUST_CITY, CUST_ZIP, CUST_STATE) ORDERS (ORDER_NUMBER (PK), CUST_ID (FK), PROD_ID (FK), ORDER_DATE, ORDER_TOTAL) PRODUCT (PROD_ID (PK), PROD_DESCRIPTION, PROD_CATEGORY, PROD_PRICE)

1. Retrieve City and Email for the customer whose name is John Smith.

2. Retrieve Name and Address of all customers who live in Florida.

3. Retrieve Product Description and Price for the products in the Computer category that costmore than $100. PLEASE WRITE IN RELATIONAL ALGEBRA FORM NOT SQL FORMAT

Solution

we can write sql quiries in the relational algebra operations.by using the same operations that we used in the sql.

some of the relational algebra operations are given bellow.

projection( ₎:which can be used to project or display the rows that are collected by the selection operation.it is denoted by the letter pi( _).

_selection():this selection operation is take some condition and searches for the tupples satisfieing the condition.it uses the symbol sigma().

join:join operation which is used to combine the two or more tables for to retrieve the rows.for to join N tables we need N-1 join conditions.

relational algebra quiries: