Question: Kindly use the above basic operators to answer the below questions 21. a.) List all the students who never got a grade above. b). Change


Kindly use the above basic operators to answer the below questions
21. a.) List all the students who never got a grade above.
b). Change the major of S1020 to Music.
22. a) Change Tanakas department to MIS and rank to Assistant.
b) Change grades of all students in CS425A to A.
23. Insert a new Faculty record with ID of F330, name of Sammy, department of CS, and rank of Instructor.
24. Insert a new student record with ID of S1031, name of Manny Yousef, zero credits, and no major.
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
Get step-by-step solutions from verified subject matter experts
