This is the schema

Supplier$($supplierid$,$ name, city$)$

Store$($storeid$,$ sname, city$)$

Product$($barcode$,$ pname, price, itsshoes, itsabag, color,

supplierid$)$

Has$\_$stock$($storeid$,$ barcode, quantity$)$

Express in relational algebra the following queries:

A$.$ Find the name of the stores that have at least $2$ different bag designs in black color. Do not use aggregation.

B$.$ Find the price of all products that are shoes in the store named $$Storey$.$

C$.$ Find the names of all suppliers that supply more than $5$ products with different barcodes, whether these are shoes or bags. You can use aggregation.

D$.$ Find the barcodes of the products that are sold by the store with store$-$id equal to $1$ and by the store with store$-$id equal to $2.$ Do not use the intersection operator.