Q1. Write Sql Query in accoding above. Q2. If a student needs to score more than

Question

Q1. Write Sql Query in accoding above.

Q2. If a student needs to score more than 35 marks to pass an exam, what does the query return?

Student (school-id, sch-roll-no, sname, saddress) Enrolment(school-id sch-roll-no, erollno, examname) ExamResult(erollno, examname, marks]) Consider the following tuple relational calculus query ftl3 E e Enrolment t- E.school-id a x x e Enrolment x.school-id-t (3 B e ExamResult B.erollno-x.erollno B.examname - x.examname a B.marks> 35)1 I {x 1 x Enrolment ^ xschool-id = t},-100-35}

Explanation / Answer

Answer 1).

In 1st query, It is picking up tuple of students who enroll in some exam and got greater than 35 marks in that exam.

In 2nd query, It is picking up tuple of students where 35% students enrolled and all of them got greater than 35 marks in some exam.

Answer 2). the query return,

schools with more than 35% of its students enrolled in some exams .

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.