Create a Java Program do to the following. These tasks can all be done in the main() method. For Tasks 1-3, use a variable name of your choosing.

1. Create a Scanner object for keyboard input.
2. Create a File Object using the file name “MyGrades.txt”.
3. Create a PrintWriter Object using the FileObject created from Step 2.
   1. Allow PrintWrite to throw a FileNotFoundException as part of the main() method header.
4. Create a double variable named myGrade.
5. Create a do while loop with the following tasks in the loop body.
   1. Prompt for a grade and store the result in myGrade
   2. If myGrade is not equal to -99 – Use PrintWriter to “println” myGrade to disk.
   3. If myGrade == -99 – The loop should exit.
6. Close the PrintWriter Object.
7. Create a Scanner Object using the File Object created in Step 2.
8. Create the double variables totalScore and average. Initialize these variables to zero.
9. Create the int variable counter and initialize it to zero.
10. Create a while loop to read each double data item found in the Scanner Object
    1. Increment the counter variable for each loop iteration
    2. Read the file’s double variable into myGrade (As defined in Step 4)
    3. Add myGrade to the totalScore variable.
11. Calculate the average as totalScore / counter
12. Display the counter, totalScore and Average.
    1. Use printf and format specifiers to display the double variables in #####.## format.
13. Close the File Scanner object from Step 7.
14. Close the Scanner object from Step 1.

Here are two sets of data:

Q1:

Data Set #1PERSONTop5_1Top5_2Top5_3Top5_4Top5_5PhilipSeptemberSuperstitionSuper FreakRock SteadyFlashlightJelloRiotAnarchyLabotomyTV PartyLast CaressRobertBlack DogI Feel FineSatisfactionBack In BlackPurple HazeNoelleWonderwallCreepEverlongScatteredGigantorDebbieSunday GirlCarsChristineTemptationWhip ItFlorianOperatorCinemaTitaniumFirestarterTsunamiPatsyAfter MidnightWalk The LineJoleneBreatheFancy

Data Set #2PERSONTop5_1Top5_2Top5_3Top5_4Top5_5JohhnyBlitzkrieg BopRise AbovePunk Rock GirlInstitutionalizedBasket CaseRobertBlack DogI Feel FineSatisfactionBack In BlackPurple HazePhilipSeptemberSuperstitionSuper FreakRock SteadyFlashlightNoelleWonderwallCreepEverlongScatteredGigantorSiouxsieKiss ThemTake On MeRock LobsterLove My WayTainted LovePatsyAfter MidnightWalk The LineJoleneBreatheFancyJelloRiotAnarchyLabotomyTV PartyLast Caress

Perform the following set operations using the above data sets:

1. Intersection of Data Set #1 and Data Set #2

2. Difference (Data Set #2 minus Data Set #1)

3. Union of Data Set #1 and Data Set #2

Q2:SalesOrdersExample database
Display the list of products by the order they are included in along with the category they belong to and their retail price.
Order the list by the category they are in along with the retail price in descending order.
(Hint: The solution requires a JOIN of four tables)
Show your SQL code below:

Q3:

SalesOrdersExample database

List employees and the customers for whom they booked an order
(Hint: The solution requires a JOIN of more than two tables)
Show your SQL code below:

Q4:

EntertainmentAgencyExample database
Find the agents and entertainers who live in the same postal code
(Hint: The solution requires a JOIN on matching values)
Show your SQL code below:

Q5:

RecipesExample database
List all recipes that contain a dairy ingredient
(Hint: The solution requires a JOIN of four tables)
Show your SQL code below:

1-Write a Python program to check if a string ends with a number. If it does, print True. Print False otherwise.

input: 'abcdef'

output: False

input: 'abcdef6'

output: True

input: 'sdfljsa2e923'

output: True

input: 'asdak39239d'

output: False

2-Write a Python program to check that a string contains only alphabets and numbers (a-z, A-Z and 0-9).

The program should print True if the string only contains these characters and False if it contains any other characters.

input: "ABCDEFabcdef123450"

output: True

input: "*&%@#!}{"

output: False

input: "asjgsdi043^32"

output: False

3-Write a program that takes a filename as input from the user and looks for lines of the form:

New Revision: 39772

Extract the number from each of the lines using a regular expression. Compute the average of the numbers and print out the average as an integer.

Enter filename: mbox.txt

38549

Enter filename: mbox-short.txt

39756

Write a program to ask the user to enter (i) a filename and (ii) regular expression. The program should count the number of lines that matched the regular expression.

Enter a filename: "mbox.txt"

Enter a regular expression: ^Author

Expected output: mbox.txt had 1798 lines that matched ^Author

Enter a filename: "mbox.txt"

Enter a regular expression: ^X-

Expected output: mbox.txt had 14368 lines that matched ^X-

Enter a filename: "mbox.txt"

Enter a regular expression: java$

Expected output: mbox.txt had 4218 lines that matched java$ 

Complete the following exercise:

• Use the cis305 database you previously created.
• Use T-SQL to alter the booth and machine tables. Add a foreign key constraint to each table for the product_id referencing product_id in the product table.
• Use T-SQL to alter the booth and machine tables. Add a check constraint to each table for the booth_price in the booth table and the machine_price in the machine table. The check criteria should be booth_price > 0.00 and machine_price > 0.00 respectively.
• Now, right click on the check constraint for booth price under constraints in the booth table. Select Script To…Clipboard. You may now perform a paste (from the clipboard) into your submission document as verification of both the foreign key constraint add and the check constraint add.
• Repeat the previous step for the check constraint in the machine table.
• When you have successfully added the constraints to the table, ensure that you have copied and pasted all of the T-SQL statements and verification results into your assignment submission.

Once you have completed your assignment, copy and paste the script into a Word document and submit it.

Before attempting this project, be sure you have completed all of the reading assignments, nongraded exercises, discussions, and assignments to date.Design and implement Java program as follows:1) Implement converter class hierarchy as follows:a. Converter class which includes:? Private attribute for input of data type double? Default constructor with no parameter which sets input to Double.NaN? Overloaded constructor with input for parameter? Get and set methods for input attribute? Method convert() which returns input valueb. TemperatureConverter class which is a child of Converter and includes:? Constructors which call parent constructors? Overridden convert() method to convert input (Fahrenheit temperature) toCelsius and returns the value. If the instance has no input value, it shouldreturn Double.NaN? Use the following formula for conversion: C = ((F-32)*5)/9c. DistanceConverter class which is a child of Converter and includes:? Constructors which call parent constructors? Overridden convert() method to convert input (distance in miles) to distancein kilometers and returns the value. If the instance has no input value, itshould return Double.NaNd. Use the following formula for conversion: KM = M * 1.609