Using the same database model shown for the previous question, write the relational algebra query that...

Transcribed Image Text:

Using the same database model shown for the previous question, write the relational algebra query that will: Get the student #, course #, and midterm grade of the enrollments for courses of the CS department. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). BIUS Paragraph n student number, coursenumber ( P V Arial V 10pt QUESTION 4 Considering a slightly modified version of the University problem we saw in class as follows. Student Enrollment student Nr classif nationality studentNr courseNr section midTerm final 100 FR US 100 CS 1713 1 95 200 SO US 100 ENG1043 1 85 300 JR CN 100 HIS1033 2 80 555 80 85 85 400 SR CN 100 MAT1224 1 100 100 500 FR GT 200 CS 1713 2 91 90 600 SR US 200 CS 3743 1 85 95 700 SO US 200 MAT1224 1 50 80 800 SO US 300 CS 1083 1 50 75 300 CS 1713 300 CS 3743 500 CS 1713 223 65 80 2 58 90 100 80 500 HIS1033 1 95 90 700 HIS1033 1 95 90 title Intro to CSI Intro to CS II CS Course courseNr dept CS CS 1083 CS 1713 CS CS 3743 ENG1043 ENG Database System English History of the World Part I HIS1033 HIS MAT1224 MAT Calculus I V A T Using the same database model shown for the previous question, write the relational algebra query that will: Get the student #, course #, and midterm grade of the enrollments for courses of the CS department. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). BIUS Paragraph n student number, coursenumber ( P V Arial V 10pt QUESTION 4 Considering a slightly modified version of the University problem we saw in class as follows. Student Enrollment student Nr classif nationality studentNr courseNr section midTerm final 100 FR US 100 CS 1713 1 95 200 SO US 100 ENG1043 1 85 300 JR CN 100 HIS1033 2 80 555 80 85 85 400 SR CN 100 MAT1224 1 100 100 500 FR GT 200 CS 1713 2 91 90 600 SR US 200 CS 3743 1 85 95 700 SO US 200 MAT1224 1 50 80 800 SO US 300 CS 1083 1 50 75 300 CS 1713 300 CS 3743 500 CS 1713 223 65 80 2 58 90 100 80 500 HIS1033 1 95 90 700 HIS1033 1 95 90 title Intro to CSI Intro to CS II CS Course courseNr dept CS CS 1083 CS 1713 CS CS 3743 ENG1043 ENG Database System English History of the World Part I HIS1033 HIS MAT1224 MAT Calculus I V A T