Write the necessary SQL Queries for the following functions. (25 points) A. Adding a new Professor B. Changing a specific Professor's Professor_Name C. Removing a Flub D. Show a portfolio of the Flubs by a Professor in reverse chronological order E. Show a Flub along with how many Bounces and Citations it has F. Show a portfolio of all Flubs and Bounces (the Flubs bounced) by all of a Professor's Colleagues in reverse chronological order

Create a class named majors that includes an enumeration for the six majors offered by a college as follows: acc, chem, cis, eng, his, phys. display the enumeration values for the user, then prompt the user to enter a major. display the college division in which the major falls. acc and cis are in the business division, chem and phys are in the science division, and eng and his are in the humanities division. save the file as majors.java.