Write the relational algebra expressions for the following queries: Here is the Database.

Now the questions..

toyu.course: 11 rows total (approximately) courseld rubric number name 2,000 CSCI 3333 Data Structures 2,001 CSCI 4333 Design of Dat... 2,002 CSCI 5333 DBMS 2,020 CINF 3321 Introduction t... 2,021 CINE 4320 Web Applicati... 2,040 ITEC 3335 Database Dev... 2,041 ITEC 3312 Introduction t... 2,060 ENGL 1410 English I 2,061 ENGL 1311 English II 2,080 ARTS 3311 Hindu Arts 2,090 ACCT 3333 Managerial Ac... credits 3 3 3 3 3 3 3 4 3 3 2,019 To University (toyu) relations tayu.class: 14 rows total (approximately) classid courseld semester year facid room 10,000 2,000 Fall 2,019 1,011 0241 10,001 2,001 Fall 2,019 1,011 0242 10,002 2,002 Fall 2,019 1,012 0136 10,003 2,020 Fall 2,019 1,014 0241 10,004 2,021 Fall 2,019 1,014 0241 10,005 2,040 Fall 1,015 D237 10,006 2,041 Fall 2,019 1,019 0217 10,007 2,060 Fall 2,019 1,020 B101 10,008 2,080 Fall 2,019 1,018 0241 11,000 2,000 Spring 2,020 1,011 D241 11,001 2,001 Spring 2,020 1,013 D242 11,002 2,002 Spring 2,020 1,013 D136 11,003 2,020 Spring 2,020 1,016 0217 11,004 2,061 Spring 2,020 1,018 0101 toyu.department: 7 rows total (approximately) deptCode deptName SchoolCode numFaculty ACCT Accounting BUS 10 ARTS Arts HSH 5 CINE Computer Inf.. CSE 5 CSCI Computer Sci... CSE 12 ENGL English HSH 12 ITEC Information T... CSE 4 MATH Mathematics CSE 7 toyu.faculty: 11 rows total (approximately) Next facid fname Iname deptCode rank 1,011 Paul Smith CSCI Professor 1,012 Mary CSCI Associate Professor 1,013 David Love CSCI (NULL) 1,014 Sharon Mannes CSCI Assistant Professor 1,015 Daniel Kim CINE Professor 1,016 Andrew Byre CINE Associate Professor 1,017 Deborah Gump ITEC Professor 1,018 Art Allister ARTS Assistant Professor 1,019 Benjamin Yu ITEC Lecturer 1,020 Katrina Bajaj ENGL Lecturer 1,021 Jorginlo Neymar ACCT Assistant Professor toyu.school 4 rows total (approximately) schoolCode schoolName BUS Business EDU Education HSH Human Sciences and Humanities CSE Science and Engineering Tran toyu.student: 10 rows total (approximately) Next KIDS stuld fname Iname major minor credits advisor 100,000 Tony Hawk CSCI CINF 40 1,011 100,001 Mary Hawk CSCI CINF 35 1,011 100,002 David Hawk CSCI ITEC 66 1,011 100,003 Catherine Lim ITEC CINE 1,017 100,004 Larry Johnson ITEC (NULL) 1,017 100,005 Linda Johnson CINE ENGL 13 1,015 100,006 Lillian Johnson CINE ITEC 18 1,015 100,007 Ben Zico (NULL) (NULL) 16 (NULL) 100,008 Bill Ching ARTS ENGL 90 1,018 100,009 Linda King ARTS CSCI 125 1,018 20 66 To University (toyu) relations n_alerts 0 (NULL) 3 2 ONOTO toyu.enroll: 22 rows total (approximately) stuld classid grade 100,000 10,000 A 100,001 10,000 (NULL) 100,002 10,000 B- 100,000 10,001 A 100,001 10,001 A- 100,000 10,002 B+ 100,002 10,002 B+ 100,000 10,003 C 100,002 10,003 D 100,004 10,003 A 100,005 10,003 (NULL) 100,000 10,004 A- 100,004 10,004 B+ 100,005 10,004 A- 100,006 10,004 C+ 100,005 10,005 A- 100,006 10,005 A 100,005 10,006 B+ 100,007 10,007 F 100,008 10,007 C- 100,007 10,008 A- 100,000 11,001 D toyu.grade: 13 rows total (approximately) grade gradePoint A 4.0000 A- 3.6667 B 3.0000 B- 2.6667 B+ 3.3333 2.0000 1.6667 2.3333 1.0000 D- 0.6667 D+ 1.3333 F 0.0000 wx (NULL) (NULL) 1 (NULL) 0 (NULL) 0 (NULL) (NULL) 4 0 0 4 Foreign keys: 1. Student(advisor) reference Faculty(Facld) 2. Student(major) references Department(deptCode) 3. Student(minor) references Department(deptCode) 4. Faculty(deptCode) references Department(deptCode) 5. Department(schoolCode) references School(schoolCode) 6. Enroll(Stuld) references Student(Stuld) 7. Enroll(classid) references Class(classid) 8. Enroll(grade) references Grade(grade) 9. Class(courseld) references Course(courseld) 10. Class(Facld) references Faculty(Facid) Using the toyu database (which is provided separately) write the domain relational calculus (DRC) expressions for the following data problem. Note that tuple relational calculus is not acceptable. You may copy and paste the following symbols if desirable: E EVA 3 - (or -). Multiple step answers are acceptable. List the names, majors, minors, and credits of all students who have 30 or more credits, and majoring or minoring in CSCI. together with classid and grades of all courses taken by these students. Enamelname major | minor | credits classid | grade! 401 1 1 1 1 I Tony Hawk Tony Hawk Tony I Hawk I Tony I Hawk Tony I Hawk Tony I Mary Hawk I Hary I Hawk I David Hawk David Hawk I David Hawk I CSCI I CINE ICSCI I CINE 1 I CINE ICSCI I CINE 1 ICSCI | CINE I CSCI I CINE I CSCI | CINEI I CSCI | CINEI cci | ITEC | I CSCI | ITEC ICSCI I ITEC 1 401 401 401 10000 100011 10002 8+ 10003 IC 10004 I - 11001 ID 10000 NULL 10001 | A- 10000 13- 10002 | B+ 10003 ID 1 351 66 | 661 66 T 1 1 1 For the toolbar, press ALT+F10 (PC) or ALT-FN+F10 (Mac). Using the toyu database (which is provided separately), write the SQL query for the following data problem. List the name of students with a grade A in any class. I Name IN Tony | Larry | Johnson | Lillian Johnson For the toolbar, press ALT+F10 (PC) or ALT-FN+F10 (Mac). B I y S Paragraph Arial 14px T 4 Q x X2 > + T " 22 PEX E B (3) # P O WORDS POWERED BY TINY Question 14 10 points Save Answer Using the toyu database (which is provided separately), write the SQL query for the following data problem. For all classes with student 100000 enrolled but not student 100002 enrolled, list the classid and the facld of the instructor. I classia Facid 10001 1011 10004 1014 11001 1013 For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). B I y S Paragraph Arial 14px I do o 6 a X2 X2 10! > TT ABC y 1 " * => 2. EX: : HEB 6) # O WORDS POWERED BY TINY toyu.course: 11 rows total (approximately) courseld rubric number name 2,000 CSCI 3333 Data Structures 2,001 CSCI 4333 Design of Dat... 2,002 CSCI 5333 DBMS 2,020 CINF 3321 Introduction t... 2,021 CINE 4320 Web Applicati... 2,040 ITEC 3335 Database Dev... 2,041 ITEC 3312 Introduction t... 2,060 ENGL 1410 English I 2,061 ENGL 1311 English II 2,080 ARTS 3311 Hindu Arts 2,090 ACCT 3333 Managerial Ac... credits 3 3 3 3 3 3 3 4 3 3 2,019 To University (toyu) relations tayu.class: 14 rows total (approximately) classid courseld semester year facid room 10,000 2,000 Fall 2,019 1,011 0241 10,001 2,001 Fall 2,019 1,011 0242 10,002 2,002 Fall 2,019 1,012 0136 10,003 2,020 Fall 2,019 1,014 0241 10,004 2,021 Fall 2,019 1,014 0241 10,005 2,040 Fall 1,015 D237 10,006 2,041 Fall 2,019 1,019 0217 10,007 2,060 Fall 2,019 1,020 B101 10,008 2,080 Fall 2,019 1,018 0241 11,000 2,000 Spring 2,020 1,011 D241 11,001 2,001 Spring 2,020 1,013 D242 11,002 2,002 Spring 2,020 1,013 D136 11,003 2,020 Spring 2,020 1,016 0217 11,004 2,061 Spring 2,020 1,018 0101 toyu.department: 7 rows total (approximately) deptCode deptName SchoolCode numFaculty ACCT Accounting BUS 10 ARTS Arts HSH 5 CINE Computer Inf.. CSE 5 CSCI Computer Sci... CSE 12 ENGL English HSH 12 ITEC Information T... CSE 4 MATH Mathematics CSE 7 toyu.faculty: 11 rows total (approximately) Next facid fname Iname deptCode rank 1,011 Paul Smith CSCI Professor 1,012 Mary CSCI Associate Professor 1,013 David Love CSCI (NULL) 1,014 Sharon Mannes CSCI Assistant Professor 1,015 Daniel Kim CINE Professor 1,016 Andrew Byre CINE Associate Professor 1,017 Deborah Gump ITEC Professor 1,018 Art Allister ARTS Assistant Professor 1,019 Benjamin Yu ITEC Lecturer 1,020 Katrina Bajaj ENGL Lecturer 1,021 Jorginlo Neymar ACCT Assistant Professor toyu.school 4 rows total (approximately) schoolCode schoolName BUS Business EDU Education HSH Human Sciences and Humanities CSE Science and Engineering Tran toyu.student: 10 rows total (approximately) Next KIDS stuld fname Iname major minor credits advisor 100,000 Tony Hawk CSCI CINF 40 1,011 100,001 Mary Hawk CSCI CINF 35 1,011 100,002 David Hawk CSCI ITEC 66 1,011 100,003 Catherine Lim ITEC CINE 1,017 100,004 Larry Johnson ITEC (NULL) 1,017 100,005 Linda Johnson CINE ENGL 13 1,015 100,006 Lillian Johnson CINE ITEC 18 1,015 100,007 Ben Zico (NULL) (NULL) 16 (NULL) 100,008 Bill Ching ARTS ENGL 90 1,018 100,009 Linda King ARTS CSCI 125 1,018 20 66 To University (toyu) relations n_alerts 0 (NULL) 3 2 ONOTO toyu.enroll: 22 rows total (approximately) stuld classid grade 100,000 10,000 A 100,001 10,000 (NULL) 100,002 10,000 B- 100,000 10,001 A 100,001 10,001 A- 100,000 10,002 B+ 100,002 10,002 B+ 100,000 10,003 C 100,002 10,003 D 100,004 10,003 A 100,005 10,003 (NULL) 100,000 10,004 A- 100,004 10,004 B+ 100,005 10,004 A- 100,006 10,004 C+ 100,005 10,005 A- 100,006 10,005 A 100,005 10,006 B+ 100,007 10,007 F 100,008 10,007 C- 100,007 10,008 A- 100,000 11,001 D toyu.grade: 13 rows total (approximately) grade gradePoint A 4.0000 A- 3.6667 B 3.0000 B- 2.6667 B+ 3.3333 2.0000 1.6667 2.3333 1.0000 D- 0.6667 D+ 1.3333 F 0.0000 wx (NULL) (NULL) 1 (NULL) 0 (NULL) 0 (NULL) (NULL) 4 0 0 4 Foreign keys: 1. Student(advisor) reference Faculty(Facld) 2. Student(major) references Department(deptCode) 3. Student(minor) references Department(deptCode) 4. Faculty(deptCode) references Department(deptCode) 5. Department(schoolCode) references School(schoolCode) 6. Enroll(Stuld) references Student(Stuld) 7. Enroll(classid) references Class(classid) 8. Enroll(grade) references Grade(grade) 9. Class(courseld) references Course(courseld) 10. Class(Facld) references Faculty(Facid) Using the toyu database (which is provided separately) write the domain relational calculus (DRC) expressions for the following data problem. Note that tuple relational calculus is not acceptable. You may copy and paste the following symbols if desirable: E EVA 3 - (or -). Multiple step answers are acceptable. List the names, majors, minors, and credits of all students who have 30 or more credits, and majoring or minoring in CSCI. together with classid and grades of all courses taken by these students. Enamelname major | minor | credits classid | grade! 401 1 1 1 1 I Tony Hawk Tony Hawk Tony I Hawk I Tony I Hawk Tony I Hawk Tony I Mary Hawk I Hary I Hawk I David Hawk David Hawk I David Hawk I CSCI I CINE ICSCI I CINE 1 I CINE ICSCI I CINE 1 ICSCI | CINE I CSCI I CINE I CSCI | CINEI I CSCI | CINEI cci | ITEC | I CSCI | ITEC ICSCI I ITEC 1 401 401 401 10000 100011 10002 8+ 10003 IC 10004 I - 11001 ID 10000 NULL 10001 | A- 10000 13- 10002 | B+ 10003 ID 1 351 66 | 661 66 T 1 1 1 For the toolbar, press ALT+F10 (PC) or ALT-FN+F10 (Mac). Using the toyu database (which is provided separately), write the SQL query for the following data problem. List the name of students with a grade A in any class. I Name IN Tony | Larry | Johnson | Lillian Johnson For the toolbar, press ALT+F10 (PC) or ALT-FN+F10 (Mac). B I y S Paragraph Arial 14px T 4 Q x X2 > + T " 22 PEX E B (3) # P O WORDS POWERED BY TINY Question 14 10 points Save Answer Using the toyu database (which is provided separately), write the SQL query for the following data problem. For all classes with student 100000 enrolled but not student 100002 enrolled, list the classid and the facld of the instructor. I classia Facid 10001 1011 10004 1014 11001 1013 For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). B I y S Paragraph Arial 14px I do o 6 a X2 X2 10! > TT ABC y 1 " * => 2. EX: : HEB 6) # O WORDS POWERED BY TINY