Write the following queries:

1. Get all employee details from the employee table

2.Get First_Name from employee table using alias name “Employee Name”, sorted descending

3.Get unique DEPARTMENT from employee table

4.Get employee details from employee table whose employee name are “John” and “Roy”

5.Get employee details from employee table whose employee name are not “John” and “Roy”

6.Get employee details from employee table whose first name contains 'o'

7.Get employee details from employee table whose first name ends with 'n'

8.Get employee details from employee table whose Salary between 500000 and 800000

9.Get employee details from employee table whose name is 'John' and 'Michael'

import java.util.LinkedList;
import java.util.Queue;
import java.time.*;

public class CheckOutLine
{
/** This is the main function for the program */
public static void main()
{
System.out.println("\n\tBegin CheckOutLine Demo\n");

System.out.println("\nCreating a Queue called \"register\" based on a LinkedList");
Queue<Customer> register = new LinkedList<Customer>();
  
System.out.println("\nAdding Customers to the Register queue");
// 1. TO DO: add five or more customers to the register line (5 Pts)
// format: register.add(new Customer(name, checkout time));

  
  
  
  
  
System.out.printf("Register line has %d customers\n", register.size());
  
System.out.println("\nDeclare the LocalTime start time as 10:00");
LocalTime lt = LocalTime.parse("10:00:00.00");
  
System.out.println("Start checking out Customers at the register at " + lt);
// 2. TO DO: code a while loop statement to process all the
// customers in the queue (3 Pts)
while(. . . . . . .)
{
Customer cust = register.poll();
lt = lt.plus(Duration.ofMinutes(cust.getMinutes()));
System.out.println(cust.toString() + " checked out at " + lt);
}

System.out.println("\n\tEnd CheckOutLine Demo\n");
}
}

import java.lang.String;

public class Customer
{
private String name;
private int minutes;

/**
* Constructor for objects of class Customer
* @param name - customer name
* @param minutes - number of minutes to check out at register
*/
public Customer(String name, int minutes)
{
this.name = name;
this.minutes = minutes;
}
  
/**
* This method returns the minutes for check out
* @return minutes - the number of minutes to spend checking out at the register
*/
public int getMinutes()
{
return minutes;
}

/**
* This method overrides the toString method of the Object class
* to return the customer information as a String for display
* @return Customer information as a String
*/
@Override
public String toString()
{
return String.format("%-20s %3d minutes ", name, minutes);
}
}

Please make the following changes to the following code:

#This program takes in the first and last name and creates a userID printing first letter of first name and first 7 characters of last name
#by Abi Santo
#9/20/20

def main():
    print("This Program takes your first and last name and makes a User ID")
    f_name = str(input("Please enter your first name ")).lower()
    l_name = str(input("Enter your last name: ")).lower()
    userID = str(f_name[:1]+str(l_name[:7]))
    print(userID)

main()

1. Call the function createUserName(). This function will prompt the user for first and last names, create the userid from the first initial plus the last name, and return the userid to the main() function
2. main() will print out the userid returned from the createUserName().
3. main will then call the function createPassword(). This function will prompt the user for a password. It will return the password to main()
4. The main() function will then call checkFirstCharacter(), passing the first character of the password. CheckFirstCharacter() will check to see if the first character is alphabetic, and return either a True or False value back to main().

5. If a "True" value is received from checkFirstCharacter (see above), then main() will call  checkRemainingChars(), passing the remainder of the password. checkRemainingChars() will check to see if the remainder of the string is alphabetic or numeric, and return a True or False value back to main().

6. If either checkFirstChar or checkRemainingChars returns a value of "False", main() will issue an appropriate error message (specific to which was in error), and prompt the user for a new password.

7. Once the entire password has been validated, main() will print a "Password accepted" message to the user.

C++ using vectors.

in the following code, if a user adds duplicate names the votes should be added to only one of the names:

example

display "Enter candidate name: "

input john

display "Enter candidate vote:"

input 10

display "Enter candidate name: "

input john

display "Enter candidate vote:"

input 10

so the output has to be

john with 20 votes.

#include<iostream>

#include<iterator>

#include<string>

#include<algorithm>

#include<array>

#include<ctime>

#include <vector>

#include<bits/stdc++.h>

using namespace std;

int max_element(const vector<int>&stuff)

{

int max_index =0;

for (int i=1; i<stuff.size();++i)

if (stuff[i]>stuff[max_index])

max_index=i;

return max_index;

}

template <typename type>

void show(const vector<type>&stuff)

{

for (int i=0; i<stuff.size(); i++)

cout <<stuff[i]<<' ';

}

int main()

{

vector<string> names;

vector<int> votes;

string name;

int vote;

int size=5;

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

{

cout<<"enter candidates "<< i+1<<" name: ";

getline(cin, name,'\n');

cout<<"Enter "<<name<< "'s votes ";

cin>>vote;

cin.get();

names.push_back(name);

votes.push_back(vote);

}

for (int k=0; k<size;++k)

{

sort(names.begin(),names.end());

if (names[k-1]==names[k]){

return votes[k];

cout<<"votes "<<votes[k]<<endl;

}

}

int max_index= max_element(votes);

for (int j=0;j<size;++j){

if (votes[j]==votes[max_index])

cout<<"The winners list is bellow "<< names[j]<<endl;

}

return 0;

}

JAVASCRIPT:

Please create an array of student names and another array of student grades.
- Create a function that can put a name and a grade to the arrays.
- Keep Read student name and grade until student name is “???”. And save the reading by using a function
- Create another function to show all the grade in that object.
- Create the third function that can display the maximum grade and the student’s name.
- Create a sorting function that can sort the arrays based on the student’s grade.
- Display all the grades and names sorted by the grade.

Please modify the JavaScript code (HTML) below to meet the requirements, and submit it. Also submit a screenshot of the output.

<html>
<body>
<script>
//store student name in student array and the grade in grade array
function spush(slist, name, sgrade, grade){
slist.push(name);//student list
   sgrade.push(grade);//grade list
}
//show all the student names and their grades
function showlist(slist, sgrade){
var i;
for (i = 0; i < slist.length; i++){
document.writeln(slist[i] +" "+sgrade[i]+ "<br>");
}
}
function findmax(sgrade){
var i;
   var max;
   var maxid;
   max = sgrade[0];
   maxid = 0;
  
   for(i=1;i<sgrade.length; i++){
   if(max < sgrade[i]){
   max = sgrade[i];
       maxid = i;
   }}
  
return maxid;//using index number
   }
var stdlist = [];
var sgrade =[];
var mid;
//instead of following, please use prompt for input
spush(stdlist, "John", sgrade, 90);
spush(stdlist, "Tom", sgrade, 95);
spush(stdlist, "Mary", sgrade, 97);
showlist(stdlist, sgrade);
mid = findmax(sgrade);//max grade index number
  
document.writeln("The maximum grade: "+stdlist[mid]+" "+sgrade[mid]);
</script>
</body>
</html>

1. Read Ch. 3. Using the C++ editor, type the following program:

#include <iostream>

#include <string>

using namespace std;

int main ()

{

       //declarations

string name;

       //input

cout <<"Enter your first name" << endl;

       cin >> name;

       //output

       cout << "Hello " << name << "! " << endl;

       return 0;

}

2. Compile and run. What does the cin statement do?
3. What does the cout statement do?
4. Is name a variable or a constant?
5. What type is name?
6. Add the following line to the declaration statements:

int age;

Add the following lines to your program:

cout << “Enter your age” << endl;

cin >> age;

Compile and Run.

What type is age? Describe this type.

7. Add a line to print the age to the screen. Compile and Run.
8. Add the following line to the declaration statements:

float bodyTemp;

              Add the lines to input and out your body temperature. Compile and run.

              What type is bodyTemp? Describe this type.

9. Add the appropriate declaration, input and output statement for each of the following:

Height (hint, use two variables)

Weight

Sex (hint, use the char type)

Last name

10. Turn in:
    1. The final program
    2. The final output

Answers to these questions only:

3. What is the integer data type and how is it declared in C++?
4. Give an example of where the integer type might be used.
5. What is the real data type and how is it declared in C++?
6. Give an example of where the real type might be used.
7. What is the string data type and how is a string declared in C++?
8. Give an example of where the string type might be used.
9. What is the boolean type and how is an boolean declared in C++?
10. Give an example of where the boolean type might be used.

C++ using vectors.

in the following code, if a user adds duplicate names the votes should be added to only one of the names:

example

display "Enter candidate name: "

input john

display "Enter candidate vote:"

input 10

display "Enter candidate name: "

input john

display "Enter candidate vote:"

input 10

so the output has to be

john with 20 votes.

#include<iostream>

#include<iterator>

#include<string>

#include<algorithm>

#include<array>

#include<ctime>

#include <vector>

#include<bits/stdc++.h>

using namespace std;

int max_element(const vector<int>&stuff)

{

int max_index =0;

for (int i=1; i<stuff.size();++i)

if (stuff[i]>stuff[max_index])

max_index=i;

return max_index;

}

template <typename type>

void show(const vector<type>&stuff)

{

for (int i=0; i<stuff.size(); i++)

cout <<stuff[i]<<' ';

}

int main()

{

vector<string> names;

vector<int> votes;

string name;

int vote;

int size=5;

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

{

cout<<"enter candidates "<< i+1<<" name: ";

getline(cin, name,'\n');

cout<<"Enter "<<name<< "'s votes ";

cin>>vote;

cin.get();

names.push_back(name);

votes.push_back(vote);

}

for (int k=0; k<size;++k)

{

sort(names.begin(),names.end());

if (names[k-1]==names[k]){

return votes[k];

cout<<"votes "<<votes[k]<<endl;

}

}

int max_index= max_element(votes);

for (int j=0;j<size;++j){

if (votes[j]==votes[max_index])

cout<<"The winners list is bellow "<< names[j]<<endl;

}

return 0;

}

Instructions

Write a program in C++ that create a LookupNames project.

In the main function:
Ask the user to enter a number of names, X to quit input.
Store the names in an array.
Also use a counter variable to count the number of names entered.

Write a function displayNames to display the names.
The function must receive the array and the counter as parameters.

Write a function called lookupNames.
The function must receive the array and the counter as parameters.
Ask the user to enter a letter.
Display all the names with the letter that was entered as the first letter of the name.

Call the displayNames and lookupNames functions from the main function.

Tip: declare your functions above the main() function:

void displayNames(char array[][60], int count)
{
// function code here
}

int main()
{
// main code here
displayNames(names, number);
// possible more code here
}

Tip2: make sure your function parameter matches the data type you send as an argument to that function.
In the above example, names and array should have the same data type, and number and count should have the same data type.

Enter name (X to quit input): John Peterson
Enter name (X to quit input): Diane Lee
Enter name (X to quit input): James Smith
Enter name (X to quit input): Frank Xaba
Enter name (X to quit input): Jacky Mokabe
Enter name (X to quit input): x

List of Names

John Peterson
Diane Lee
James Smith
Frank Xaba
Jacky Mokabe

Enter a letter: J

Names starting with the letter J

John Peterson
James Smith
Jacky Mokabe

The comparative balance sheet of Whitman Co. at December 31, 2016 and 2015, is as follows:

The noncurrent asset, noncurrent liability, and stockholders’ equity accounts for 2016 are as follows:

ACCOUNT Land

ACCOUNT Buildings

ACCOUNT Accumulated Depreciation––Buildings

ACCOUNT Equipment

ACCOUNT Accumulated Depreciation ––Equipment

ACCOUNT Bonds Payable

ACCOUNT Common Stock $25 par

ACCOUNT Paid-In Capital in Excess of Par––Common Stock

ACCOUNT Retained Earnings

Prepare a statement of cash flows, using the indirect method of presenting cash flows from operating activities. Refer to the Labels and Amount Descriptions list provided for the exact wording of the answer choices for text entries. Be sure to complete the heading of the statement. In the operating activities section, use the minus sign to indicate cash outflows, decreases in cash and a net cash outflow, if required. In the investing and financing activities section, use a minus sign only to indicate a NET cash outflow for the section.

Labels and Amount Descriptions

Statement of Cash Flows

Prepare a statement of cash flows, using the indirect method of presenting cash flows from operating activities. Refer to the Labels and Amount Descriptions list provided for the exact wording of the answer choices for text entries. Be sure to complete the heading of the statement. In the operating activities section, use the minus sign to indicate cash outflows, decreases in cash and a net cash outflow, if required. In the investing and financing activities section, use a minus sign only to indicate a NET cash outflow for the section.

The comparative balance sheet of Whitman Co. at December 31, 2016 and 2015, is as follows:

The noncurrent asset, noncurrent liability, and stockholders’ equity accounts for 2016 are as follows:

ACCOUNT Land

ACCOUNT Buildings

ACCOUNT Accumulated Depreciation––Buildings

ACCOUNT Equipment

ACCOUNT Accumulated Depreciation ––Equipment

ACCOUNT Bonds Payable

ACCOUNT Common Stock $25 par

ACCOUNT Paid-In Capital in Excess of Par––Common Stock

ACCOUNT Retained Earnings

Prepare a statement of cash flows, using the indirect method of presenting cash flows from operating activities. Refer to the Labels and Amount Descriptions list provided for the exact wording of the answer choices for text entries. Be sure to complete the heading of the statement. In the operating activities section, use the minus sign to indicate cash outflows, decreases in cash and a net cash outflow, if required. In the investing and financing activities section, use a minus sign only to indicate a NET cash outflow for the section.

Labels and Amount Descriptions

Statement of Cash Flows

Prepare a statement of cash flows, using the indirect method of presenting cash flows from operating activities. Refer to the Labels and Amount Descriptions list provided for the exact wording of the answer choices for text entries. Be sure to complete the heading of the statement. In the operating activities section, use the minus sign to indicate cash outflows, decreases in cash and a net cash outflow, if required. In the investing and financing activities section, use a minus sign only to indicate a NET cash outflow for the section.