Problem 2 Specify the following queries in relational algebra on the database schema below: Consider the relations for a database that keeps track of automobile sales in a car dealership (OPTION refers to some optional equipment installed on an automobile): CAR(Serialno, Model, Manufacturer, Prie) OPTION(Serial no, Option_name, Price) SALE(Salesperson id, Serialno, Date, Sale-price) SALESPERSON(Salesperson.id, Name, Phone) a. For the salesperson named 'Jane Doe', list the following information for all the cars she sold: Serial no, Manufacturer, Sale price. b. List the Serial no and Model of cars that have no options. c. Consider the NATURAL JOIN operation between SALESPERSON and SALE. What is the meaning of a left outer join for these tables (do not change the order of relations)? Explain with an example. d. Make up 3 additional queries in English and provide the respective relational algebra commands. Be creative