Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Kindly use the above basic operators to answer the below questions Find Ids and grades of all students taking any class taught by the faculty
Kindly use the above basic operators to answer the below questions
- Find Ids and grades of all students taking any class taught by the faculty member whose faculty
Id is F101.
- Find the classes and grades for the student Tom Smith.
- Find the IDs of all students in Professor Alex classes. Note that professor Alex is a faculty
member of the History department.
- Find class numbers and the names and majors of all students enrolled in the classes taught by
faculty member F110.
Thanks in advance for your valuable time and effort.
Consider the following University database schema and example instance: Student stuld last Name firstName major credits S1001 Smith Tom History 90 S1002 Chin Ann Math 3 6 S1005 Lee Perry History S1010 Burns Edward Art 63 S1013 McCarthy Owen Math 0 S1015 Jones Mary Math 42 S1020 Rivera Jane CS 15 3 faced F101 F105 F110 F115 F221 Faculty name department Adams Art Tanaka CS Byrne Math Smith History Smith CS rank Professor Instructor Assistant Associate Professor class Number ART103A CS425A CS525A HST205A MTH101B MTH103C Class faced schedule F101 MWF9 F105 TuthF10 F105 MThF12 F115 MWF11 F110 MTuTh9 F110 MWF11 room H221 M110 M110 H221 H225 H225 Enroll stuld class Number grade S1001 ART103A A S1001 HST205A S1002 ART103A D S1002 CS425A F S1002 MTH103C B S1010 ART103A S1010 MTH103C S1020 CS425A B S1020 MTH101B A select o: selects a subset of tuples from relation project 1: deletes unwanted columns from relation union U: tuples in relation 1 plus tuples in relation 2 set difference -: tuples in relation 1, but not in in relation 2 Product X: allows to combine two relations rename p: renames attribute(s) and relationStep 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