GATEverse
← GATE IT 2008

Q75

MCQ2 marks, −0.5

Consider the following relational schema: Student(school-id,sch-roll-no‾,sname,saddress)\text{Student} (\underline{\text{school-id}, \text{sch-roll-no}}, \text{sname}, \text{saddress}) School(school-id‾,sch-name,sch-address,sch-phone)\text{School} (\underline{\text{school-id}}, \text{sch-name}, \text{sch-address}, \text{sch-phone}) Enrolment(school-id,sch-roll-no‾,erollno,examname)\text{Enrolment}(\underline{\text{school-id}, \text{sch-roll-no}}, \text{erollno}, \text{examname}) ExamResult(erollno,examname‾,marks)\text{ExamResult}(\underline{\text{erollno}, \text{examname}}, \text{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}\left\{t \mid \exists E \in \text{Enrolment }\;\; t = E.\text{school-id} \wedge \left | \{x \mid x \in \text{Enrolment} \wedge x.\text{school-id} = t \wedge (\exists B \in \text{ExamResult} \;\;B.\text{erollno} = x.\text{erollno} \wedge B.\text{examname} = x.\text{examname} \wedge B.\text{marks} > 35)\}\right | \div \left | \{x \mid x \in \text{Enrolment} \wedge x.\text{school-id} = t\}\right | * 100 > 35\right\} If a student needs to score more than 35 marks to pass an exam, what does the query return?

Sign in to save attempts.

Loading…