Problem 3 (40 %) : The following figure is part of a university database. Specify the following queries in both relational algebra expression and SQL statements: 1) List the names and addresses of all students who major in CPSC. 2) List the course number (CNUM), each course that the student “John Smith” has enrolled. 3) For the students who major in either CPSC or CPEN, count the number of students in ea (CNAME) and number of units (UNITS) course name major 4) List the names of all students who major in CPSC and do not enroll in any courses. STUDENT MAJOR LNAME DBIRTH ADRRESS CITY SSN FNAME ENROLL CNO GRADE SNO COURSE DEPARTMENT UNITS TEXTBOOK CNAME CNUM