search
Log In
Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
Welcome to GATE CSE Doubts, where you can ask questions and receive answers from other members of the community.
0 votes
8 views
Given the relational schemas:
ENROLL(SID,C_No,Section) – SID and C_No represent
student id number, course number respectively
TEACH(TID,C_No,Section) – TID represents teacher id
number
ADVISE(TID,SID) TID is the mentor of SID
PRE_REQ(C_No,PRE_C_No) – PRE_C_No is prerequisite
course number
GRADES(SID,C_No,Grade,Year)
STUDENT(SID,S_Name) – S_Name is student name
Write the following queries in SQL.
a)List all students taking courses with Amit and
Yogesh.
b)List all students taking at least one course that
their mentor teaches.
c)List those teachers who teach more than one section
of the same course.
d)List the courses that student Anindya can enroll
in, i.e., has passed the necessary prerequisite
courses but not the course itself.
in Databases 5 points 8 views

Please log in or register to answer this question.

...