Exercise III: Structured Query Language (25 marks) * Department (Deptid, Dname). * Course (CrsId, Cname, DeptId). * Student (Stdld, Sname, level, DeptId). * Enroll(stdia, Crsid, year). * Evaluation (Stdld, Crsid, grade, semester, DeptId). * Lecturer (Lid, Lnane, rank, Deptid). * Teaching (LID, Craid, semester, Deptid, year). A Express the following English queries in SQL 1. Find names of students who got 'A' in the database in the Fall semester. (5 marks) January 19, 2022 1/2 Plot 6 catastale COO, Research and Istil Ara Alpet Rally PDF WWW NIGERIAN TURKISH NILE UNIVERSITY NILE Faculty of Natural and Applied Science NILE UNIVERSITY Database management System II: Mid-Term 2. Find name of courses that 300 and 400 level computer science are taking together. (5 marks) 3. Find courses that Mr Hamid is teaching, (5 marks) 4. List names and Ids of students taught by Dr. Samura.(5 marks) 5. Find IDs and Name of students in 400 levels that have enrolled in a course that belongs to the computer science (CS) department.(5 marks) 32