I was wondering if I could get some feedback on the relational algebra I have done and any advice on improving it also if you see anything wrong with my SQL could you possibly point it out.
SELECT CourseName
FROM Course
WHERE CourseNo = 6;
∏CourseName(σCourseNo=6(Course))
SELECT CU.UnitNo
FROM C.Course, CU CourseUnit
WHERE C.CourseName = CU.CourseNo
AND C.CourseName = 'Research';
∏UnitNo(CourseUnit(σCourseName=’Research’(Course)))
SELECT U.UnitName
FROM S Student, SU StudentUnit, U Unit
WHERE S.StudentNo = SU.StudentNo
AND SU.UnitNo = U.UnitNo
AND S.StudentName = 'John Perry';
∏UnitName(Unit(StudentUnit(σStudentName=’John Perry’(Student))))
SELECT count(S.StudentNo) ResearchStudents
FROM C Course, S Student
WHERE C.CourseNo = S.CourseNo
AND C.CourseName = 'Research';
∏ResearchStudents((C)count(StudentNo)(Student (σCourseName=’Research’(Course))))