Request Access

#### GATE CSE

This classroom is a private classroom for GATE 2019 (CSE/IT) preparation mentored by the alumni of various IITs and IISc. We will keep part of the content public as well. You can request to join this group of motivated people but... more
53 Members
Gate 2008 IT DBMS Relational

Enrolment(school-id sch-roll-no, erollno, examname)
ExamResult(erollno, examname, marks)

Consider the following tuple relational calculus query.
{t | ∃ E ∈
Enrolment t = E.school-id ∧
| {x | x ∈ Enrolment ^ x.school-id = t ∧

(∃ B ∊ ExamResult B.erollno = x.erollno ∧
B.examname = x.examname ∧

B.marks > 35)}| /

| {x | x ∊ Enrolment ∧

x.school-id = t}| * 100 > 35}
If a student needs to score more than 35 marks to pass an exam, what does the query return?

a The empty set
b schools with more than 35% of its students enrolled in some exam or the other
c schools with a pass percentage above 35% over all exams taken together
d schools with a pass percentage above 35% over each exam

Apoorva Jain
17 Dec 2018 12:39 pm
@ranita mam plz help
Pritam Prasun
23 Dec 2018 03:58 pm
Apoorva, Please correct the question. It seems to have many typos.
Rajesh
9 Feb 2019 02:00 pm
b
preeti Saini
2 Dec 2019 12:10 pm
Nice
##### GATE-2017-Set-1 | Computer Science and Information Technology
Total Questions: 0
This Quiz is not available right now.
##### Transaction Management, Files ​:- 1st Dec - 2018

Hi there,

As per the Virtual GATE - '19 Schedule, classroom discussion will be about Memory Management.

Transaction Management :- https://www.techtud.com/chapter/transaction-management

##### Deadlock :- 26th Nov - 2018

Hi there,

As per the Virtual GATE - '19 Schedule, classroom discussion will be about Deadlock.

##### Process Synchronisation :- 24th Nov - 2018

Hi there,

As per the Virtual GATE - '19 Schedule, classroom discussion will be about Process Synchronisation.

Process Synchronisation :-

##### Process Management :- 23th Nov - 2018

Hi there,

As per the Virtual GATE - '19 Schedule, classroom discussion will be about Process Management.

• Process Management :-

Introduction to Operating System:- https://www.techtud.com/chapter/introduction-operating-system

Process Management:- https://www.techtud.com/chapter/process-management

##### ALU, DMA, I/O - 21th Oct, 2018

Hi there,

As per the Virtual GATE - '19 Schedule, today's classroom discussion will be about  ALU, DMA, I/O .

##### Maths-2 VirtualGATE is postponed

Hello all,

This is to inform you that the maths-2 test will be delayed for a day. We will announce the status by tomorrow.

Actually, the idea is to move the test from http://virtualgate.in to Techtud itself so that we can involve more into the discussion, bookmark specific question for later revision and most of all attempt the test in GATE environment.

The development team is about to finalize the development and hence we have decided to delay this test a bit. However, you are encouraged to keep preparing at the proper pace.

Trust me, the delay is for the greater good.

Below is what is coming:

##### 1Comment
Abhishek Shaw
19 Oct 2018 03:04 pm
@pritam Sir any update ?
##### Machine instructions and addressing modes - 20th Oct, 2018

Hi there,

As per the Virtual GATE - '19 Schedule, today's classroom discussion will be about  Machine instructions and addressing modes .