Question: Product(maker, model, type) PC(model, speed, ram, hd, price) Laptop(model, speed, ram, hd, screen, price) Printer (model, color, type, price) These questions concern the computing products


Product(maker, model, type) PC(model, speed, ram, hd, price) Laptop(model, speed, ram, hd, screen, price) Printer (model, color, type, price) These questions concern the computing products relations. For each of these, your query MUST NOT do any type of join, but MUST use ANY, IN, or ALL. a) Find the makers of PCs with a hard drive size of at least 100. b) Find the prices of PCs produced by maker A. c) Find the model number and the speed of the laptop(s) with the highest speed. d) Find the maker(s) of the slowest (least speed) PCs. e) I want to buy a PC and a printer. I want to spend as little money as possible. Write one query that produces a table with two model numbers: one of the cheapest PC and one of the cheapest printer. f) Find the model numbers of all of the PCs that are cheaper than the cheapest laptop. g) Find the model numbers of all of the laptops that are more expensive than the most expensive PC. h) Find the model numbers of all of the laptops that are cheaper than at least one PC. i) I only buy maker B's products, but l'm on a budget. Find model number and cost of the cheapest PC(s) that maker B produces. (This may or may not be the cheapest PC overall.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
