Question: 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 questionsFind Ids and grades of all students taking any class taught by

Kindly use the above basic operators to answer the below questions

  1. Find Ids and grades of all students taking any class taught by the faculty member whose faculty

Id is F101.

  1. Find the classes and grades for the student Tom Smith.
  1. Find the IDs of all students in Professor Alex classes. Note that professor Alex is a faculty

member of the History department.

  1. 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 relation

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!