Assignment:
Consider the following database schema:
Product(maker, model, type)
PC(model, speed, ram, hd, price)
Laptop(model, speed, ram, hd, screen, price)
Printer(model, color, type, price)
Write the following queries based on above schema. Use a sub-query in each answer.
a) Find the model number of the item (PC, laptop, or printer) with the highest price.
b) Find the maker of the color printer with the lowest price.
c) Find the maker(s) of the PC(s) with the fastest processor among all those PCs that have the smallest amount of RAM.
Your answer must be typed, double-spaced, Times New Roman font (size 12), one-inch margins on all sides, APA format.