Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing

Authors: David M. Kroenke

12th Edition International Edition

1292023422, 978-1292023427

More Books

Students also viewed these Databases questions