- Considering A Slightly Modified Version Of The University Problem We Saw In Class As Follows Student Studentnr Classif 1 (76.36 KiB) Viewed 44 times
usign the sane database model shown for the previous part write the relation algebra query that will: Get the student #, course #, and midterm grade of the enrollments for coures of the CS department
Considering a slightly modified version of the University problem we saw in class as follows. Student studentNr classif 100 FR 200 SO 300 DR 400 SR 500 FR 600 SR 700 SO 800 SO nationality IUS US ON CN GT US US IUS 8133181 Enrollment student NicourseNr section midTerm final 100 CS 1713 1 95 80 100 ENG1043 1 85 85 100 HIS1033 2 80 85 100 MATI224 1 100 100 200 CS 1213 2 91 90 200CS 3743 1 85 95 200 MAT1224 1 80 300 CS 1083 1 50 75 300 Cs 1213 2 65 80 300 CS 3743 2 58 90 500 CS 1713 3 200 80 500 HIS1033 1 95 90 700 HIS1033 931 90 48 salss 88 ROKEA889 Course course dept OS 1083CS CS 1713 ICS CS 3/743 CS ENG1043 ENG HIS1033 HIS MAT1224 MAT title Intro to CSI intro to es Database System English History of the World Parti Calculus Write the relational algebra query that will: Get the Student Number and nationality of the senior students who have failed (based only on the final grade) the course entitled "Intro to CS IT!