I need answers for b-g written in expressions of relational algebra(NOT SQL). I will include the tables but the answers should work for arbitrary data, not ust the data of these figures. Ive asked this question like 3 times and no one has really done them correctly so dont attempt unless you are familiar with relational algebra. This has already cost me multiple questions against my 20 question limit so please do all b-g. A hint the professsor gave for f and g is as follows: If all of the relevant information is in one relation, but you need to use a binary operator, it may be necessary to make copies of the original relation ( for example, using RENAME).

combine the last twa Stp t,y, I , i ,s ,p) :=g.tudioName" Fox.(Movies) Answer (title, year) := n,s(R n S) R(t,y,1,1,s,p) := 1ength > 1 00 (Movies line and write the enti We could even substitute for R and S in the last expression in one line. 2.4.14 Exercises for Section 2.4 Exercise 2.4.1: This exercise builds upon the products schema of Exercise 2.3.1. Recall that the database schema consists of four relations, whose schemas are: Product (maker, model, type) PC(model, speed, ram, hd, price) Laptop (model, speed, ram, hd, screen, price Printer (model, color, type, price) Some sample data for the relation Product is shown in Fig. 2.20. Sample data for the other three relations is shown in Fig. 2.21. Manufacturers and model numbers have been "sanitized," but the data is typical of products on sale at the beginning of 2007. Write expressions of relational algebra to answer the following queries. You may use the linear notation of Section 2.4.13 if you wish. For the data of Figs. 2.20 and 2.21, show the result of your query. However, your answer should work for arbitrary data, not just the data of these figures. a) What PC models have a speed of at least 3.00? b) Which manufacturers make laptops with c) Find the model number and price of all products (of any type) made by a hard disk of at least 100GB? manufacturer B. d) Find the model numbers of all color laser printers e) Find those manufacturers that sell Laptops, but not !f) Find those hard-disk sizes that occur in two or more PC's