Relational Algebra

Order orderNumb elSID Model er Customer ID eNam Co1l Aline CO2 Sean C03 John Quantit 123 CO Hd12 FB409GMBK 124 CO Rf07 125 co Rf07 FB409GMBK 126 CO Rf07 ESS-FI E55-FIr Store Product SID Model Hd12 FB409GMBK 150 Rf07 E55-F Rf07 FB409GMBK 150 Tr08 Graco Model Ty TV E55-F1 fitBit FB409GMBK Electronics strollerl Graco LiteRider Bab Categor Electronic 460 110 LiteRider Question 1 (4 Points) Write a relational algebra expression that returns the name of the customer that bought product type 'apple Question 2 (5 Points) Write a relational algebra expression that returns total amount of money spent by Sean Question 3 (5 Points) Write a relational algebra expression that return the name of customer that bought all the product available at store 'tr08' Question 4 (5 Points) Write a relational algebra expression that returns the customer name that never bought any product of category electronic Question 5 (6 Points) Write a relational algebra expression that returns the store ID that sells electronics and these electronic item's price is less than 100 Question 6 (7 Points) Write a relational algebra expression that returns all the customer name that spent the most on good Question 7 (6 Points) Write a relational algebra expression that returns the customer ID that spent more money on electronic than baby item Question 8 (6 Points) Write a relational algebra expression that returns the customer name that had bought all the item sold by 'Rf07 Question 9 (7 Points) Write a relational algebra expression that returns customer name that never spent more than 100 on their order Question 10 (7 Points) Write a relational algebra expression that returns the product model that 'John 'never bought Question 11 (8 Points) Write a relational algebra expression that returns the average price of items bouaht bv each customer