Bicycle (SerialNo, Model, Manufacturer, Price)

Option (SerialNo, Option_name, Price)

Sale (SalespersonId, SerialNo, Date, Sales_price)

Salesperson (SalespersonId, Name, Phone, DOB)

Provide Relational Algebra for the following questions given below:

• List all road bicycles with a price below 7000$.
• List all salesperson name and phone currently selling A-bike bicycles.
• List all salesperson ids who sell A-bike bicycles and Fuji Bikes bicycles.”
• List the option_price and option_name of all mountain bicycles.
• List the bicycle details (no, model, manufacturer and price) of all bicycles sold from date 10-02-2021.
• What are the models of bicycles that have not been bought? Each model should appear only once.
• List all salesperson ids who sell mountain bicycles or are born in April.

List all salesperson ids who sell every bicycle.

• List all salesperson ids who sell A-bike or Fuji Bikes bicycle.