Question: Product maker model type A 1001 pc A 1002 pc A 1003 pc B 1004 pc B 1005 pc B 1006 pc C 1007 pc

Product maker model type A 1001 pc A 1002 pc A

Product
maker model type
A 1001 pc
A 1002 pc
A 1003 pc
B 1004 pc
B 1005 pc
B 1006 pc
C 1007 pc
D 1008 pc
D 1009 pc
D 1010 pc
E 1011 pc
E 1012 pc
E 1013 pc
E 2001 laptop
E 2002 laptop
E 2003 laptop
A 2004 laptop
A 2005 laptop
A 2006 laptop
B 2007 laptop
F 2008 laptop
F 2009 laptop
G 2010 laptop
E 3001 printer
E 3002 printer
E 3003 printer
D 3004 printer
D 3005 printer
H 3006 printer
H 3007 printer

Printer
model color type price
3001 True ink-jet 99
3002 False laser 239
3003 True laser 899
3004 True ink-jet 120
3005 False laser 120
3006 True ink-jet 100
3007 True laser 200

Exercise 2 (relational algebra, 4 pts) Write the following queries for Hardware Database in relational algebra: Find those makers that produce laptops, but not PCs. Find all makers of printers that are cheaper than $150 1. 2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Query 7 (2 pts) Find the makers that produce only printers. Product maker model type A 1001 pc A 1002 pc A 1003 pc B 1004 pc B 1005 pc B 1006 pc C 1007 pc D 1008 pc D 1009 pc D 1010 pc E 1011 pc E...

Q:

fix the following querry its using java relational databasing code is below the answer is to be A,D,E heres the text files pc.txt file PC 5 13 model speed ram hd price 1001 2.66 1024 250 2114 1002...

Q:

maker model type A 1001 pc A 1002 pc A 1003 pc A 2004 laptop A 2005 laptop A 2006 laptop B 1004 pc B 1005 pc B 1006 pc B 2007 laptop C 1007 pc D 1008 pc D 1009 pc D 1010 pc D 3004 printer D 3005...

Q:

Query 2 (2 pts) For each maker that produces printers, find the number of printer models produced by this maker. Output a table consisting of two columns: (maker, number of models). Sort the result...

Q:

Query 4 (2 pts) Find the PC models with the maximum speed. Output a table consisting of five columns: (model, maker, speed, ram, price). Product maker model type A 1001 pc A 1002 pc A 1003 pc B 1004...

Q:

Consider the following three tables: PC, Laptop and Product, and the data as given. Sample Data for PC model speed ram hd price 1001 2.66 1024 250 2114 1002 2.10 512 250 995 1003 1.42 512 80 478 1004...

Q:

Consider the following three tables: PC, Laptop and Product, and the data as given. Sample Data for PC model speed ram hd price 1001 2.66 1024 250 2114 1002 2.10 512 250 995 1003 1.42 512 80 478 1004...

Q:

Product maker model type A 1001 pc A 1002 pc A 1003 pc B 1004 pc B 1005 pc B 1006 pc C 1007 pc D 1008 pc D 1009 pc D 1010 pc E 1011 pc E 1012 pc E 1013 pc E 2001 laptop E 2002 laptop E 2003 laptop A...

Q:

Access Query 1 Find the makers that produce printers, but do not produce PCs or laptops. Product maker model type A 1001 pc A 1002 pc A 1003 pc B 1004 pc B 1005 pc B 1006 pc C 1007 pc D 1008 pc D...

Q:

fix the following querry its using java relational databasing code is below the answer is to be A,D,E heres the text files pc.txt file PC 5 13 model speed ram hd price 1001 2.66 1024 250 2114 1002...

Q:

An important factor in selling a residential property is the number of times real estate agents show a home. A sample of 23 homes recently sold in the Buffalo, New York, area revealed the mean number...

Q:

3. [Need R Programming] Use the Monte Carlo method to approximate the following integral 5+2x2-3 2Vx dx 00 e :-

Q:

Consider a loan of $ 2800 at 7 % compounded quarterly comma with 6 quarterly payments. Find the following. The quarterly payment needed to amortize this loan is $495.66. The total amount of the...

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

1. Do you believe that in every conflict situation, mutually acceptable solutions exist or are available? __ always __ usually __ occasionally __ seldom __ never true

Q:

7. Do you believe that others are worthy of your trust? __ always __ usually __ occasionally __ seldom __ never true

Q:

1. Have two observers witness the team in action as members debate important agenda items or strategies. Write detailed notes on who said what to whom, what was the reaction, and so forth. Once you...