Problem 3 (40 %) : The following figure is part of a university database. Specify the following quer

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

 

Looking for a Similar Assignment? Hire our Top Uk Tutors while you enjoy your free time! All papers are written from scratch and are 100% Original. Try us today! Active Discount Code FREE15