Question
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
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 2.10 512 250 995 1003 1.42 512 80 478 1004 2.80 1024 250 649 1005 3.20 512 250 630 1006 3.20 1024 320 1049 1007 2.20 1024 200 510 1008 2.20 2048 250 770 1009 2.00 1024 250 650 1010 2.80 2048 300 770 1011 1.86 2048 160 959 1012 2.80 1024 160 649 1013 3.06 512 80 529
product.textfile
Product 3 30 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 printer E 1011 pc E 1012 pc E 1013 pc E 2001 laptop E 2002 laptop E 2003 laptop E 3001 printer E 3002 printer E 3003 printer F 2008 laptop F 2009 laptop G 2010 laptop H 3006 printer H 3007 printer
//System.out.println("Find the manufacturers of PC's with at least three different speeds"); the question that is to be //solve
Relation R10=PC.project("model","speed"); //Relation R11 = R10.thetaJoin(R10, (x, y) -> !x.get("speed").equals(y.get("speed"))).project(R10.name + ".speed"); Relation R11 = R10.naturalJoin(Product).project("maker", "model"); Relation R13 = R11.thetaJoin(R11, (x, y) -> x.get("maker").equals(y.get("maker")) && !x.get("model").equals(y.get("model"))).project(R11.name + ".maker"); R13.showRelation();
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started