2.4.14 Exercises for Section 2.4Exercise 2.4.1: This exercise builds upon the products schema of Exercise2.3.1. Recall that the database schema consists of four relations, whose schemasare:Product (maker, model, type)PC (model, speed, ram, hd, price)Laptop (model, speed, ram, hd, screen, price)Printer (model, color, type, price)Some sample data for the relation Product is shown in Fig. 2.20. Sampledata for the other three relations is shown in Fig. 2.21. Manufacturers andmodel numbers have been "sanitized," but the data is typical of products onsale at the beginning of 2007.Write expressions of relational algebra to answer the following queries. Youmay use the linear notation of Section 2.4.13 if you wish. For the data of Figs.2.20 and 2.21, show the result of your query. However, your answer should workfor arbitrary data, not just the data of these figures.a) What PC models have a speed of at least 3.00?b) Which manufacturers make laptops with a hard disk of at least 100GB?c) Find the model number and price of all products (of any type) made bymanufacturer B.d) Find the model numbers of all color laser printers.e) Find those manufacturers that sell Laptops, but not PC's.! f) Find those hard-disk sizes that occur in two or more PC's.2.4. AN ALGEBRAIC QUERY LANGUAGEmaker model type1001 рс1002 pc.1003 pcAAAAAABBBBсDDDDDEEEEEEEEEFFGHH2004 laptop2005 laptoplaptop20061004рс1005 рс1006 pc2007 laptop1007 рсpc.pcрс1008100910103004 printer3005printer1011pc1012 pcpc10132001 laptop2002laptop2003laptop3001printer3002 printer3003 printer2008 laptop2009laptop2010 laptop3006 printer3007 printerFigure 2.20: Sample data for Product53 54CHAPTER 2. THE RELATIONAL MODEL OF DATAmodel speed ram | hdhdprice1001 2.66 1024 250 21141002 2.10512 250995512 804781003 1.421004 2.80 1024 2506491005 3.20 512 2506301006 3.20 1024 32010495101007 2.20 1024 2001008 2.202048 2501009 2.00 1024 2507706501010 2.80 2048 3007709591011 1.86 2048 1601012 2.80 1024 160 6491013 3.06 512 80 529(a) Sample data for relation PCmodel speed ram hd screenprice2001 2.00 2048 240 20.1 36732002 1.73 1024 8017.094954911502003 1.80 512 60 15.42004 2.00 512 60 13.32005 2.161024 120 17.02006 2.00 2048 80 15.425001700200714291.831024 120 13.31.60 1024 100 15.420089006802009 1.60 512 80 14.12010 2.00 2048 160 15.4 2300(b) Sample data for relation Laptopmodel color type3001 true ink-jet3002 falselaserlaserprice992398991201201002003003 true3004 true3005 false laser3006 trueink-jet3007 true laser(c) Sample data for relation PrinterFigure 2.21: Sample data for relations of Exercise 2.4.1ink-jet2.4. AN ALGEBRAIC QUERY LANGUAGE! g) Find those pairs of PC modeis that have both the same speed and RAM.A pair should be listed only once; e.g., list (i, j) but not (j, i).55!! h) Find those manufacturers of at least two different computers (PC's orlaptops) with speeds of at least 2.80.!! i) Find the manufacturer(s) of the computer (PC or laptop) with the highestavailable speed.!! j)Find the manufacturers of PC's with at least three different speeds.!! k) Find the manufacturers who sell exactly three different models of PC.

Question

2.4.14 Exercises for Section 2.4Exercise 2.4.1: This exercise builds upon the products schema of Exercise2.3.1. Recall that the database schema consists of four relations, whose schemasare:Product (maker, model, type)PC (model, speed, ram, hd, price)Laptop (model, speed, ram, hd, screen, price)Printer (model, color, type, price)Some sample data for the relation Product is shown in Fig. 2.20. Sampledata for the other three relations is shown in Fig. 2.21. Manufacturers andmodel numbers have been &#34;sanitized,&#34; but the data is typical of products onsale at the beginning of 2007.Write expressions of relational algebra to answer the following queries. Youmay use the linear notation of Section 2.4.13 if you wish. For the data of Figs.2.20 and 2.21, show the result of your query. However, your answer should workfor arbitrary data, not just the data of these figures.a) What PC models have a speed of at least 3.00?b) Which manufacturers make laptops with a hard disk of at least 100GB?c) Find the model number and price of all products (of any type) made bymanufacturer B.d) Find the model numbers of all color laser printers.e) Find those manufacturers that sell Laptops, but not PC's.! f) Find those hard-disk sizes that occur in two or more PC's.2.4. AN ALGEBRAIC QUERY LANGUAGEmaker model type1001 рс1002 pc.1003 pcAAAAAABBBBсDDDDDEEEEEEEEEFFGHH2004 laptop2005 laptoplaptop20061004рс1005 рс1006 pc2007 laptop1007 рсpc.pcрс1008100910103004 printer3005printer1011pc1012 pcpc10132001 laptop2002laptop2003laptop3001printer3002 printer3003 printer2008 laptop2009laptop2010 laptop3006 printer3007 printerFigure 2.20: Sample data for Product53 54CHAPTER 2. THE RELATIONAL MODEL OF DATAmodel speed ram | hdhdprice1001 2.66 1024 250 21141002 2.10512 250995512 804781003 1.421004 2.80 1024 2506491005 3.20 512 2506301006 3.20 1024 32010495101007 2.20 1024 2001008 2.202048 2501009 2.00 1024 2507706501010 2.80 2048 3007709591011 1.86 2048 1601012 2.80 1024 160 6491013 3.06 512 80 529(a) Sample data for relation PCmodel speed ram hd screenprice2001 2.00 2048 240 20.1 36732002 1.73 1024 8017.094954911502003 1.80 512 60 15.42004 2.00 512 60 13.32005 2.161024 120 17.02006 2.00 2048 80 15.425001700200714291.831024 120 13.31.60 1024 100 15.420089006802009 1.60 512 80 14.12010 2.00 2048 160 15.4 2300(b) Sample data for relation Laptopmodel color type3001 true ink-jet3002 falselaserlaserprice992398991201201002003003 true3004 true3005 false laser3006 trueink-jet3007 true laser(c) Sample data for relation PrinterFigure 2.21: Sample data for relations of Exercise 2.4.1ink-jet2.4. AN ALGEBRAIC QUERY LANGUAGE! g) Find those pairs of PC modeis that have both the same speed and RAM.A pair should be listed only once; e.g., list (i, j) but not (j, i).55!! h) Find those manufacturers of at least two different computers (PC's orlaptops) with speeds of at least 2.80.!! i) Find the manufacturer(s) of the computer (PC or laptop) with the highestavailable speed.!! j)Find the manufacturers of PC's with at least three different speeds.!! k) Find the manufacturers who sell exactly three different models of PC.

Accepted Answer

Answered: Image /qna-images/answer/b3f0f94a-d5df-470f-94e7-78280ddc946e.jpg

2.4.14 Exercises for Section 2.4 Exercise 2.4.1: This exercise builds upon the products schema of Exercise 2.3.1. Recall that the database schema consists of four relations, whose schemas are: