Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What information (model, speed, ram, hd, screen, price) is there for laptops made by maker E? Write expressions of relational algebra to answer the following

What information (model, speed, ram, hd, screen, price) is there for laptops made by maker E? Write expressions of relational algebra to answer the following questions using the sequential notation used in the book.

image text in transcribed

The relation Product The relation PC maker model type model speed ram hd price pc pc pc laptop laptop laptop pc pc 250 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 2114 995 478 649 630 1049 510 320 2.66 1024 2.10 1512 1.42 512 2.80 1024 3.20 512 3.20 1024 2.20 1024 2.20 2048 2.00 1024 2.80 2048 1.86 2048 2.80 1024 3.06 512 770 300 laptop 160 650 770 959 649 529 160 80 pc 1 The relation Laptop 1001 1002 1003 2004 2005 2006 1004 1005 1006 2007 1007 1008 1009 1010 3004 3005 1011 1012 1013 2001 2002 2003 3001 3002 3003 2008 2009 2010 3006 3007 model speed ram hd screen price 240 80 printer printer pc pc pc laptop laptop laptop printer printer printer laptop laptop laptop printer printer 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 20.1 17.0 15.4 13.3 17.0 15.4 13.3 15.4 14.1 15.4 3673 949 549 1150 2500 1700 1429 900 680 2300 120 100 80 160 The relation Printer model color type price 99 3001 3002 3003 3004 3005 3006 3007 true false true true false true true ink-jet laser laser ink-jet laser ink-jet laser 239 899 120 120 100 200

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Inductive Databases And Constraint Based Data Mining

Authors: Saso Dzeroski ,Bart Goethals ,Pance Panov

2010th Edition

ISBN: 1489982175, 978-1489982179

More Books

Students also viewed these Databases questions

Question

What is the relationship between humans?

Answered: 1 week ago

Question

What is the orientation toward time?

Answered: 1 week ago