In this assignment, you will delve deeply into Structured Query Language (SQL) statements. You will review existing SQL statements and troubleshoot them. You would need to determine why the given statements are not functioning properly. At the conclusion of this assignment, you should be able to examine and troubleshoot basic SQL statements.

Scenario:

A good friend of yours is starting a fantasy football league and has created a small database to track the team owners, teams, players, and games. Your friend knows that you are taking a database fundamentals class and has asked you to help. Your friend is not able to figure out why the database is not getting modified in any way. Your friend has given you a copy of the following:

• A database schema diagram. Click here to access the database schema diagram.
• A Microsoft Access database. Click here to access the Microsoft Access database.
• http://vizedhtmlcontent.next.ecollege.com/pub/content/77d17d99-89f1-44c8-81e6-6291c94c294a/AU_IST351_Football_Team_Details.accdb
• The following list of what he or she is trying to do:     
  1. Add a new owner named Alice Wonderland with an owner ID of 1205 and a contact e-mail of
  2. INSERT INTO Owner VALUES (1205, ‘Wonderland’, ‘Alice’, ”) 
  3. Update player 323’s salary to $1,800,000
  4. UPDATE Player salary = 1800000 WHERE player_id = 323 
  5. Display all players whose salary is greater than $1,000,000
  6. SELECT FROM Player WHERE salary > 1000000 
  7. Delete owner Jerry Jones from the database
  8. DELETE FROM Owner last_name = “Jones” AND first_name = “Jerry” 
  9. Update game 0105 with the final score
  10. UPDATE Game SET home_score = 17,     visitors_score = 23 

Note: For this assignment, you will use Microsoft Access 2010 to open the database file provided. If you do not have Microsoft Access 2010, you may download a free trial version of Microsoft Office 2010, which includes Microsoft Access 2010, from the Microsoft website.

Tasks:

1. Open the Microsoft Access file “Football.accdb” by double-clicking on it. You will see the small database created for the fantasy football league.
2. Familiarize yourself with the database by opening and examining the data in each table.
3. There are two queries included with the database that will display some of the information contained in the tables. Double-click each of these to see the results of the query.

Once you are familiar with the database, proceed to the next section.

1. Examine and Correct the Faulty SQL Statements 
   1. For each SQL statement listed above, identify the SQL statement errors.
   2. Once you have identified the errors, rewrite the SQL statements so that they will work.

Note: Take special precautions with Statement 5 above. If you run the statement as it is written above, you will overwrite the scores of all of the existing games in the database.

1. Execute the Statements 
   1. On the Create tab, in the Queries group, click Query Design.
   2. When prompted to add tables, click the Close button.
   3. On the Query Tools Design tab, in the Results group, click on the down arrow below the word View and select SQL View. This is where you will compose your SQL statements. Feel free to type the statements above into the SQL View window and run them (see Step 4) to view the errors. (Note: Take special precautions with Statement 5 above. If you run the statement as it is written above, you will overwrite the scores of all of the existing games in the database.)
   4. To run your SQL statements against the database, click the Runbutton in the Results group. You will be prompted to confirm that you want to modify data in your database. Click Yes. Close the query and save it as “Statement n”, where n is the statement number listed above. For example, you will save the first statement as “Statement 1”.
   5. Repeat this process for each SQL statement provided above.
   6. Once you have completed correcting the SQL statements, save and exit the database.
   7. Save your database as M4_A2_Lastname_Firstname.accdb. 
2. Explain the SQL Statement Errors 
   1. Create a Microsoft Word document explaining what was wrong with each of the five originally written SQL statements. Include any additional comments that you might have about the statements. Save your document as M4_A2_Lastname_Firstname.doc.

Submission Details:

• Save your deliverables as M4_A2_Lastname_Firstname.zip.
• By Week 4, Day 7, submit both the files to the M4 Assignment 2 Dropbox.

Assignment 2 Grading CriteriaMaximum PointsCorrected the faulty SQL statements.40Explained the SQL statement errors.40Wrote in a clear, concise, and organized manner; demonstrated ethical scholarship in accurate representation and attribution of sources (i.e., APA); and displayed accurate spelling, grammar, and punctuation.20Total:100 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

In this assignment, you will create a presentation for your organization to explain how successful collaboration can improve success and provide competitive advantages.

Scenario: Your organization has used a variety of collaboration systems developed by some project managers. Some of these systems were successful while others were not. Your organization has one unique challenge—many of your employees are staffed at other locations or work from home (telework). You would like to standardize the collaboration process to improve team communication for all company projects. In your presentation, you should include the elements listed below.

• Explain why collaboration information systems (IS) are important from the organization’s perspective.
• Discuss how collaboration tools can improve team communication.
• Identify three tools that will be used for synchronous communications and three tools that will be used for asynchronous communications. Be sure to explain why you made these choices.
• Describe how project files, such as Microsoft (MS) Word, MS Excel, MS Project, and MS Visio, will be shared with team members. Be sure to explain the rationale behind your choice.
• Explain how the task list for managing tasks will be shared with team members. Be sure to explain the rationale behind your choice.
• Discuss how this new collaboration IS could provide competitive advantages for your organization.

Your presentation should be a minimum of six slides in length (not counting the title and reference slides). Use of images, graphics, and diagrams is encouraged.

You can use an industry of your choosing or examples from your personal or professional experiences in developing this assignment. You can also use the resources in the Unit II Suggested Reading section to assist you with this assignment.

Be sure to follow the 7×7 rule (i.e., there should be no more than 7 words per line and no more than 7 lines per slide). You are required to use speaker notes to discuss the bullet points on your slides.

You must use at least two academic resources to support your presentation, and you must cite (in APA format) any information on your slides or in your speaker notes that came from these sources.

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

In this Assignment, you will write three paragraphs describing effective persuasive communication in personal, professional, and academic contexts. In each of the three paragraphs, include at least one concrete example of effective persuasive writing that you have encountered or written yourself to illustrate your points, and consider issues like audience, speaker, text, purpose, and context. You can also include information on tone, style, formality, voice, correctness, evidence, and word choice as you develop your responses to the prompts below.

Follow APA 6th edition formatting guidelines, outlined below, for the document. Paragraphs should be well-developed, cohesive, and edited for clarity and correctness. If any sources are referenced, they should be cited in APA 6th edition style, but sources are not required.

Consider the following situations:

• A post on a social media site about the need for sidewalks in your neighborhood so kids can get to school safely
• An email to your boss proposing a new safety procedure
• An academic persuasive essay about your community’s need for a free spay/neuter program

In all of these situations, you need to choose the most appropriate audience, method of communication, and evidence to convey your argument and persuade others to agree with you.

In the first paragraph, describe an example of persuasive communication in personal contexts such as social media posts, emails to friends, or communications to your child’s teachers and explain the considerations you must keep in mind to communicate effectively.

In the second paragraph, describe an example of effective persuasive communication in professional contexts. Consider your own field of study and the expectations for writing effectively in that field and explain how that communication example illustrates the expectations for professional persuasive communication.

In the third paragraph, describe an example of effective persuasive communication in an academic context like a discussion board, assignment, or group presentation. In this paragraph, consider how academic persuasive standards differ from personal and professional writing.

Minimum Submission Requirements

• Respond to the questions in a thorough manner, providing specific examples of concepts, topics, definitions, and other elements asked for in the questions. Your paper should be highly organized, logical, and focused.
• Your paper must be written in Standard English and demonstrate exceptional content, organization, style, grammar, and mechanics.
• Your writing should be well ordered, logical and unified, as well as original and insightful.
• Title page in APA 6th edition manuscript format.
• APA 6th edition manuscript format throughout (e.g., 12-point font, double spacing, and 1-inch margins).
• At least three unified and well-developed paragraphs addressing the prompts.
• If any references are made to sources, they are cited in APA 6th edition style both in-text and on a separate references page.
• Submit the document in Microsoft® Word.

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

In this assignment, you will write a short (1-2 page), opinion paper. The paper is informal in that it is based on your own experiences and opinions. It is not necessary to reference outside resources or to include a cover page or reference list. However, you should critically reflect on your personal experiences and/or apply what you have learned in the module to your current practice. Justify and explain your responses with examples and thorough explanations.

Hint:Overview: The One Thing That Changes Everything

Trust may be something we take for granted until it is injured or destroyed. When that happens, it assumes a new importance. When you think of the people that are important in your life, these are most likely people you trust. We live in a time when we are frequently reminded that trust has to be earned and then reevaluated. Think of some of the public figures that had been trusted and then lost that trust. As you work on this assignment, start developing your trust meter, the instrument that guides you when evaluating trustworthiness.

This assignment is worth 15 points.

Objectives

• Analyze the evolving professional nursing roles of leader/manager within a dynamic health care team

• Design unique strategies to promote adaptation to the professional nursing roles.

• Utilize the critical thinking process in problem solving and decision making.

Directions:

Before completing this assignment, read the first section (pages 1- 26) of Covey’s The Speed of Trust.

In this assignment, you will write a short (1-2 pages), opinion paper. The paper is to be based on your own experiences and opinions. You should critically reflect on your personal experiences and apply what you have learned in the module to your current practice. Justify and explain your responses with examples and thorough explanations.

Consider your current or past place of employment, and discuss the following:

a. The level of excellence at this institution is (select high or low); possibly because of the high/low level of trust the employees have of the administration. This level of trust of administration is illustrated by:

b. The level of excellence at this institution is (select high or low); possibly because of the high/low level of trust the administration has of the employees.

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

In this assignment, you will work to create a public health campaign that seeks to end a socially-determined health disparity. You will create a campaign to educate the public about the prevalence of this health problem within this population, its causes, the social conditions that contribute to this health disparity, and actions steps that we can take to reduce this health disparity. Your actions steps must discuss the social determinants of this health disparity. Your item will focus on reducing or ending the social determinants (substandard housing, toxic waste, low-wage jobs, income inequality, etc.) of your particular health disparity. Think about your audience as you create your material. Are you targeting the population affected by this disparity, or is your material directed at a general audience and the actions they can take to end this problem?

• Choose a healthy disparity from the list below to focus on: 
• Native American smoking rates
• Poor health status (physical, mental, emotional) among veterans
• Childhood obesity among U.S. Latinos
• Motor vehicle accident death rates in rural communities
• Traumatic brain injuries among people experiencing homelessness
• Depression in women
• Suicide rates among LGBT (lesbian, gay, bisexual, transgendered) adolescents
• Binge drinking among college students under the age of 24.
• Coronary Heart Disease (CHD) among African American adults 
• Or choose your own from the CDC Health Disparity Report: Fact Sheet CDC Health Disparities

1) Create a pamphlet. It needs to have the basic facts about your health disparity (its causes, rates, effects on the community, individual and socially determined causes). Your pamphlet should have solutions that discuss the social determinants of your health disparity. A typical pamphlet layout is a 2-sided (2 paged) tri-fold. You can access a pamphlet template using Publisher if you are on a PC (use the brochure template) or Word templates if you are using a Mac. Please submit a PDF version of what you create. Use bulleted points, charts, tables, or graphs. Pamphlets usually have photos, pictures, and graphics. If there is not room for your bibliography on your pamphlet, then please attach a separate sheet of bibliographic references.

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"