Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started