Write queries using operations of relational algebra for the questions listed be

Question

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

Explanation / Answer

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:

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.