IN SQL AND RELATIONAL ALGEBRA

1. In SQL and RA, find the name and phone number of every academic advisor in the Music department, the major they advise, and the name and phone number of every student they advise in that major. 2. In SQL and RA, find the name and phone number of departments that have more than 50 faculty and which offer undergraduate degrees (BA, BFA, BS) that require more than 120 units (the minimum required by the state of California of undergraduate degrees offered at Universities using the semester format). For each such major, also retrieve its name and the minimum number of units required 3. In SQL, find the name of every college, names of departments within the college and the number of academic advisors in the department who started advising recently (i.e. 4. In SQL, find the name of every college and the name and type of every undergraduate degree in the college that has at least 500 students who have declared it as their major. 5. In RA, find the names of departments who only offer graduate degrees (MBA, MFA, MS, PhD). In addition to the department name, also retrieve the name and type of 6. The University wants to introduce a policy whereby a faculty member can serve as an academic advisor only if they've been with the University for at least three years. Write started within the last two years). Also retrieve the number of students who have declared major. degree offered a RA expression and a SQL statement to determine whether or not data in a database satisfies this policy. This problem requires that you explain how the result of the RA expression and SQL statement can be used to answer this question 1. In SQL and RA, find the name and phone number of every academic advisor in the Music department, the major they advise, and the name and phone number of every student they advise in that major. 2. In SQL and RA, find the name and phone number of departments that have more than 50 faculty and which offer undergraduate degrees (BA, BFA, BS) that require more than 120 units (the minimum required by the state of California of undergraduate degrees offered at Universities using the semester format). For each such major, also retrieve its name and the minimum number of units required 3. In SQL, find the name of every college, names of departments within the college and the number of academic advisors in the department who started advising recently (i.e. 4. In SQL, find the name of every college and the name and type of every undergraduate degree in the college that has at least 500 students who have declared it as their major. 5. In RA, find the names of departments who only offer graduate degrees (MBA, MFA, MS, PhD). In addition to the department name, also retrieve the name and type of 6. The University wants to introduce a policy whereby a faculty member can serve as an academic advisor only if they've been with the University for at least three years. Write started within the last two years). Also retrieve the number of students who have declared major. degree offered a RA expression and a SQL statement to determine whether or not data in a database satisfies this policy. This problem requires that you explain how the result of the RA expression and SQL statement can be used to answer this