Find out the model number of the item

Assignment Help Computer Engineering

Reference no: EM1326295

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.

Reference no: EM1326295

Questions Cloud

Madam cj walker-s contribution to community : Explain how Madam C.J. Walker made a contribution to their community or society and how this contribution embodies servant leadership.

Explaining the option contract scenario : When the developer learns what Alice has done, he sues her for breach of contract. What result? Explain fully. How would your answer differ, if at all, had the developer paid Alice $5,000 at the time she agreed to hold the offer open? Why?

What is difference between client and a server : What are the differences between client and a server. What is function of each layer in a three-layer application?

Explain amazon- evolution paper : Explain Amazon- Evolution Paper and Can you help me get started with this assignment

Find out the model number of the item : Find out the maker(s) of the PC(s) with the fastest processor among all those PCs that have the smallest amount of RAM.

Laws or rules or regulations : Should the federal government have special rules, or should federal property be subject to the same laws/rules/regulations as private property?

Given the industry''s concern that workers shirk : Given the industry's concern that workers shirk, they start employee at $10 and increase the pay by $0.40 each year they are on the job.

Mainframe computing is way to manage enterprise data : Mainframe computing used to be the only way to manage enterprise data. Then personal computers changed the data management scene. How do these two computing styles differ, and how did shift to PC-based computing evolve.

Recommendations for tone-setting style : Provide some insights or recommendations for tone-setting style based upon the observations and the organizational literature.

User Account

All Pages