Computers and Technology, 19.02.2021 22:40 spazzinchicago

Instructions: 1. Use Notepad to write the MySQL commands for completing this Test.
2. Test all queries on MySQL Workbench for correct output.
3. Start all Queries by typing the Query Number and short description using # sign as first character to make it a comment.
4. There should be no blank line between query or comments.
5. Save the test as Test2_firstName. txt.
6. Submit on D2L Drop box.
7. If you are not sure how to complete any query, type the Query number and “I cannot complete this query” as comments.
8. Any query generating an error will not be graded for partial credit.
9. All suggested variable name and output columns are in bold letters.
10. Use meaningful appropriate column names if none is suggested. Two point will be deducted for each query output with command or function/expression as column name and not appropriate or suggested column name.

1. Store your full name in a memory variable name.

SQL Command:

2. Display your name using the above memory variable as Hands-on-Test2 Submitted by.

SQL Command:

3. Display the following information from the score table using group by event_id.

SQL Command:

…… continued on next page

4. Display the following records from the student table using the limit option.

SQL Command:

5. Suppose that May 11, 2021 is the Graduation Day. Use the February 20, 2021 as the date with date_format function and date_add function( day as interval) to display the Date of Graduation as Graduation Date. Sample Output is shown below

SQL Command:

6. Store 5.59 as radius in the memory.

SQL Command:

7. Use the above stored variable to compute and display the area as AREA, rounded to two places of decimal. Note: You must use the power function, PI function and Round Function. Sample output.

SQL Command:

…… continued on next page

8. Display Current Date and Time, My Date of Birth, I was born on using the functions now function, date_format(“your cdate_of_birth”, ‘ enter the format here’) , dayname function(“your date of birth) to display the output as shown below (sample):

SQL Command:

9. Using System date and date format to display Today’s date as Today’s Date, your date of Birth using date format as I was born on, and compute your age using any function(s) and your date of birth as I am, rounded to two decimal places with the text years old add to your age in figures. See the given sample.

SQL Command:

10. A quotation “A Thing of Beauty is a Joy for Ever” has been stored in a memory variable Quotation. Use substring function and upper case function to display the Quotation as “Famous Quotation”, and the text Beauty as “Sub String” as shown below:

SQL Command:

Needs to be completed in sql and then pasted in notepad. please help!

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 22:30

Write a full class definition for a class named player , and containing the following members: a data member name of type string .a data member score of type int .a member function called setname that accepts a parameter and assigns it to name . the function returns no value.a member function called setscore that accepts a parameter and assigns it to score . the function returns no value.a member function called getname that accepts no parameters and returns the value of name .a member function called getscore that accepts no parameters and returns the value of score .this is what i have, aparently this is wrong: class player{private: string name; int score; public: void player: : setname (string n){name =n; }void player: : setscore (int s){score = s; }string player: : getname (){return name; }int player: : getscore (){return score; }};

Answers: 2

Answer

Computers and Technology, 23.06.2019 01:40

Writing a modular program in visual c++. i am new to this and not sure what i am missing. i am getting the following error: baddate.cpp: in function ‘int main()’: baddate.cpp: 50: 3: error: ‘else’ without a previous ‘if’elsehere are the instructions and code: writing a modular program in c++in this lab, you add the input and output statements to a partially completed c++ program. when completed, the user should be able to enter a year, a month, and a day. the program then determines if the date is valid. valid years are those that are greater than 0, valid months include the values 1 through 12, and valid days include the values 1 through 31.notice that variables have been declared for you.write the simulated housekeeping() function that contains the prompts and input statements to retrieve a year, a month, and a day from the user.include the output statements in the simulated endofjob() function. the format of the output is as follows: month/day/year is a valid date.ormonth/day/year is an invalid date.execute the program entering the following date: month = 5, day = 32, year = 2014. record the output of this program.execute the program entering the following date: month = 9, day = 21, year = 2002. record the output of this /* program name: baddate.cppfunction: this program determines if a date entered by the user is valid.input: interactiveoutput: valid date is printed or user is alerted that an invalid date was entered*/#include bool validatedate(int, int, int); using namespace std; int main(){// declare variablesint year; int month; int day; const int min_year = 0, min_month = 1, max_month = 12, min_day = 1, max_day = 31; bool validdate = true; // this is the work of the housekeeping() method// get the year, then the month, then the daycout< < "enter the year"< > year; cout< < "enter the month"< > month; cout< < "enter the day"< > day; // this is the work of the detailloop() method// check to be sure date is validif(year < = min_year) // invalid yearvaliddate = false; else if (month < min_month || month > max_month) // invalid monthvaliddate = false; else if (day < min_day || day > max_day) // invalid dayvaliddate = false; // this is the work of the endofjob() method// test to see if date is valid and output date and whether it is valid or notif(validdate == true); {// output statementcout<

Answers: 1

Answer

Computers and Technology, 23.06.2019 22:40

22. sata3 allows for data transfer rates of 600 mb/s. explain why you would likely not be able to copy data from one hard drive to another at anywhere close to this speed. also, what could be upgraded on the computer to achieve transfer speeds closer to 600 mb/s

Answers: 1

Answer

Computers and Technology, 24.06.2019 13:20

In the insert table dialog box, you select the checkbox to create the first row as the header of the table.

Answers: 3

Answer

You know the right answer?

Instructions: 1. Use Notepad to write the MySQL commands for completing this Test.
2. Test al...

Questions