Homework Answers
Question 18:
Correct option is C) The report will have column named HolidayBonus, and 3500 will be shown in that column.
Explanation: In our query we select stfFName, salary, (0.05 * salary) as HolidayBonus so stfID 1012 has salary= 70000 and 70000 * 0.05 = 3500.
Question 19:
Correct option is D)stfID, stfFName, stfLName, Salary
Explanation: Select * will select all columns from table.
Question 20:
Correct option is B) Greenburg, Linda.
Explanation: concat function is used here which cocatenate stfLName, a comma(, ) and stfFName so stfID has stfLName = Greenburg, stfFName = Linda.
Add Answer to:
Question 18 (1 point) Use the Staff table, as shown below, to answer question 18 to...
Question 10 (1 point) 10. If the following SQL statement is executed, what should be the...
Question 10 (1 point) 10. If the following SQL statement is executed, what should be the query result? select ID, Name from Student where Hometown "San Antonio" D) Gina Lauren C) 1002 Gina 1004 Lauren B) Null A) San Antonio Question 7 (1 point) Saved Using the Student table, as shown below, to answer question 7 to 10 Name ID Grade Hometown Eric 1001 A Dallas Gina 1002 B San Antonio Eric 1003 Seattle Lauren 1004 A San Antonio Kathy...
Question 18 (1 point) Use the following information to answer question 18 to 20. Suppose there...
Question 18 (1 point) Use the following information to answer question 18 to 20. Suppose there are two tables in a database for an e-commerce website. One table is called Products. The other one is called Orders. Their structures and data records are showed below: Products Table Orders Table ProdID Ordid ProdID Quantity 1 ProdName iPhone Android 1 1 2 2 1 1 3 Windows 3 2 2 4 4 1 18. If we have the following statement: select Products....
IN THE PREVIOUS CHAPTER WE MADE A DATABASE USING OUR LAST NAME AS ITS NAME. QUESTION...
IN THE PREVIOUS CHAPTER WE MADE A DATABASE USING OUR LAST NAME
AS ITS NAME. QUESTION 1 STATES THIS.
PLEASE TYPE WHAT NEEDS TO BE TYPED FOR ALL STEPS. THIS USES
CODIO
a. 1. Connect to the database you created and named in Module One (for example, Jetson). Type after the prompt mysql> a. use (table you named); i. Example: mysql> use Jetson; 2. Create the Employee table using the SQL statement shown here. Press Return after each line. CREATE...
Question 1 Use the data below to answer the questions that follow The table below gives...
Question 1 Use the data below to answer the questions that follow The table below gives the approximate salaries (in millions of dollars) of the 13 members of the Los Angeles Lakers basketball team for the 2011-2012 season. Player Salary Player Salary Kobe Bryant 25.2 millon Derek Fisher Pau Gasol 18.7 millon Matt Barnes 1.9 million Andrew Bynum 15.2 millon Troy Murphy 1.4 million Lamar Odom 8.9 millon Jason Kapone 1.2 million Metta World Peace 6.8 millom Derrick Caracter 0.8...
Question 1 Use the data below to answer the questions that follow. The table below gives...
Question 1 Use the data below to answer the questions that follow. The table below gives the approximate salaries (in millions of dollars) of the 13 members of the Los Angeles Lakers basketball team for the 2011-2012 season. Player Kobe Bryant Pau Gasol Andrew Bynum Lamar Odom Metta World Peace Luke Walton Steve Blake Salary Player 25.2 millon Derek Fisher 18.7 millon Matt Barnes 15.2 millon Troy Murphy 8.9 millon Jason Kapono 6.8 millon Derrick Caracter 5.7 millon Devin Ebanks...
Please answer the question following this tables. Use this tables to answer database management questions. 2....
Please answer the question following this tables. Use this
tables to answer database management questions.
2. List the complete Session table (all rows and all
columns).
4. List the last name and first name of every therapist not
located in Palm Rivers.
6. List the session number and patient number for every therapy
that lasted 60 minutes.
8. List the TherapyCode and description for all therapies that
are billed in 15-minute units. Sort them in order by
description.
10. Currently,...
I need help for SQL homework. the question: the code for part 1,2: drop table Customer;...
I need help for SQL homework.
the question:
the code for part 1,2:
drop table Customer;
drop table Company;
drop table Cruise;
drop table TravelAgent;
drop table Reservation;
drop sequence customerID_seq;
drop sequence cruiseID_seq;
drop sequence travelAgentID_seq;
drop sequence reservationID_seq;
create table Customer(
customerID number,
firstName varchar2(15),
lastName varchar2(15),
address varchar2(30),
phone number(10) not null,
age number(3),
Constraint Customer_PK Primary Key (customerID),
constraint Customer_unique unique (firstName,lastName,phone),
constraint Customer_check check(phone is not null)
);
create sequence customerID_seq
start with 1
increment...
Ch 1 1. Given the following dat Dec 31 Year 2 Dec 31 Year 1 Total...
Ch 1 1. Given the following dat Dec 31 Year 2 Dec 31 Year 1 Total liabilities S128,250 $120,000 Total stockholders oquity 95.000 80.000 compute the ratio of liabilities to stockholders' equity for each year Round to two decimal places 1.50 and 107, 11.35 and 1.50 respectively respectively 1.07 and 1.19. 1.1.19 and 1.35 respectively respectively The liabilities and stockholder's equity of a company are $132,000 and $244.000, respectively. Assets should equal SS188.00 $132.00 p $376,00 12.000 A financial statement...
Question 10 (1 point) 10. If the following SQL statement is executed, what should be the query result? select ID, Name from Student where Hometown "San Antonio" D) Gina Lauren C) 1002 Gina 1004 Lauren B) Null A) San Antonio Question 7 (1 point) Saved Using the Student table, as shown below, to answer question 7 to 10 Name ID Grade Hometown Eric 1001 A Dallas Gina 1002 B San Antonio Eric 1003 Seattle Lauren 1004 A San Antonio Kathy...
Question 18 (1 point) Use the following information to answer question 18 to 20. Suppose there are two tables in a database for an e-commerce website. One table is called Products. The other one is called Orders. Their structures and data records are showed below: Products Table Orders Table ProdID Ordid ProdID Quantity 1 ProdName iPhone Android 1 1 2 2 1 1 3 Windows 3 2 2 4 4 1 18. If we have the following statement: select Products....
IN THE PREVIOUS CHAPTER WE MADE A DATABASE USING OUR LAST NAME
AS ITS NAME. QUESTION 1 STATES THIS.
PLEASE TYPE WHAT NEEDS TO BE TYPED FOR ALL STEPS. THIS USES
CODIO
a. 1. Connect to the database you created and named in Module One (for example, Jetson). Type after the prompt mysql> a. use (table you named); i. Example: mysql> use Jetson; 2. Create the Employee table using the SQL statement shown here. Press Return after each line. CREATE...
Question 1 Use the data below to answer the questions that follow The table below gives the approximate salaries (in millions of dollars) of the 13 members of the Los Angeles Lakers basketball team for the 2011-2012 season. Player Salary Player Salary Kobe Bryant 25.2 millon Derek Fisher Pau Gasol 18.7 millon Matt Barnes 1.9 million Andrew Bynum 15.2 millon Troy Murphy 1.4 million Lamar Odom 8.9 millon Jason Kapone 1.2 million Metta World Peace 6.8 millom Derrick Caracter 0.8...
Question 1 Use the data below to answer the questions that follow. The table below gives the approximate salaries (in millions of dollars) of the 13 members of the Los Angeles Lakers basketball team for the 2011-2012 season. Player Kobe Bryant Pau Gasol Andrew Bynum Lamar Odom Metta World Peace Luke Walton Steve Blake Salary Player 25.2 millon Derek Fisher 18.7 millon Matt Barnes 15.2 millon Troy Murphy 8.9 millon Jason Kapono 6.8 millon Derrick Caracter 5.7 millon Devin Ebanks...
Please answer the question following this tables. Use this
tables to answer database management questions.
2. List the complete Session table (all rows and all
columns).
4. List the last name and first name of every therapist not
located in Palm Rivers.
6. List the session number and patient number for every therapy
that lasted 60 minutes.
8. List the TherapyCode and description for all therapies that
are billed in 15-minute units. Sort them in order by
description.
10. Currently,...
I need help for SQL homework.
the question:
the code for part 1,2:
drop table Customer;
drop table Company;
drop table Cruise;
drop table TravelAgent;
drop table Reservation;
drop sequence customerID_seq;
drop sequence cruiseID_seq;
drop sequence travelAgentID_seq;
drop sequence reservationID_seq;
create table Customer(
customerID number,
firstName varchar2(15),
lastName varchar2(15),
address varchar2(30),
phone number(10) not null,
age number(3),
Constraint Customer_PK Primary Key (customerID),
constraint Customer_unique unique (firstName,lastName,phone),
constraint Customer_check check(phone is not null)
);
create sequence customerID_seq
start with 1
increment...
Ch 1 1. Given the following dat Dec 31 Year 2 Dec 31 Year 1 Total liabilities S128,250 $120,000 Total stockholders oquity 95.000 80.000 compute the ratio of liabilities to stockholders' equity for each year Round to two decimal places 1.50 and 107, 11.35 and 1.50 respectively respectively 1.07 and 1.19. 1.1.19 and 1.35 respectively respectively The liabilities and stockholder's equity of a company are $132,000 and $244.000, respectively. Assets should equal SS188.00 $132.00 p $376,00 12.000 A financial statement...
Most questions answered within 3 hours.
-
26) Briefly describe, using words or simple diagrams, the
chemiosmotic theory for coupling oxidation to phosphorylation...
asked 1 hour ago -
Suppose that XX is a random variable with mean 16 and standard
deviation 5 . Also...
asked 2 hours ago -
Calculate the number density of argon gas at a temperature of
24C and a pressure of...
asked 5 hours ago -
Alternative
Classification
How to Estimate
Probabilities from Data? ( For continuous Attributes)
And How to generate...
asked 5 hours ago -
An explosion breaks a 20.0-kg object into three parts. The
object is initially moving at a...
asked 6 hours ago -
Calculate the approximate number of residues of Rubisco, which
is involved in carbon fixation in plants,...
asked 7 hours ago -
Other decisions about scientific claims can have a much broader
impact.ENERGYarrow-10x10.png, environment, health, security - all...
asked 8 hours ago -
I need to write a research paper and work cited about this
topic: The United States...
asked 8 hours ago -
Hello! I was wondering if I could have some help?
If the vapor pressure of carvone...
asked 9 hours ago -
An economist wants to estimate the mean per capita income (in
thousands of dollars) for a...
asked 9 hours ago -
What would be the input/output characteristic of a circuit
obtained by putting two of your 2's-complementers...
asked 9 hours ago -
In Drosophila, the transition from the syncytial blastoderm
stage to the cellular blastoderm stage is a...
asked 10 hours ago