Consider the following database schema.

COURSES ={CourseNo, Title, Credits}

STUDENTS ={IDNo, Name, DOB, Department}

TRANSCRIPTS ={IDNo, CourseNo, Semester, Year, Grade}

Write the following queries in SQL and in Relational Algebra.

Q5: List all courses (course numbers and titles) taken by John Doe in Spring 2015 in which he has a grade of A. 6: List all courses (course numbers and titles) taken by Computer Science students Q7: List all courses (course numbers and titles) with a credit hour larger than 3 taken by Computer Science students. Q8: Write a query to list all departments, and for each department list the total number of credit hours its students have taken since 2014