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 22:00

Perform the following tasks: a. create a class named testclass that holds a single private integer field and a public constructor. the only statement in the constructor is one that displays the message “constructing”. write a main()function that instantiates one object of the testclass. save the file as testclass.cpp in the chapter 08 folder. run the program and observe the results. b. write another main()function that instantiates an array of 10 testclass objects. save the file as test class array.c . run this program and observe the results.

Answers: 1

Answer

Computers and Technology, 22.06.2019 23:30

The next button in the review section shows the next available comment. next slide with no comment. previous comment. edited comment.

Answers: 1

Answer

Computers and Technology, 23.06.2019 06:00

What makes myhexadecimalnumber a child of mynumber? which methods does myhexadecimalnumber inherit directly from the mynumber class? what can an instance of the mynumber class do? what can an instance of the myhexadecimalnumber class do? which methods are overridden? why are they overridden? how many examples of overloading are there? why was this done? where is the super keyword used? what is it doing? why isn’t the incoming value set immediately in the second myhexadecimalnumber constructor? how many examples can you find of an inherited method being called?

Answers: 1

Answer

Computers and Technology, 23.06.2019 12:10

2. fabulously fit offers memberships for$35 per month plus a $50 enrollmentfee. the fitness studio offersmemberships for $40 per month plus a$35 enrollment fee. in how many monthswill the fitness clubs cost the same? what will the cost be?

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