Computers and Technology, 31.08.2021 19:00 deduran

Refer to the tables starting on the next page. (These tables were taken from the book "A First course in Database Systems" third edition, written by Jeffery Ullman and Jennifer Widom and published by Pearson Prentice Hall, copyright 2008.) 1. Write the relational algebra statement which will select all rows (tuples) from the Laptop table which have a screen of 17 inches or more.
2. Display the table which is the answer to the relational algebra query of question 1.
3. Write the relational algebra statement which will display the model, screen and price columns from the Laptop table.
4. Display the table which is the answer to the relational algebra query of question 3.
5. Write the sequence of relational algebra statements which will give the model, type, and price attributes of color printers. 6. Display the table which is the answer to the relational algebra query of question 5.
The relation Product maker model type pc 1001 1002 1003 pc A A A A A A pc laptop laptop laptop pc B B pc B 2004 2005 2006 1004 1005 1006 2007 1007 1008 1009 1010 3004 3005 1011 pc laptop pc pc pc 1012 1013 2001 2002 2003 3001 GG GG II pc printer printer pc pc pc laptop laptop laptop printer printer printer laptop laptop laptop printer printer E 3002 3003 2008 2009 2010 G 3006 3007 The relation PC model speed ram hd price 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 2.66 2.10 1.42 2.80 3.20 3.20 2.20 2.20 2.00 2.80 1.86 2.80 3.06 1024 512 512 1024 512 1024 1024 2048 1024 2048 2048 1024 512 250 250 80 250 250 320 200 250 250 300 160 160 80 2114 995 478 649 630 1049 510 770 650 770 959 649 1012 1013 529 The relation Laptop model speed ram hd screen price 3673 949 549 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2.00 1.73 1.80 2.00 2.16 2.00 1.83 1.60 1.60 2.00 2048 1024 512 512 1024 2048 1024 1024 512 2048 240 80 60 60 120 80 120 100 80 160 20.1 17.0 15.4 13.3 17.0 15.4 13.3 15.4 14.1 15.4 1150 2500 1700 1429 900 680 2300 The relation Printer model color type price 3001 3002 3003 3004 3005 3006 3007 true false true true ink-jet laser laser ink-jet laser ink-jet laser 99 239 899 120 120 false 100 true true 200

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 23.06.2019 14:00

Select the correct answer. a company is currently focusing on creating specific management goals for itself. which level of maturity is the company demonstrating under the sse_ccm framework? a. performed informally b. planned and tracked c. quantitatively controlled d. well-defined e. continuously improving

Answers: 2

Answer

Computers and Technology, 23.06.2019 20:00

What software programs are used to to create professional publication? a.) graphics programs b.) word processors c.) page layout programs d.) spreadsheet programs

Answers: 2

Answer

Computers and Technology, 23.06.2019 20:50

3.11.3 quiz: comparing and analyzing function typesquestion 4 of 102 pointswhat can you say about the y-values of the two functions f(x) = 3x2-3 andg(x)=2* - 3?

Answers: 2

Answer

Computers and Technology, 24.06.2019 11:00

In three to five sentences, describe how you can organize written information logically and sequentially

Answers: 1

Answer

You know the right answer?

Refer to the tables starting on the next page. (These tables were taken from the book "A First cours...

Questions