Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Search results for relational-algebra+made-easy-test-series
1
votes
1
answer
1
MadeEasy Test Series 2018: Databases - Relational Algebra
Consider the following database table Supplier (Sid, Sname, rating) Parts (Pid, Pname, color) Catalog (Sid Pid, cost) Which of the following SQL query correct representation to retrieve Sid’s who supplied every red part.
Consider the following database tableSupplier (Sid, Sname, rating)Parts (Pid, Pname, color)Catalog (Sid Pid, cost)Which of the following SQL query correct representation ...
nikkey123
1.6k
views
nikkey123
asked
Jan 29, 2018
Databases
databases
relational-algebra
made-easy-test-series
+
–
2
votes
3
answers
2
MadeEasy Test Series: Databases - Relational Algebra
Consider relation R' and S' have n' and m' tuples, respectively. Choose the best matching between List-I (Expression) and List-II (Maximum number of tuple): Soln. According to me Answer should be Option C. 1.R union S = m+n (easy nothing to say) 2 ... 3 3 3 5 4 3 3 3 6 Now in R natual join S = m * n So option C should suffice isn't it ?
Consider relation ‘R’ and ‘S’ have ‘n’ and ‘m’ tuples, respectively. Choose the best matching between List-I (Expression) and List-II (Maximum number of t...
Na462
2.7k
views
Na462
asked
Jun 14, 2018
Databases
made-easy-test-series
databases
relational-algebra
natural-join
+
–
1
votes
3
answers
3
Made Easy Test Series:Relational Algebra
... this implication holds true?? Selection operation is commutative. But is two project operation can be merge in one project operation? Can project operation removes duplicates too??
$\pi _{A_{1}}\left ( \pi _{A_{2}}\left ( \sigma _{C_{1}}\left ( \sigma _{C_{2}} \left ( R_{1} \right )\right ) \right ) \right )\rightarrow \pi _{A_{1}}\left ( \sigma _{C...
srestha
1.1k
views
srestha
asked
May 9, 2019
Databases
databases
relational-algebra
made-easy-test-series
+
–
1
votes
1
answer
4
MadeEay Test Series 2018: Databases - Relational Algebra
here for 1st relation algebra operation the join operation is given without condition , will it be considered as natural join or cartesian product?
here for 1st relation algebra operation the join operation is given without condition , will it be considered as natural join or cartesian product?
charul
402
views
charul
asked
Jan 16, 2018
Databases
databases
relational-algebra
made-easy-test-series
madeeasy-testseries-2018
+
–
1
votes
1
answer
5
MadeEasy Subject Test: Databases - Sql
vaishali jhalani
359
views
vaishali jhalani
asked
Jan 7, 2017
Databases
databases
made-easy-test-series
sql
relational-algebra
+
–
–1
votes
0
answers
6
MadeEasy Test Series 2019: Databases - Relational Algebra
PLEASE EXPLAIN WHEATHER IT WOULD BE SOME EC DEPARMENT OR ALL EC DEPARTMENT I THINK ALL BECOZ IT IS SELECTION EID OF STUDENT WHO HAVE NOT ENROLLED IN ANY COURSE OF EC
PLEASE EXPLAIN WHEATHER IT WOULD BE SOME EC DEPARMENT OR ALL EC DEPARTMENT I THINK ALL BECOZ IT IS SELECTION EID OF STUDENT WHO HAVE NOT ENROLLED IN ANY COURSE OF EC
Himanshu Kashyap
657
views
Himanshu Kashyap
asked
Jan 12, 2019
Databases
databases
relational-algebra
made-easy-test-series
+
–
1
votes
1
answer
7
Relation algebra Query
Consider the following relation and instance of relation: Supply(sid,Sname) #sid is key Parts(pid,Pname,Pcolor) #pid is the key Catalog(sid,pid) #sid,pid is the key Number of tuples returned by the above Query is ……...
Consider the following relation and instance of relation:Supply(sid,Sname) #sid is keyParts(pid,Pname,Pcolor) #pid is the keyCatalog(sid,pid) #sid,pid is the keyNumber...
Na462
670
views
Na462
asked
Dec 2, 2018
Databases
databases
relational-algebra
made-easy-test-series
+
–
2
votes
0
answers
8
MadeEasy Test Series 2018: Databases - Relational Algebra
Hello, I always have trouble solving queries where the inner most query is referring to the main query. Can someone please explain how the result is obtained for the following question. Thank You The provided answer is: Age more than 30 and not works for every project with project name database
Hello,I always have trouble solving queries where the inner most query is referring to the main query. Can someone please explain how the result is obtained for the follo...
Aman Krishna
534
views
Aman Krishna
asked
Jan 23, 2018
Databases
made-easy-test-series
databases
relational-algebra
+
–
1
votes
1
answer
9
MadeEasy Subject Test: Databases - Relational Algebra
Can anyone tell why 1st is not correct? My approach:-When we will join drinker and bar,we will get tuples of the drinker and the bar corresponding to his/her city.One tuple per drinker will come.Then we will join this with frequent , ... one tuple,so that will be matched at max. one tuple only.And we project drinker's name. What did i miss?
Can anyone tell why 1st is not correct?My approach:-When we will join drinker and bar,we will get tuples of the drinker and the bar corresponding to his/her city.One tupl...
rahul sharma 5
692
views
rahul sharma 5
asked
Jan 16, 2017
Databases
made-easy-test-series
databases
relational-algebra
+
–
0
votes
0
answers
10
MadeEasy Subject Test: Databases - Relational Algebra
Which of the following relational alzebra queries correct representation to retrieve Eid's of female employees whose salary more than all male employees of the company over database relation Emp (Eid, Salary, Sex) how can q3 be correct according to me ... try to to mach eid to eid but we have renamed eid of male to I hence it wont find any match
Which of the following relational alzebra queries correct representation to retrieve Eid’s of female employees whose salary more than all male employees of the company ...
Pankaj Joshi
1.2k
views
Pankaj Joshi
asked
Jan 31, 2017
Databases
databases
made-easy-test-series
relational-algebra
+
–
3
votes
2
answers
11
MadeEasy Subject Test: Databases - Relational Algebra
Options A) B) C) Both A and B D) None Explain...????
OptionsA)B)C) Both A and BD) NoneExplain...????
Meghashyam Sujay
998
views
Meghashyam Sujay
asked
Jan 15, 2017
Databases
made-easy-test-series
databases
relational-algebra
+
–
0
votes
1
answer
12
MadeEasy Subject Test: Databases - Relational Algebra
pkb
391
views
pkb
asked
Feb 7, 2017
Databases
made-easy-test-series
databases
relational-algebra
+
–
0
votes
1
answer
13
MadeEasy Test Series: Databases - Relational Algebra
#plz check 3rd statement:
#plz check 3rd statement:
Hradesh patel
620
views
Hradesh patel
asked
Dec 6, 2016
Databases
made-easy-test-series
databases
relational-algebra
+
–
1
votes
1
answer
14
MadeEasy Test Series: Databases - Relational Algebra
debanjan sarkar
335
views
debanjan sarkar
asked
Oct 16, 2016
Databases
made-easy-test-series
databases
relational-algebra
+
–
2
votes
1
answer
15
MadeEasy Test Series: Databases - Relational Algebra
debanjan sarkar
503
views
debanjan sarkar
asked
Oct 16, 2016
Databases
made-easy-test-series
databases
relational-algebra
+
–
4
votes
1
answer
16
MadeEasy Test Series: Databases - Relational Algebra
Consider the relations R(A, B) and S(B,C). Which one of the following can evaluate differently than the others? a) πA(R) - ( πA (R - πA,B(R⋈S))) b) πA(R∩ (πA(R) x πB(S))) c) πA( (R x πc(S)) ∩ (πA(R) ... attribute. option c and d represent same query i am not sure about a and b i think option a is same query what are both options representing ??
Consider the relations R(A, B) and S(B,C). Which one of the following can evaluate differently than the others?a) πA(R) - ( πA (R - πA,B(R⋈S)))b) πA(R∩ (πA(R)...
khushtak
1.1k
views
khushtak
asked
Jan 25, 2016
Databases
made-easy-test-series
databases
relational-algebra
+
–
1
votes
1
answer
17
MadeEasy Test Series: Databases - Relational Algebra
Consider the following schema and relational algebra query. Student (Sid, Sname, Sage) Course (Cid, CourseName, Credit) Enrolled (Sid, Cid) πSid(Student) - πSid(σcredit<5 (course) Enrolled) Which of the following is correct about ... should be correct one?? nut 2nd one is given correct plz someone tell me why Second option not first one.
Consider the following schema and relational algebra query.Student (Sid, Sname, Sage)Course (Cid, CourseName, Credit)Enrolled (Sid, Cid) ...
khushtak
1.2k
views
khushtak
asked
Jan 25, 2016
Databases
made-easy-test-series
databases
relational-algebra
+
–
To see more, click for the
full list of questions
or
popular tags
.
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register