RELATIONAL ALGEBRA, NOT SQL!!!

Instructions Try to answer all the questions using what you have learned in class When writing a query, write the query in a way that it would work over all possible database instances and not just for the given example instance! Consider the following University database schema and example instance: Student stuId lastName firstName S1001 Smith Tom S1002 Chin Ann S1005 Lee Perry S1010 Burns Edward S1013 McCarthy Owen S1015 Jones Mary S1020 Rivera Jane major History Math 3 History Art Math Math CS credits 90 6 3 63 0 42 15 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 class Number facId schedule room ART103A F101 MWF9 H221 CS425A F105 TuthF10 M110 CS525A F105 MThF12 M110 HST205A F115 MWF11 H221 MTH101B F110 MTuTh9 H225 MTH103C F110 MWF11 H225 Enroll stuld class Number grade S1001 ART103A A S1001 HST205A S1002 ART103A D D S1002 CS425A F S1002 MTH103C B S1010 ART103A S1010 MTH103C S1020 CS425A B S1020 MTH101B A Question 1.1.26 (3 Points) Insert a new Faculty record with ID of F330, name of Sammy, department of cs, and rank of Instructor. Question 1.1.27 (3 Points) Insert a new student record with ID of S1031, name of Manny Yousef, zero credits, and no major