Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

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

Introduction To Constraint Databases

Authors: Peter Revesz

1st Edition

1441931554, 978-1441931559

Students also viewed these Databases questions