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

 Q1. Write Sql Query in accoding above. Q2. If a student

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}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!