In real-life almost every task that we do involves repetition. Discuss in 600 words your position and illustrate this using a real-life situation.

case problem 2Carly's Catering provides meals for parties and special events. In previous chapters, you have developed a class that holds catering event information and an application that tests the methods using four objects of the class. Now modify the Event and EventDemo classes as follows:Modify the method that sets the event number in the Event class so that if the argument passed to the method is not a four-character String that starts with a letter followed by three digits, then the event number is forced to A000. If the initial letter in the event number is not uppercase, force it to be so.Add a contact phone number field to the Event class.Add a set method for the contact phone number field in the Event class. Whether the user enters all digits or any combination of digits, spaces, dashes, dots, or parentheses for a phone number, store it as all digits. For example, if the user enters (920) 872-9182, store the phone number as 9208729182. If the user enters a number with fewer or more than 10 digits, store the number as 0000000000.Add a get method for the phone number field. The get method returns the phone number as a String constructed as follows: parentheses surround a three-digit area code, followed by a space, followed by the three-digit phone exchange, followed by a hyphen, followed by the last four digits of the phone number.Modify the EventDemo program so that besides the event number and guests, the program also prompts the user for and retrieves a contact phone number for each of the sample objects. Display the phone number along with the other Event details. Test the EventDemo application to make sure it works correctly with valid and invalid event and phone numbers.Save the files as Event.java and EventDemo.java.case problem 1Sammy's Seashore Supplies rents beach equipment to tourists. In previous chapters, you have developed a class that holds equipment rental information and an application that tests the methods using four objects of the class. Now modify the Rental and RentalDemo classes as follows:Modify the method that sets the contract number in the Rental class so that if the argument passed to the method is not a four-character String that starts with a letter followed by three digits, then the contract number is forced to A000. If the initial letter in the contract number is not uppercase, force it to be so.Add a contact phone number field to the Rental class.Add a set method for the contact phone number field in the Rental class. Whether the user enters all digits or any combination of digits, spaces, dashes, dots, or parentheses for a phone number, store it as all digits. For example, if the user enters (920) 872-9182, store the phone number as 9208729182. If the user enters a number with fewer or more than 10 digits, store the number as 0000000000.Add a get method for the phone number field. The get method returns the phone number as a String constructed as follows: parentheses surround a three-digit area code, followed by a space, followed by the three-digit phone exchange, followed by a hyphen, followed by the last four digits of the phone number.Modify the RentalDemo program so that besides the contract number and minutes, the program also prompts the user for and retrieves a contact phone number for each of the sample objects. Display the phone number along with the other Rental details. Test the RentalDemo application to make sure it works correctly with valid and invalid contract and phone numbers.Save the files as Rental.java and RentalDemo.java.

***Login information and student schema will be given***In this lab, you will learn how to write Advanced queries using Aggregate Functions and Table Joins. You will write 10 SQL SELECT statements to query the STUDENT schema. Your Select Statements should run error-free and should be valid.Submit two separate files: one plain text file (.txt or .sql file) with your SELECT statements only; and the other document (doc/docx/pdf) include both your SELECT statements and your query results (copy and paste text or screen shots). The instructor and TA should be able to run your plain text source file as script and generate the same output as shown in your result document.Q1. List all courses that have "Intro to Information Systems" as prerequisite. (HINT: use a subquery)Q2. List all courses with above average cost. Display course description, cost, and the average cost of all courses. (HINT: use a subquery)Q3. For each zip that has at least one instructor, list the total number of instructors in that zipcode.Q4. For each city in the state of CT, list the total number of students live in that city. Display city, state, number of students in descending order.-- AGGREGATION OF FULL RESULT SETQ5. Find the minimum, maximum, and average grade of final exams in sections taught by Todd Smythe.Q6: For all students who took "Intro to Information Systems", calculate the highest, lowest, and average midterm exam grade for each section. Display Section No and calculation results.-- TABLE JOIN WITH HAVING-CLAUSEQ7. List the instructor id and name of the instructors that teach fewer than 10 sections regardless of student enrollment.Q8. Show which city has the most students. Display city and state, and number of students.Q9: List all zipcodes where at least three students AND at least four instructor reside. Show zip, state and city.Q10: List all cities that have 10 or more students and instructor combined. Show city, state, number of student residents, number of instructor residents, and total student/instructor residents in that city. Sort by total in descending order. Learning Resourceshttps://www.w3schools.com/sql/sql_join.asphttps://docs.oracle.com/database/121/SQLRF/functions.htm#SQLRF006