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

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

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!