5.course(courseCode, title, creditHours) Faculty(empld, empName, designation, departmentName, salary, hireDate) Allocations(allocationNo, empld, courseCode, semester, classSection) Students(regno, stdName, Program, department, cgpa) Results(regno, allocation No, marks, grade) Tables and their primary keys are given below: course -- coursecode faculty -- empld Allocations -- allocationNo students -- regno results -- regno, allocation No Find course allocations of computer science faculty members who are doctors. Note: a person with PhD degree can work as Assistant Professor or Professor. * (3 Points) Enter your answer 6. course(courseCode, title, creditHours) Faculty(empld, empName, designation, departmentName, salary, hireDate) Allocations(allocationNo, empld, courseCode, semester, classSection) Students(regno, stdName, Program, department, cgpa) Results(regno, allocationNo, marks, grade) Tables and their primary keys are given below: course -- coursecode faculty -- empld Allocations -- allocationNo students -- regno results -- regno, allocationNo Find students who got A grade in courses taught by Dr Nadir in current semester (FA2020). * (4 Points) Enter your