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, for each manufacturer who sells PCs, the maximum price of a PC.
  2. Find, for each speed of PC above 800, the average price.
  3. 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:

According to Zagats latest edition, the average cost for a dinner at better restaurants in the US is $ 35.37. In a survey of 36 randomly selected local restaurants, you find the average cost for a...

Q:

Draw the structures of the two carbocation intermediates that might form during the reaction of 2-methylpropene with HBr (Problem 5.40). Well see that the stability of carbocation depends on the...

Q:

What is the purpose of stress testing in relation to bank capital? Determining interest rates Assessing resilience under adverse conditions Calculating loan - to - deposit ratios Estimating operating...

Q:

Help draw the structures 1. 1,3,5-benzenetriol 2. cis-1-benzyl-3-phenylcyclohexane 3. p-iodoaniline 4. 3-phenyl-1-pentyne 5. (Z)-5-phenylhept-3-en-2-ol

Q:

Give an example of a Composite Primary Key use in a HCM Payroll Table.

Q:

How are Third Normal Form rules disregarded in Dimensional Database Design?

Q:

Provide examples of Dimensional Tables.