Description
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
hello bro, let me know what is there to add before times, thanks
SURNAME: 1
Student’s name:
Institutional affiliation:
Course code:
Date of submission:
Results
Table 1. Variable Values Calculated by TK Model and by Hand
α3
α4
𝑎3
𝑎4
Graphical and calculator
80 degrees
7 degrees
-6.2 mm
129.9 mm
TK model
80 degrees
7 degrees
-6.2 mm
139.9 mm
The table above shows values determined by the TK model AND values calculated using
hand were calculated using a calculator and graphical tools. Mainly, by hand, first, we use...
Completion Status:
100%
Review
Review
Anonymous
I use Studypool every time I need help studying, and it never disappoints.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
12 pages
Incident Response Plan
This paper reviews a well-documented Incident Response Plan. The Incident Response plan depicts the roles and responsibili ...
Incident Response Plan
This paper reviews a well-documented Incident Response Plan. The Incident Response plan depicts the roles and responsibilities of the ISR team. The ...
UMGC Week 1 Disaster Recovery & Business Continuity Paper
You have been asked to prepare a short background paper for Sifers-Grayson IT personnel about the importance of being prep ...
UMGC Week 1 Disaster Recovery & Business Continuity Paper
You have been asked to prepare a short background paper for Sifers-Grayson IT personnel about the importance of being prepared to respond to business disruptions arising from (a) natural disasters and (b) cyber attacks. Such disruptions can adversely impact the availability of IT services and, in turn, prevent the business from conducting operations over an extended period of time. The client has requested that you focus upon the business reasons behind the need for formal disaster recovery procedures and business continuity plans. Your deliverable should be written as a background paper containing at least 7 strong paragraphs.You will need to do additional reading and research before you prepare your paper. The FEMA website https://www.ready.gov is a good place to start.Provide in-text citations and references for 3 or more authoritative sources. Put the reference list at the end of your posting.
8 pages
A Case Study On Munich Gases
Should Munich gases invest 10 million Euros in this new product project? Munich Gases has a long history of supplying gase ...
A Case Study On Munich Gases
Should Munich gases invest 10 million Euros in this new product project? Munich Gases has a long history of supplying gases and liquids to the firm in ...
DAD 220 SNHU Module 3 Create a Program Code Typedprior MySQL Task
Overview
Table joins are commonly used to return records from multiple tables in a normalized database for the purpose of ...
DAD 220 SNHU Module 3 Create a Program Code Typedprior MySQL Task
Overview
Table joins are commonly used to return records from multiple tables in a normalized database for the purpose of generating reports and performing ad-hoc queries. Since data does not all reside in one large table in a normalized database, we use joins to retrieve supporting information for the records we are searching for. Joins connect tables by matching values of keys in the tables to retrieve related records, generally using the SELECT and WHERE commands. For example, if customer_ID is used in a customer table and in an order table, the join would use the CUSTOMER-ID to connect the CUSTOMER table and the ORDER table to create a combined record for each key value matched in the two tables.
Prompt
The manager of a small marketing firm has asked you to identify information on new hires that work at her company. You’ve already entered some information for the new hires, but you will need to enter more. After entering the remaining new information, perform a join that will produce the results requested by the manager. Then, you will need to write the query to save the results and write them to a comma-separated values (CSV) file, which is a delimited text file that uses a comma to separate values so they can be archived. Please revisit the instructions from the Module Two lab to identify the data you will need.
Before you begin, type the following commands prior to typing MySQL to set file permissions. This will allow you to perform the file output creation:
chmod +x change_perm.sh and then
./change_perm.sh
Then, enter a command line session with MySQL and reconnect to the employee information you entered in the previous lab.
Write a SELECT statement for the Employee table to check that you have reconnected to the right information.
Update the name of the Branches table that you created in the previous lab to say “Department.”
Use an ALTER statement to successfully RENAME the “Branches” table to “Department.”
Capture these outputs in a screenshot to validate that you have successfully completed this step.
Insert fields to the Department table so that you will be able to perform joins on them.
INSERT INTO Department VALUES
(1, ‘Accounting’),
(2, ‘Human Resources’),
(3, ‘Information Systems’),
(4, ‘Marketing’);
Write a SELECT statement for this table to prove this step and validate that it ran correctly with a screenshot.
Now, perform joins between the Department and Employee tables and show results for how many employees work in each one of the four departments. This will only provide information on the records that are already there.
Department 1 = Accounting
Command: select First_Name, Last_Name, Department.Department_Name from Employee inner join Department on Employee.Department_ID = Department.Department_ID where Employee.Department_ID = 1;
Using SELECT statements similar to the one above, perform joins to produce results for the following records:
Department 2 = Human Resources
Department 3 = Information Systems
Department 4 = Marketing
Capture the results of these joins and validate your work by providing a screenshot. You should have the same number of records as you do employees.
Populate the Employee table with information for ten new employees. Give them unique names and include attributes for all necessary fields. (Note: Please reference attributes from the lab in Module Two. Department ID values must be between 1 and 4.)
Perform a join across the Employee and Department Tables for each of the four departments. New and existing records should be displayed in the results.
Take a screenshot to capture the updated results that the Employee and Department joins show to validate that they have run correctly. You should have the same number of records as you do employees.
Identify the resultant outputs of the commands that you have written:
How many records are returned for employees in each department?
Create a CSV file that contains only the records of employees in Human Resources and Information Systems. If you run this query multiple times, be sure to use a different file name each time. MySQL will not overwrite an existing file.
Enter the command listed below.
Command: select First_Name, Last_Name, Department.Department_Name from Employee inner join Department on Employee.Department_ID = Department.Department_ID where Employee.Department_ID = 3 OR Employee.Department_ID = 2 into outfile'/home/codio/workspace/HRandIS-Employees.csv' FIELDS TERMINATED BY',';
Print the file output to the screen.
You’ll need to type the word quit after your MySQL prompt and then press Enter to exit to the Linux shell. Do not exit the virtual lab environment itself.
Next, print the output of your file to the screen by following these steps:
Type pwd and press Enter, then type ls and press Enter again. This will list your files.
Now, type cat HRandIS-Employees.csv and press Enter.
Capture these outputs in a screenshot to validate that you have successfully completed this step.
Reflections: Provide detailed insight on the prompts below by explaining your process along with how and why it ultimately worked.
Process
Explain how the joins you used in this assignment worked.
Describe why the commands you used were able to retrieve the Department table when you selected the Department name.
File creation and extraction
When you write the records of your query to a CSV file, how many records are in the file?
Provide a detailed explanation of how the process of extracting data to a flat file works.
Electromagnetic Project for Applications of Transmission Lines Lab Report
I will attached the procedure for you to use for this project measurements and simulations.you will need to get 30 days ev ...
Electromagnetic Project for Applications of Transmission Lines Lab Report
I will attached the procedure for you to use for this project measurements and simulations.you will need to get 30 days evaluation copies of either keysight ADS or RF Spice pro.see the requirement
Similar Content
SIA System & Ethical Analysis Engineering Paper
SIA System & Ethical Analysis: Background & Instructions
SIA System & Ethical Analysis: Background & Instr...
Bullwhip of The Forrester Effect Supply Chain Management Engineering Questions
What is the Bullwhip Effect?
How and why does happen?
Explain an example of the Bullwhip (current examples are...
Can you do these 5 assignments?
Can you do these? I only have 50?Assignments.doc ...
Ricardo WAVE Engine Modeling Project
Requirements 1. Please use SI Units 2. Justify your selection to the SOC. Include graphs comparing results of relevant par...
MSU Positive and Negative Aspects of Mobile Phone Use in Peoples Lives Today Paper
MOBILE PHONE
1. INTRODUCTION
As it is said that “Necessity is the mother of invention” it is surely a true thing and w...
Career Academy of Texas Combined Stress Theoretical Portion Check Point
ME180 Mech Properties Materials - SECTIONS 01, 04
Combined Stress: Theoretical Portion Checkpoint - DUE 8/11
25 pts 0 Not ...
Spectrophotometry Lab Report
There are numerous examination apparatuses in the research centre that use light to have the materials interrogated. This ...
Extreme Programming
Vehicles have been operated for most of automotive history with mechanical and electrical controls directly tied to their ...
Answers
...
Related Tags
Book Guides
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
12 pages
Incident Response Plan
This paper reviews a well-documented Incident Response Plan. The Incident Response plan depicts the roles and responsibili ...
Incident Response Plan
This paper reviews a well-documented Incident Response Plan. The Incident Response plan depicts the roles and responsibilities of the ISR team. The ...
UMGC Week 1 Disaster Recovery & Business Continuity Paper
You have been asked to prepare a short background paper for Sifers-Grayson IT personnel about the importance of being prep ...
UMGC Week 1 Disaster Recovery & Business Continuity Paper
You have been asked to prepare a short background paper for Sifers-Grayson IT personnel about the importance of being prepared to respond to business disruptions arising from (a) natural disasters and (b) cyber attacks. Such disruptions can adversely impact the availability of IT services and, in turn, prevent the business from conducting operations over an extended period of time. The client has requested that you focus upon the business reasons behind the need for formal disaster recovery procedures and business continuity plans. Your deliverable should be written as a background paper containing at least 7 strong paragraphs.You will need to do additional reading and research before you prepare your paper. The FEMA website https://www.ready.gov is a good place to start.Provide in-text citations and references for 3 or more authoritative sources. Put the reference list at the end of your posting.
8 pages
A Case Study On Munich Gases
Should Munich gases invest 10 million Euros in this new product project? Munich Gases has a long history of supplying gase ...
A Case Study On Munich Gases
Should Munich gases invest 10 million Euros in this new product project? Munich Gases has a long history of supplying gases and liquids to the firm in ...
DAD 220 SNHU Module 3 Create a Program Code Typedprior MySQL Task
Overview
Table joins are commonly used to return records from multiple tables in a normalized database for the purpose of ...
DAD 220 SNHU Module 3 Create a Program Code Typedprior MySQL Task
Overview
Table joins are commonly used to return records from multiple tables in a normalized database for the purpose of generating reports and performing ad-hoc queries. Since data does not all reside in one large table in a normalized database, we use joins to retrieve supporting information for the records we are searching for. Joins connect tables by matching values of keys in the tables to retrieve related records, generally using the SELECT and WHERE commands. For example, if customer_ID is used in a customer table and in an order table, the join would use the CUSTOMER-ID to connect the CUSTOMER table and the ORDER table to create a combined record for each key value matched in the two tables.
Prompt
The manager of a small marketing firm has asked you to identify information on new hires that work at her company. You’ve already entered some information for the new hires, but you will need to enter more. After entering the remaining new information, perform a join that will produce the results requested by the manager. Then, you will need to write the query to save the results and write them to a comma-separated values (CSV) file, which is a delimited text file that uses a comma to separate values so they can be archived. Please revisit the instructions from the Module Two lab to identify the data you will need.
Before you begin, type the following commands prior to typing MySQL to set file permissions. This will allow you to perform the file output creation:
chmod +x change_perm.sh and then
./change_perm.sh
Then, enter a command line session with MySQL and reconnect to the employee information you entered in the previous lab.
Write a SELECT statement for the Employee table to check that you have reconnected to the right information.
Update the name of the Branches table that you created in the previous lab to say “Department.”
Use an ALTER statement to successfully RENAME the “Branches” table to “Department.”
Capture these outputs in a screenshot to validate that you have successfully completed this step.
Insert fields to the Department table so that you will be able to perform joins on them.
INSERT INTO Department VALUES
(1, ‘Accounting’),
(2, ‘Human Resources’),
(3, ‘Information Systems’),
(4, ‘Marketing’);
Write a SELECT statement for this table to prove this step and validate that it ran correctly with a screenshot.
Now, perform joins between the Department and Employee tables and show results for how many employees work in each one of the four departments. This will only provide information on the records that are already there.
Department 1 = Accounting
Command: select First_Name, Last_Name, Department.Department_Name from Employee inner join Department on Employee.Department_ID = Department.Department_ID where Employee.Department_ID = 1;
Using SELECT statements similar to the one above, perform joins to produce results for the following records:
Department 2 = Human Resources
Department 3 = Information Systems
Department 4 = Marketing
Capture the results of these joins and validate your work by providing a screenshot. You should have the same number of records as you do employees.
Populate the Employee table with information for ten new employees. Give them unique names and include attributes for all necessary fields. (Note: Please reference attributes from the lab in Module Two. Department ID values must be between 1 and 4.)
Perform a join across the Employee and Department Tables for each of the four departments. New and existing records should be displayed in the results.
Take a screenshot to capture the updated results that the Employee and Department joins show to validate that they have run correctly. You should have the same number of records as you do employees.
Identify the resultant outputs of the commands that you have written:
How many records are returned for employees in each department?
Create a CSV file that contains only the records of employees in Human Resources and Information Systems. If you run this query multiple times, be sure to use a different file name each time. MySQL will not overwrite an existing file.
Enter the command listed below.
Command: select First_Name, Last_Name, Department.Department_Name from Employee inner join Department on Employee.Department_ID = Department.Department_ID where Employee.Department_ID = 3 OR Employee.Department_ID = 2 into outfile'/home/codio/workspace/HRandIS-Employees.csv' FIELDS TERMINATED BY',';
Print the file output to the screen.
You’ll need to type the word quit after your MySQL prompt and then press Enter to exit to the Linux shell. Do not exit the virtual lab environment itself.
Next, print the output of your file to the screen by following these steps:
Type pwd and press Enter, then type ls and press Enter again. This will list your files.
Now, type cat HRandIS-Employees.csv and press Enter.
Capture these outputs in a screenshot to validate that you have successfully completed this step.
Reflections: Provide detailed insight on the prompts below by explaining your process along with how and why it ultimately worked.
Process
Explain how the joins you used in this assignment worked.
Describe why the commands you used were able to retrieve the Department table when you selected the Department name.
File creation and extraction
When you write the records of your query to a CSV file, how many records are in the file?
Provide a detailed explanation of how the process of extracting data to a flat file works.
Electromagnetic Project for Applications of Transmission Lines Lab Report
I will attached the procedure for you to use for this project measurements and simulations.you will need to get 30 days ev ...
Electromagnetic Project for Applications of Transmission Lines Lab Report
I will attached the procedure for you to use for this project measurements and simulations.you will need to get 30 days evaluation copies of either keysight ADS or RF Spice pro.see the requirement
Earn money selling
your Study Documents