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, 22.06.2019 20:40

Write a program that begins by reading in a series of positive integers on a single line of input and then computes and prints the product of those integers. integers are accepted and multiplied until the user enters an integer less than 1. this final number is not part of the product. then, the program prints the product. if the first entered number is negative or 0, the program must print “bad input.” and terminate immediately. next, the program determines and prints the prime factorization of the product, listing the factors in increasing order. if a prime number is not a factor of the product, then it

Answers: 2

Answer

Computers and Technology, 23.06.2019 12:30

How is the brightness of oled of the diaplay is controled

Answers: 1

Answer

Computers and Technology, 23.06.2019 18:40

How does is make you feel when you're kind to others? what are some opportunities in your life to be more kind to your friends and loved ones? imagine a world where kindness has be outlawed. how would people act differently? would your day-to-day life change significantly? why or why not?

Answers: 2

Answer

Computers and Technology, 24.06.2019 11:00

Which of the statements below describe the guidelines for the use of text in presentation programs? a. do not use numbered lists. b. fonts should be appropriate for your audience. c. limit the number of fonts you use to three or four. d. only use bulleted lists for sales promotions. e. select font sizes that are appropriate for your delivery method. f. use font colors that work well with your background. select all that apply

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