Question: Product(maker, model, type) PC(model, speed, ram, hd, rd, price) Laptop(model, speed, ram, hd, screen, price) Printer(model, color, type, price) Give SQL statement for each of

Product(maker, model, type)

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

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

Printer(model, color, type, price)

Give SQL statement for each of the following:

  1. (Subqueries, Join operations) Write the following queries in SQL:
  1. Find the makers of PCs with a speed of at least 1200.
  2. Find the printers with the highest price.
  3. Find the laptops whose speed is lower than that of any PC.
  4. Find the model number of the item (PC, laptop, or printer) with the highest price.
  5. Find the maker of the color printer with the lowest price.
  6. Find the maker(s) of the PC(s) with the fastest processor among all those PCs that have the smallest amount of RAM.

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:

Answer the following queries using SQL according to the database schema given below. Product (maker, model, type ) PC (model, speed, ram, hd, rd, price) Laptop (model, speed, ram, hd, screen, price)...

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:

Introduction to Database Systems 3. Suppose a database schema consists of four relations whose schemas are: Product (maker, model, type) PC (model, speed, ram, hd, price) Laptop (model, speed, ram,...

Q:

Only need parts d & e for Exercise 7.52 Exercise 7.5.2: Write the following as triggers. In each case, disallow or undo the modification if it does not satisfy the stated constraint. The database...

Q:

Only need parts d & e for Exercise 7.52!! Exercise 7.5.2: Write the following as triggers. In each case, disallow or undo the modification if it does not satisfy the stated constraint. The database...

Q:

Only need parts b,d, and e for Exercise 6.5.1 Exercise 6.5.1: Write the following database modifications, based on the database schema Product (maker, model, type) PC (model, speed, ram, hd, price)...

Q:

You DO NOT need to answer 1-5! I have done those. Please just answer 6-10! Thank you! Tools Window Help scOSC330-A2-2.pdf (page 1 of 3) Search Consider a database schema consisting of the foliowing...

Q:

1. Consider a database schema consisting of two relations, whose schemas are: Product (maker, model, type) PC (model, speed, ram, hd, price) The Product relation gives the manufacturer, model number...

Q:

Exercise 7.5.2: Write the following as triggers. In each case, disallow or undo the modification if it does not satisfy the stated constraint. The database schema is from the "PC" example of Exercise...

Q:

Determine the components of F that act along rod AC and perpendicular to it. Point B is located 3m along the rod from endC. 4 m F= 600 N 6 m

Q:

Explain serializability of transaction. OR Explain both the forms of serializability with example. Also explain relation between two forms. OR Explain conflict serializability and view...

Q:

Which of the following correlation coefficients can provide the greatest diversification benefit? - 0 . 5 0 . 5 0 1 . 0 - 1 . 0

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

6. Discuss the advantages and disadvantages of organizing the training function according to the faculty, customer, matrix, corporate university, and business-embedded models.

Q:

9. Mohawk Industries Inc.

Q:

8. Satyam Computer Services Limited