# Question $5.$ For each pName $($product name$)$ list the total amount $($money$)$ sold. Note do not

need to count those haven't been sold $($i$.$e$.,$ don't have to do outer join, just do theta join$).$

Hint: Join Product and Sale $($theta$-$join$),$ then group by pName and compute SUM of sQuantity $$

sPrice.

a$.$ Relational Algebra expression $(10$ pt$.)$

b$.$ Resulting Relation $(10$ pt$.)$

Questions $3,4,$ and $5$ use the following relational schemas and instances of relations.

Given a relational database schema and the current instances for the relations in this database:

Product $($pNo: int, pName: string, pCategory: string, pPrice: double, pquantity: int $i_{{?}_{?}}$

Sale $($sNo: int, pNo: int, squantity: int, sPrice: doublelei

Product

Sale