I am having a hard time writing these SQL queries. Please specify the following queries in SQL on the database schema shown in the figure below.

1) Retrieve the course names of all courses with the number of credit hours as 4

2) Retrieve the names of all courses and their respective departments taught by professor Chang in 2010 and 2011

3) For each section taught by Professor King, retrieve the course number, semester, year, and the number of students who took the section

4) Retrieve the name and transcript of each freshman student (Class=1) majoring in EE. Transcript includes course name, course number, credit hours, semester, year, and grade for each course completed by the student

in java

Implement a function print2Darray(int[][] array) to print a formatted 4x4 two dimensional integer array. When the array contains {{10, 15, 30, 40},{15, 5, 8, 2}, {20, 2, 4, 2},{1, 4, 5, 0}}, Your output should look like:

{10 15 30 40} {15 5 8 2}{ 20 2 4 2}{ 1450}

Now, implement another function print2DList(ArrayList<ArrayList<Integer>> list) to print a formatted 2D list.

NC3A -

• 3.6 What are the principal ingredients of a public-key cryptosystem?

• 3.7 List and briefly define three uses of a public-key cryptosystem.

• 3.8 What is the difference between a private key and a secret key?

• 3.9 What is a digital signature?

Describe situations in your life when you might need to use encryption or secret codes. How important would it be to have enough understanding of the subject of cryptography to assess the strength of the code you used?

BA3K-

Do a bit of research on CWE, Common Weakness Enumeration.

Write a brief overview of their scoring system.

Pick one of the common weaknesses identified on their site and describe it.

Display a simple message "Welcome" on your demo webpage. When the user hovers over the message, a popup should be displayed with a message "Welcome to our new WebPage!!!".

CC3D- If you were asked by your employer to develop a new Information Security Policy, where would you turn to find resources to build this policy? List the two most important items you would include in this new policy and explain why you felt these were most important.

write an ORIGINAL brief essay of 300 words or more describing the history and background of OWASP.

IN JAVA PLEASE

Program 4: Is there a Prius version? Did you know that the average Boeing 747 airplane uses approximately 1 gallon of fuel per second? Given the speed of the airplane, that means it gets 5 gallons to the mile. No, not 5 miles to the gallon, 5 gallons to the mile. You may be questioning why such a horribly inefficient machine is allowed to exist, but you’ll be happy to find out that, because this airplane hold 568 people, it averages about 0.01 gallons per person – (100 miles per gallon per person). Your job is to design (pseudocode) and implement (source code) a program that asks the user for a distance the plane has to fly (i.e. the length of the trip) and also asks the cost of jet fuel (which is currently $1.80 per gallon). The program should then calculate the total fuel charges to make the trip. Next, ask the user how many people will fly, as well as the average cost of a ticket. Finally, print the total profit made (or lost) and the average gas mileage per person. Document your code and properly label the input prompts and the outputs as shown below.

Sample run 1: Enter the flight distance: 1000 Enter the current cost of jet fuel: $2 The flight will cost $10000.0 in fuel. Enter the number of passengers: 5 Enter the average cost of a ticket: 1000 You will make a profit of $-5000.0 You averaged 1.0 miles per person per gallon!

Sample run 2: Enter the flight distance: 500 Enter the current cost of jet fuel: $3 The flight will cost $7500.0 in fuel. Enter the number of passengers: 500 Enter the average cost of a ticket: 300 You will make a profit of $142500.0 You averaged 100.0 miles per person per gallon!

Sample run 3: Enter the flight distance: 4200 Enter the current cost of jet fuel: $1.80 The flight will cost $37800.0 in fuel. Enter the number of passengers: 550 Enter the average cost of a ticket: 600 You will make a profit of $292200.0 You averaged 110.0 miles per person per gallon!

External sort: Write an external merge sort in c++ that takes in an input file with 120 integers. You are allowed to hold a maximum of 20 integers in memory. You must create 2 files to process the integers and they must be sorted and placed in the original file.

c++ programming

1. What will the following C++ code display?

int numbers[4]={99,87};

cout<<numbers[3]<<endl;

1. 87                            b. 0                                  c. garbage                        d. an error

2. What is the output of the following program segment?

double mylist[5];

for(int i=0; i<5; i++)

mylist[i]= (pow(i,2)+ 1 /2.0;

cout<<fixed<<showpoint<<setprecision(2);

for(int i=0; i<5; i++)

{ cout<<setw(5)<<mylist[i];

}

              a. .5           1.5        4.5        9.5        16.5

              b. 0.50      1.50      4.50      9.50     16.50

             c. 0.50      1.50      8.50     27.50     64.50

            d. 0.50      1.50      2.50      3.50      4.50

     15. what is stored in list after the following C++ statement is executed?

     int list [8];

list[0]=1;

list[1]=2;

for(int i=2; i<7; i++)

{

     list[i]= list[i-1] * list[i-2];

     cout<<setw(5)<<list[i];

}

1. 2    4    8   16   32          b. 2    4    8   16 256         c. 2    4    8   64 256        d. 2    4    8   32 256

16. What is the output of the following C++ segment?

      int i;

int list [8];

list[0]=1;

list[1]=2;

for(int i=2; i<7; i++)

{

     list[i]= list[i-1] * list[i-2];

     cout<<setw(5)<<list[i];

}

for(int i=2; i<7; i++)

{

if( i>3)

    list[i]= list[i]- list[i-1];

cout<<setw(5)<<list[i];

}   

    a.    2    4    16   32 256    2    4    8   28   228      b. 2    4    4   16 256    2    4    4   28      228

   c. 2    4    8   32       256     2     2    4   28 228      d. 2    4    8   32 256    2    4    4   28     228

Given int numbers[]= { 12,145,567,100,1001};

17. Write a function to indicate the position of the highest data?
18. Write a function to determine the maximum value of the numbers [];

Given:

struct nameType { string first_name;   string last_Name;      string middle_Name;   };

struct addressType { string address; string city; string state; string zip; };

struct courseType { string course_Name; int course_number; string major; };

struct dateType { int month; int day; int year;   };

struct studentType { nameType name; int student_ID; addressType address; dateType enrolled;};

19. How many of the following are invalid ?

studentType student;

studentType array[89];

courseType course;

nameType name;

student.gpa=4.0;

student.name.first_name="Robert";

student.course.course_Name="Chem";

array[0].enrolled=student.enrolled;

array[1].name.first_name="Jane";

1. 1                                        b. 3                             c. 2.                                  d. none

20. How of the following statements are invalid ?

studentType student;

studentType array[89];

courseType course;

nameType name;

student.gpa=4.0;

student.name="Robert";

student.course.="Chem";

array[0].enrolled=student.enrolled;

array[1].name.first_name="Jane";

1. 1                                     b. 3                                  c. 2                                   d. none

Explain 3 Register addressing modes?

c++ programming:

Given:

Struct myq

{

double a,b,c

};

     X1= -b + sqrt(b*b-4 * a* c)/2 *a;

      X2= -b- sqrt(b*b- 4 * a * c)/2 * a;

      X0f v= (-b)/( 2*a);

      a>0 if maximum otherwise it is minimum

       b*b – 4*a*c >0    two unrepeated roots

       b*b- 4 * a* c =0 two repeated roots

       b*b- 4 * a* c <0 two complex roots

16. Write a function with an argument to calculate x1, make sure to return value
17. Write a function with an argument to determine x2, with return value.
18. Write s function with an argument to determine x of vertex with return value
19. Write a function with an argument to determine max and min
20. Write a function to determine the roots

write a program which will prompt an array of 12 integers then print the array as an array of 4 columns on 3 rows