I need a lab report for my VHDL lab for Digital logic class?
User Generated
wlsltxwu
Engineering
Description
I have my code in Eda playground program and the code for the P=(x/+y/)/+XY and I need someone who knows about this program and do the lab report. I HAVE the code already done for this equation and I NEED ONLY the report.
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
This question has not been answered.
Create a free account to get help with this and any other question!
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
EGN 3615 UCF Breeding Practices Dairy Business Stakeholder Analysis Essay
Purpose:The purpose of this assignment is to: identify a stakeholder audiences that will impact or be impacted by your pro ...
EGN 3615 UCF Breeding Practices Dairy Business Stakeholder Analysis Essay
Purpose:The purpose of this assignment is to: identify a stakeholder audiences that will impact or be impacted by your project in some way
a stakeholder is any person or group who would be impacted by your project and the decisions made as part of the project planning and implementation, including private citizens, nonprofit organizations, small businesses, etc. assess how you will communicate with this stakeholdercontribute specific information to your team projectOverview:In addition to identifying and analyzing project costs and benefits, project planning also requires identifying potential stakeholders who may be positively or negatively impacted by or interested in your project. This identification step may take place repeatedly throughout a project as you find that new stakeholder groups become impacted or interested in some way, but the sooner you can identify stakeholders, the sooner you can consider their perspectives and begin planning communications with them. Stakeholders can often be identified through the assessment of project costs, which is why this step is positioned second in this assignment.Required Content and Structure1. Problem Statement and SolutionAs part of this assignment, you will develop a problem statement and a solution statement. The problem statement and solution must be clearly and directly connected, with the proposed solution clearly and directly alleviating the stated problem in some way.You will specifically direct your problem statement and solution statement to your stakeholder audience. Although the problem and solution will not change from audience to audience, the way you describe and relate the problem and your solution must be targeted to your stakeholder audience to achieve the best outcomes.For ExampleA proposal for a new community recreation park and nature preserve that includes a playground, splash pad, dog park, nature trails, exercise trails, sidewalks, an outdoor restaurant, pavilions, a campground, and water access has a wide range of stakeholders. The project managers will discuss their justifications for this project differently with different groups. Consider the different perspectives of the stakeholder audiences below, and think about how the project rationale and approach would be discussed differently depending on each stakeholder audience's particular priorities and concerns.Nature and wildlife conservancy organizations will have a particular set of concerns and priorities related to new construction, runoff, foot traffic, etc., and will need to know why the project is important (e.g., what is this project solving/helping?), and how your approach positively impacts the natural areas and wildlife that the recreation park encroaches on.Local government officials will have some overlapping concerns and priorities, as well as some distinct priorities and concerns about some similar topics. This stakeholder audience will need to consider costs, leases, land use surveys, patron safety, potential local economic impacts, and public health and safety concerns and precautions (e.g., sanitation, restroom facilities, bears, etc.).Community members will have a variety of overlapping concerns with conservancy organizations and government officials, depending on their perspectives, backgrounds. This stakeholder group will also have a variety of interests, concerns, and priorities about the park, which may include topics such as increased traffic to the park through adjacent neighborhoods (and the related need for new sidewalks, stop signs, speed bumps, etc. to improve pedestrian and road safety), hours of operation, patron safety, accessibility, noise levels, and property value. Even though each of these stakeholders requires different kinds of information and assurances about the impacts (i.e., the costs and benefits) of the project, the project itself and the overarching rationale of and approach to the project (i.e., problem statement and solution) do not change.At the top of your submission, include a problem statement (~1-2 paragraphs) followed by a description of your engineering solution (~1 paragraph). Students' problem statements and solutions must be written individually -- this is not a collaborative assignment.**Remember, the problem statement and solution must be clearly and directly connected, with the proposed solution clearly and directly alleviating the stated problem in some way.**2. Potential StakeholderProvide citations throughout. Identify 1 specific potential stakeholder associated with your projectYour stakeholder must be specific."Farmers" is not specific enough"Dairy farms" is acceptably narrow but "independently owned dairy farms," or a specific business like "M&B Products" is even betterAlthough "Tampa Bay Area citizens" sounds very broad, they are a specific subsection of Florida citizenry who may be similarly impacted by your projectHowever, the broader the stakeholder group, the more difficult the analysis.Instead, you might focus on a particular subsection of Tampa Bay citizens, such as "Tampa Bay Area children." A more narrow focus will allow you to focus your analysis in a specific way.Research your stakeholder and identify the following (use full sentences):1. Stakeholder background and cultural considerations (~2 paragraphs)Provide an overview of your stakeholder's background. Offer clear, specific information that provides a holistic sketch of your stakeholder. For example:Example: Founded in 1930 by George Jenkins, Publix is currently owned by X and has a net worth of y, with ___ of their ___ stores located in Florida. Publix is the x-ranked/sized food retailer in Tampa, with x-number of stores in the city serving approximately y-number of people. Publix’s values and philanthropy includes x, y, and z.Publix was recognized by the state of Florida for their outstanding commitment to ___ in 2008, and were nationally recognized in ____, _____, and _____ by the non-profit organization Feeding America for their local and statewide contributions and continued dedication to ending hunger in their communities.Concerning culture, Publix's corporate culture can be summed up by this sentence from the "About" page on their website: "Taking care of our customers, communities and each other is still what Publix is all about." Publix's community outreach, focus on sustainability, and belief in people and their potential strongly shapes Publix's business practices and decision making. Publix believes that their employees make the business, and that the communities shape the people, so Publix not only trains, supports, and promotes from within, they also invest time and money in employees and their communities. As a result, Publix tackles global issues at a local level through civic engagement and sustainable practices.Remember that "culture" includes multiculturalism and cocultures, and that you cannot simply assume that a person, group, company, region, etc. will think, act, or value the things that you believe are most important to the dominant culture. The perspectives of your stakeholders may be very different from yours.2. Stakeholder interestProblem: Why does this stakeholder care about the problem as articulated in your problem statement? How are they impacted by the problem as articulated in your problem statement? (~2-4 sentences/~50-100 words)Solution: Will the stakeholder find your solution clear, familiar, and easy to understand? Why? If the solution is outside of this stakeholder's likely realm of understanding, what will you do to make your solution more concrete and easy to understand? (~2-4 sentences/~50-100 words)Cultural Considerations: What cultural considerations discussed in A above might shape this stakeholder's interest, or affect the way they understand the problem or perceive the proposed solution?3. Probable stakeholder attitude toward the project (positive, negative, neutral, adversarial, competitive, etc.) and why (~2-5 sentences/~50-125 words)4. Include one cost that you think may be particularly important to the stakeholder, and why (~1-3 sentences/~25-75 words)Draw from the bank of costs created by your team in the Costs & Benefits assignment (due last week). To answer "Why," consider the descriptions provided and how your chosen stakeholder may relate to or interpret the provided facts/explanations/descriptions.5. Include one benefit that you think may be particularly important to the stakeholder, and why (~1-3 sentences/~25-75 words)Draw from the bank of benefits created by your team in the Costs & Benefits assignment (due last week). To answer "Why," consider the descriptions provided and how your chosen stakeholder may relate to or interpret the provided facts/explanations/descriptions.6. Based on your own values and goals, what common-ground do you and the stakeholder share? Explain. (~3-6 sentences/~75-150 word)consider shared goals, values, desired outcomes, etc. you can find common ground with any stakeholder, even if you believe they will have a negative or competitive attitude toward your project7. How might this common ground help you positively connect with the stakeholder? How can this common ground help you develop shared meaning with the stakeholder? (3-6 sentences/~75-150 words)
6 pages
The Green Principle
The Green Principle: Plan and Control to Embrace Change The Green Principle: Plan and Control to Embrace Change In the boo ...
The Green Principle
The Green Principle: Plan and Control to Embrace Change The Green Principle: Plan and Control to Embrace Change In the book “Breaking the Code of ...
MacMurray College Project Management IT Schedule Solving Excel Spreadsheet
Complete a Project Schedule.
Details on the Project: IT Project Specifications v2.pdf
Use this project schedul ...
MacMurray College Project Management IT Schedule Solving Excel Spreadsheet
Complete a Project Schedule.
Details on the Project: IT Project Specifications v2.pdf
Use this project schedule template for the assignment: IT Project Schedule template.xlsx
The following is an example of a Project Schedule: Project Schedule Example.pdf
This project must be as an excel spreadsheet.
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.
7 pages
Mstm 6054 Exam
The technology choice that I will propose for an assessment plan is installing video cameras in my relative’s grocery sh ...
Mstm 6054 Exam
The technology choice that I will propose for an assessment plan is installing video cameras in my relative’s grocery shop to increase the level of ...
Describe three factors that help to influence our nation's focus on natural or man-made disasters, engineering homework help
All Students must answer question #1. From the remaining 4 questions, choose 1 additional
question and answer that ques ...
Describe three factors that help to influence our nation's focus on natural or man-made disasters, engineering homework help
All Students must answer question #1. From the remaining 4 questions, choose 1 additional
question and answer that question. It is suggested to use textbook or
course reading documents to support your claims. Be sure to cite sources
where appropriate.Questions:Describe three factors that help to influence our nation's focus on natural or man-made disasters.What
issues have been raised concerning some of the authorities granted to
government agencies in the PATRIOT Act? How have those issues been
addressed?Should FEMA fall under DHS, or should it be its own cabinet level organization? Why?Define Mitigation and Preparedness. Compare and contrast the ideas of each, and give examples to highlight your statements.Compare
and contrast two natural disasters. Provide examples on how they are
similar and different regarding early detection, mitigation,
preparedness, response and recovery.
Similar Content
Hi Sofia, Please can you provide an answer to the attached. Thank You so much
IMG_0018.PNG IMG_0020.PNG IMG_0022.PNG IMG_0023.PNG IMG_0024.PNG IMG_0026.PNG ...
Application Security Assignment.
To obtain information on Windows network security.Review the critical considerations to prepare a procedure guide.Organize...
CHE 226 ASU The Concentration of A Should Be Kept Constant Question
ChE 226 – Reaction Phenomena
For all problems, assume you are given reagents, a reactor which can be set to any temperat...
Engineering work, engineering homework help
Please find attached file for the question. It must be handwritten (no typing) please.plot all the curve please. Simplify ...
University of Cincinnati Preventing Attacks on Web Applications Discussion
Question:
Preventing attacks on web applications
...
Industrial engineering homework
I upload the file needed, please read the instructions carefully and do the three questions, and follow the grading rubric...
engineering context
1. An Engineer is a professional practitioner of engineering. He is one who effectively adapts the finding of science to t...
The Unsinkable Ship
Weighing over 70,000 tons, the Titanic was a huge ship with a huge claim. This claim was that it was unsinkable. The publi...
Homework 2
Therefore by using the principle of direct assembly to the individual elemental stiffness Cancelling out the rows with ze...
Related Tags
Book Guides
A Wrinkle as Time
by Madeleine L'Engle
The 5 Love Languages
by Gary Chapman
Black Beauty
by Anna Sewell
The Awakening
by Kate Chopin
Wuthering Heights
by Emily Brontë
Slaughterhouse Five
by Kurt Vonnegut
Into the Wild
by Jon Krakauer
The Catcher in the Rye
by J. D. Salinger
Treasure Island
by Robert Louis
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
EGN 3615 UCF Breeding Practices Dairy Business Stakeholder Analysis Essay
Purpose:The purpose of this assignment is to: identify a stakeholder audiences that will impact or be impacted by your pro ...
EGN 3615 UCF Breeding Practices Dairy Business Stakeholder Analysis Essay
Purpose:The purpose of this assignment is to: identify a stakeholder audiences that will impact or be impacted by your project in some way
a stakeholder is any person or group who would be impacted by your project and the decisions made as part of the project planning and implementation, including private citizens, nonprofit organizations, small businesses, etc. assess how you will communicate with this stakeholdercontribute specific information to your team projectOverview:In addition to identifying and analyzing project costs and benefits, project planning also requires identifying potential stakeholders who may be positively or negatively impacted by or interested in your project. This identification step may take place repeatedly throughout a project as you find that new stakeholder groups become impacted or interested in some way, but the sooner you can identify stakeholders, the sooner you can consider their perspectives and begin planning communications with them. Stakeholders can often be identified through the assessment of project costs, which is why this step is positioned second in this assignment.Required Content and Structure1. Problem Statement and SolutionAs part of this assignment, you will develop a problem statement and a solution statement. The problem statement and solution must be clearly and directly connected, with the proposed solution clearly and directly alleviating the stated problem in some way.You will specifically direct your problem statement and solution statement to your stakeholder audience. Although the problem and solution will not change from audience to audience, the way you describe and relate the problem and your solution must be targeted to your stakeholder audience to achieve the best outcomes.For ExampleA proposal for a new community recreation park and nature preserve that includes a playground, splash pad, dog park, nature trails, exercise trails, sidewalks, an outdoor restaurant, pavilions, a campground, and water access has a wide range of stakeholders. The project managers will discuss their justifications for this project differently with different groups. Consider the different perspectives of the stakeholder audiences below, and think about how the project rationale and approach would be discussed differently depending on each stakeholder audience's particular priorities and concerns.Nature and wildlife conservancy organizations will have a particular set of concerns and priorities related to new construction, runoff, foot traffic, etc., and will need to know why the project is important (e.g., what is this project solving/helping?), and how your approach positively impacts the natural areas and wildlife that the recreation park encroaches on.Local government officials will have some overlapping concerns and priorities, as well as some distinct priorities and concerns about some similar topics. This stakeholder audience will need to consider costs, leases, land use surveys, patron safety, potential local economic impacts, and public health and safety concerns and precautions (e.g., sanitation, restroom facilities, bears, etc.).Community members will have a variety of overlapping concerns with conservancy organizations and government officials, depending on their perspectives, backgrounds. This stakeholder group will also have a variety of interests, concerns, and priorities about the park, which may include topics such as increased traffic to the park through adjacent neighborhoods (and the related need for new sidewalks, stop signs, speed bumps, etc. to improve pedestrian and road safety), hours of operation, patron safety, accessibility, noise levels, and property value. Even though each of these stakeholders requires different kinds of information and assurances about the impacts (i.e., the costs and benefits) of the project, the project itself and the overarching rationale of and approach to the project (i.e., problem statement and solution) do not change.At the top of your submission, include a problem statement (~1-2 paragraphs) followed by a description of your engineering solution (~1 paragraph). Students' problem statements and solutions must be written individually -- this is not a collaborative assignment.**Remember, the problem statement and solution must be clearly and directly connected, with the proposed solution clearly and directly alleviating the stated problem in some way.**2. Potential StakeholderProvide citations throughout. Identify 1 specific potential stakeholder associated with your projectYour stakeholder must be specific."Farmers" is not specific enough"Dairy farms" is acceptably narrow but "independently owned dairy farms," or a specific business like "M&B Products" is even betterAlthough "Tampa Bay Area citizens" sounds very broad, they are a specific subsection of Florida citizenry who may be similarly impacted by your projectHowever, the broader the stakeholder group, the more difficult the analysis.Instead, you might focus on a particular subsection of Tampa Bay citizens, such as "Tampa Bay Area children." A more narrow focus will allow you to focus your analysis in a specific way.Research your stakeholder and identify the following (use full sentences):1. Stakeholder background and cultural considerations (~2 paragraphs)Provide an overview of your stakeholder's background. Offer clear, specific information that provides a holistic sketch of your stakeholder. For example:Example: Founded in 1930 by George Jenkins, Publix is currently owned by X and has a net worth of y, with ___ of their ___ stores located in Florida. Publix is the x-ranked/sized food retailer in Tampa, with x-number of stores in the city serving approximately y-number of people. Publix’s values and philanthropy includes x, y, and z.Publix was recognized by the state of Florida for their outstanding commitment to ___ in 2008, and were nationally recognized in ____, _____, and _____ by the non-profit organization Feeding America for their local and statewide contributions and continued dedication to ending hunger in their communities.Concerning culture, Publix's corporate culture can be summed up by this sentence from the "About" page on their website: "Taking care of our customers, communities and each other is still what Publix is all about." Publix's community outreach, focus on sustainability, and belief in people and their potential strongly shapes Publix's business practices and decision making. Publix believes that their employees make the business, and that the communities shape the people, so Publix not only trains, supports, and promotes from within, they also invest time and money in employees and their communities. As a result, Publix tackles global issues at a local level through civic engagement and sustainable practices.Remember that "culture" includes multiculturalism and cocultures, and that you cannot simply assume that a person, group, company, region, etc. will think, act, or value the things that you believe are most important to the dominant culture. The perspectives of your stakeholders may be very different from yours.2. Stakeholder interestProblem: Why does this stakeholder care about the problem as articulated in your problem statement? How are they impacted by the problem as articulated in your problem statement? (~2-4 sentences/~50-100 words)Solution: Will the stakeholder find your solution clear, familiar, and easy to understand? Why? If the solution is outside of this stakeholder's likely realm of understanding, what will you do to make your solution more concrete and easy to understand? (~2-4 sentences/~50-100 words)Cultural Considerations: What cultural considerations discussed in A above might shape this stakeholder's interest, or affect the way they understand the problem or perceive the proposed solution?3. Probable stakeholder attitude toward the project (positive, negative, neutral, adversarial, competitive, etc.) and why (~2-5 sentences/~50-125 words)4. Include one cost that you think may be particularly important to the stakeholder, and why (~1-3 sentences/~25-75 words)Draw from the bank of costs created by your team in the Costs & Benefits assignment (due last week). To answer "Why," consider the descriptions provided and how your chosen stakeholder may relate to or interpret the provided facts/explanations/descriptions.5. Include one benefit that you think may be particularly important to the stakeholder, and why (~1-3 sentences/~25-75 words)Draw from the bank of benefits created by your team in the Costs & Benefits assignment (due last week). To answer "Why," consider the descriptions provided and how your chosen stakeholder may relate to or interpret the provided facts/explanations/descriptions.6. Based on your own values and goals, what common-ground do you and the stakeholder share? Explain. (~3-6 sentences/~75-150 word)consider shared goals, values, desired outcomes, etc. you can find common ground with any stakeholder, even if you believe they will have a negative or competitive attitude toward your project7. How might this common ground help you positively connect with the stakeholder? How can this common ground help you develop shared meaning with the stakeholder? (3-6 sentences/~75-150 words)
6 pages
The Green Principle
The Green Principle: Plan and Control to Embrace Change The Green Principle: Plan and Control to Embrace Change In the boo ...
The Green Principle
The Green Principle: Plan and Control to Embrace Change The Green Principle: Plan and Control to Embrace Change In the book “Breaking the Code of ...
MacMurray College Project Management IT Schedule Solving Excel Spreadsheet
Complete a Project Schedule.
Details on the Project: IT Project Specifications v2.pdf
Use this project schedul ...
MacMurray College Project Management IT Schedule Solving Excel Spreadsheet
Complete a Project Schedule.
Details on the Project: IT Project Specifications v2.pdf
Use this project schedule template for the assignment: IT Project Schedule template.xlsx
The following is an example of a Project Schedule: Project Schedule Example.pdf
This project must be as an excel spreadsheet.
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.
7 pages
Mstm 6054 Exam
The technology choice that I will propose for an assessment plan is installing video cameras in my relative’s grocery sh ...
Mstm 6054 Exam
The technology choice that I will propose for an assessment plan is installing video cameras in my relative’s grocery shop to increase the level of ...
Describe three factors that help to influence our nation's focus on natural or man-made disasters, engineering homework help
All Students must answer question #1. From the remaining 4 questions, choose 1 additional
question and answer that ques ...
Describe three factors that help to influence our nation's focus on natural or man-made disasters, engineering homework help
All Students must answer question #1. From the remaining 4 questions, choose 1 additional
question and answer that question. It is suggested to use textbook or
course reading documents to support your claims. Be sure to cite sources
where appropriate.Questions:Describe three factors that help to influence our nation's focus on natural or man-made disasters.What
issues have been raised concerning some of the authorities granted to
government agencies in the PATRIOT Act? How have those issues been
addressed?Should FEMA fall under DHS, or should it be its own cabinet level organization? Why?Define Mitigation and Preparedness. Compare and contrast the ideas of each, and give examples to highlight your statements.Compare
and contrast two natural disasters. Provide examples on how they are
similar and different regarding early detection, mitigation,
preparedness, response and recovery.
Earn money selling
your Study Documents