Kindly use the above basic operators to answer the below questions

5. Find all CS majors who have more than 40 credits.

6. Get IDs of all students who have credits value between 3 and 80 inclusive.

7. Find the rooms where each faculty member teaches.

8. Find the courses information for all courses taught by any instructor.

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