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 14:30

Complete the sentence based on your knowledge of the professional difficulties faced by music artists. digital technology allows audiences to see free live telecasts of music or dance performances through

Answers: 1

Answer

Computers and Technology, 22.06.2019 17:00

Your computer running windows 10 is doing some very strange things with the operating system. you are fairly certain it is not a hardware issue. you need to try to get further insight into what is going on within the operating system. which tool would be best suited for this?

Answers: 2

Answer

Computers and Technology, 22.06.2019 22:30

One of your customers wants you to build a personal server that he can use in his home. one of his concerns is making sure he has at least one backup of their data stored on the server in the event that a disk fails. you have decided to back up his data using raid. since this server is for personal use only, the customer wants to keep costs down. therefore, he would like to keep the number of drives to a minimum. which of the following raid systems would best meet the customer's specifications? a. raid 0 b. raid 1 c. raid 5 d. raid 10

Answers: 3

Answer

Computers and Technology, 24.06.2019 03:00

What is one potential problem associated with an organization purchasing new technology early in its lifecycle

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