Please answer CLEARLY and LEGIBLE

Relational Algebra

Exercise 1: Consider the following relational database which consists of the 4 following relations: Product(maker, makerName, model, type) Example: Product M001' 'PrintAll', 'Pr001', 'printer'), Product( M001', "PrintAll', 'Pr002, 'printer') PC( model, speed, ram, hd, price). Example PC (pcoo1, 4.6', 9MB', 2GB'; 800') Laptop(model, speed, ram, hd, screen, price). Example Laptop(1001', "2.5', 2MB', 4GB', '15in', '280') Printer(model, color, type, price). Example Printer('Pr0o1", 'Col'; Laser' 360) We assume for convenience that model numbers are unique over all manufacturers an product types. -Product relation gives the manufacturer (maker), model and type (PC, Laptop, printer). -PC relation gives for each model number the speed of the processor(in gigahertz), the amount of RAM(in megabytes) and the size of the hard disk (in gigabytes), and the price. -Laptop relation is similar to PC, except that the screen size is also included. -Printer relation records for each printer model whether the printer produces color output or not, the process type (laser or ink-jet), and the price. 1) Define a suitable schema for each relation, and show relationships between relations. 2) Write relational algebra for each of following queries and draw the guery trees: a. PC models have a speed of at least 3.00 b. The model numbers of all printers c. The model numbers of color printers d. Manufacturers who make laptops with at least 100 GB e. The number of printers manufactured by manufacturer "PrintAl