588 views
0 votes
0 votes

What is the difference between the following two expressions, conceptually and  in terms of relational algebra ?

1. names of girl students with more marks than some boy student
2. names of girl students with marks not less than some boy students

Can someone please give an example to illustrate the difference.

3 Answers

1 votes
1 votes
Just resolve the sentence using discrete maths...

x: Girl student

y: Boy student

f(z): marks of student z

then 1- {x|∃y(f(x)>f(y)}

2- {x|∄y(f(x)<f(y)}

thus the first query means select the girl whose mark is greater than any one of the the boy student( it has to be greater than minimum of the marks of boy students)

and second query means to select the girl whose marks are not less than any boy student (i.e. on negation it becomes that girls marks are greater than every boy student) thus the marks of girl should be greater than maximum marks of the boy students.
0 votes
0 votes
1ST MEANS name of those girls whose marks is more than at least one boy

2nd means name of those girls whose marks is not less than at least one boy.

both  are same  i guess  but 2nd can be more or equal marks . tat is  the difference  

relational algebra depends on the reltional schema
0 votes
0 votes
after reading first two statement  
we can say both statements are same  , statement 2 is indirectly equal to first statement .

Related questions

1 votes
1 votes
2 answers
1
tarunmaganti asked Apr 15, 2018
750 views
If there are three tables to choose from -Sailors(sid,sname); Reserves(sid,bid); Boats(bid,color)Question is to choose a sailor who reserved a red boat.My question is wha...
0 votes
0 votes
1 answer
2
LavTheRawkstar asked Apr 4, 2017
11,867 views
What is fragmentation in terms of networking?The difference between Transparent and non transparent fragmentation is ?