Question: Consider the following database schema: Product(maker, model, type) PC(model, speed, ram, hd, rd, price) Laptop(model, speed, ram, hd, screen, price) Printer(model, color, type, price) (

Consider the following database schema:

Product(maker, model, type)

PC(model, speed, ram, hd, rd, price)

Laptop(model, speed, ram, hd, screen, price)

Printer(model, color, type, price)

  1. (Grouping and Aggregation) Write the following queries in SQL:
  1. Find the average speed of laptops costing over $2000.
  2. Find the average price of PCs and laptops made by manufacturer D.
  3. Find, for each manufacturer, the average screen size of its laptops.
  4. Find the manufacturers that make at least three different models of PC.
  5. Find, for each manufacturer who sells PCs, the maximum price of a PC.
  6. Find, for each speed of PC above 800, the average price.
  7. Find the average hard-disk size of a PC for all those manufacturers that make 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!

Q:

icite the following queries (in SQL only), based on the database schema Product (maker, model, type) PC (model, speed, ram, hd, price) Laptop(model, speed, ram, hd, screen, price) Printer(model,...

Q:

Indicate how you would express the integrity constraints listed below in SQL assuming the following schema modeling the inventory of a computer store: Product (maker, model, type) PC (model, speed,...

Q:

Indicate how you would express the integrity constraints listed below in SQL assuming the following schema modeling the inventory of a computer store: Product (maker, model, type) PC (model, speed,...

Q:

Consider the following relational schema Product (Brand, Model, Type) PC (Model, CPU, Speed, RAM, HD, Price); Laptop(Model, CPU, RAM, HD, Screen Size, Screen Type, Price) Printer (Model, Colour,...

Q:

Consider the following relational schema Product (Brand, Brand Description) PC (Model CPU, Speed RAM HD, Price, Brand) Laptop(Model, CPU RAM, HD, Screen Size Screen Type Price, Brand) Assume that the...

Q:

Draw the E / R diagram corresponding to the following relational schemas: Schema 1 Product ( maker , model, type ) PC ( model , speed, ram, hd , price ) Laptop ( model , speed, ram, hd , screen,...

Q:

MySql Database,, Please Answer all Questions. Make sure to put subquery also 6.3.9 Exercises for Section 6.3 Exercise 6.3.1: Write the following queries, based on the database schema Product (maker,...

Q:

Q3 [1 pt]: Write the following as triggers for the following schema. In each case disallow or undo the modification if it does not satisfy the stated constraint. Product(maker, model, type) PC model,...

Q:

This query works but is doing something unnecessary. Suggest a way to improve the way that this query is written, so it is no longer doing the unnecessary thing. Explain why your suggestion helps. --...

Q:

Questions: Consider four relations with the following schemas: Product [ manufacturer , model, type ] PC [ model , speed, RAM, HDD , price ] Laptop [ model , speed, RAM, HDD , screen, price ] Printer...

Q:

A chest x-ray was acquired using 110 kVp and 3.5 mAs with an SID of 1.5 meters resulting in an intensity of 0.48 mGya. What would the new intensity be if the SID is doubled?

Q:

Write each of the following arguments in symbolic form. Then establish the validity of the argument or give a counterexample to show that it is invalid. (a) If Rochelle gets the supervisor's position...

Q:

If a billable option is turned on in the account and setting options what additional setting becomes available?

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

Have issues been prioritized?

Q:

Has the priority order been provided by someone else?

Q:

Compare the current team to the ideal team.