Consider the following schema and write the following queries in relational algebra. Product(pid, pname, pcolour, price, supplier, year_manufacture) Select the records where product is 'shoes'. Select...

Consider the following schema and write the following queries in relational algebra.

Product(pid, pname, pcolour, price, supplier, year_manufacture)

1. Select the records where product is 'shoes'.


2. Select the records where product colour is 'red' and 'price' is 450.

3. Select records from Product table where supplier is 'Davidson' and price is 500 or those products manufactured after 2018 .

4.Project the columns named as pid and supplier from the Product table.