Question: Product (maker, model, type) . PC(model, speed, ram, hd, price) Laptop(model, speed, ram, hd, screen, price) Printer(model, color, type, price) Write the SQL statement and

 Product (maker, model, type) . PC(model, speed, ram, hd, price) Laptop(model,

Product (maker, model, type) . PC(model, speed, ram, hd, price) Laptop(model, speed, ram, hd, screen, price) Printer(model, color, type, price) Write the SQL statement and draw the optimized relational algebra query execution tree for each of the following queries (10 points/SQL 10 points/query tree): 1. What makers produce Laptops with screen larger than 15' that are cheaper than $1,000? 2. What makers produce PCs or Laptops, but do not produce Printers? 3. How many makers produce each type of product? 4. For each maker who produces PCs with more than 4 GB of ram, find the average price of these PCs with more than 4 GB of RAM) 5. For all the makers that produce PCs, Laptops, and Printers, find the minimum price of a package that includes a PC, a Laptop, and a Printer. 6. Out of all the makers that produce PCs, find the cheapest Laptop sold by them. 7. Find the maker that sells the most expensive PC and also sells Printers

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!