I’m trying to study for my MySQL course and I need some help to understand this question.

Assignment: Working With Database Indexes, Views, and Users

You can use database indexes to improve the performance of database operations. Database views allow you to define virtual tables containing exactly the data that you need for a specific situation. Standard SQL supports these techniques.

One of a DBA’s primary responsibilities is to create and manage database user accounts and to grant or revoke access privileges as needed. Users should be able to access or modify only those parts of the database that they need to perform their jobs.

You will use the Employee and Department tables you created previously. Create, run, and test SQL queries to display each set of information. Save a copy of your queries in a Microsoft Word document.

Include a screen shot to verify the successful completion of each SQL command. Each Screen shot must be preceded by a comment that includes the student’s name, the instructor’s name, and the date the command was executed.

E.g. SQL>/* Student: John Doe Instructor: Sally Smith Date: 4/4/2021 */

Note: Don’t forget the /* and */ at the start and end of the command to make it into a comment!!

The screen shot must include the SQL command and the output from the command. Include one screen shot per item. The screen shots must be well formatted and the output easily readable. Points may be subtracted from the total score for poor presentation of the assignment material.

See examples below:

Click on this link to load the Unit 5 Application assignment.

Prepare: Advanced SQL

In this unit, you will learn how to create and use indexes, views, triggers, functions, and procedures. You will also learn about the effects that indexes may have on database performance.

When you look for a book in a library, you do not have to search the building shelf by shelf. The library publishes and follows rules that assign each book a location. If you do not know which book you want, or if you cannot determine the location of a book from these rules, the library catalog indexes the library’s holdings by title, topic, and author. The catalog is a simple and fast way to locate books.

Database management systems (DBMSs) provide a similar index functionality. A database index locates a particular record in a database table by using its index key. A table can contain several indexes, but each index is associated with just one table. When properly designed, an index greatly improves the speed of queries for data from that table. Suppose, for example, the automobile parts store employees often searches for parts supplied by a particular vendor. That query can be more efficient if the parts table has an index for the vendor ID.

As a user of a database, you may find that you frequently perform the same or a similar query. For example, the parts store manager may search every day or week for parts to reorder. After typing (and mistyping!) the same query a few times, the manager may wish that the query could be stored and reused. This is exactly the purpose of a database view. You can think of a view as a dynamically created table whose content is specified by a SELECT query. A view can save time, improve accuracy, and make the system more accessible to nonexpert users.

Although the Structured Query Language (SQL) language is powerful, it has some weaknesses. Because it is specification-based, not procedural, SQL supports neither decisions, such as IF – THEN – ELSE, nor repetitions, such as DO WHILE. The SQL-99 standard defines persistent stored modules (PSM) to overcome these limitations. A PSM contains standard SQL commands and extensions that provide programming control structures for decision and repetition. You can name and store a PSM in the database and share it among users of the database. There are several types of PSMs: triggers, functions, and procedures.

A database trigger is an SQL procedure that the DBMS automatically executes every time a specified event, such as inserting a new record into a table, occurs. A function is a group of procedural SQL statements that executes and returns a value when a user calls it. A procedure is similar to a function except that it does not return a value. A procedure can contain SQL statements that modify the contents of the database.

By creating appropriate PSMs, the auto parts DBMS can automatically set a reorder flag for any part when its stock becomes low. Procedures and functions can package common but lengthy operations into one named operation.

Learning Outcomes

By the end of this unit, you will be able to:

• Assess the benefits and drawbacks of database indexes
• Assess the benefits of stored procedures and views
• Create Database views and indexes
• Manage users and permissions

I need help with a Management question. All explanations and answers will be used to help me learn.

For the Strategic Plan assignment, you will work throughout the course to create a market entry plan (entrepreneurial), a market expansion plan for an existing organization, or a mergers and acquisitions plan that seeks to increase your organization’s competitive advantage.

Complete Part 6 of the Strategic Plan assignment according to the directions in the Part 6: Critical Milestones section of the “Strategic Plan” resource.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion

It’s best to tackle this effort by months/years versus weeks and list your tasks to achieve.

I don’t understand this Law question and need help to study.

In Chapter 1 of the text you read about the Bailey v. Eminem defamation case where the court held Eminem’s lyrics were protected by the First Amendment. Read the article and view the video (the links are listed under Week 1 Additional Learning Resources Required and Week 1 Multimedia Required) to the Pahler v. Slayer case. Respond to the following questions:

• Did the Pahler court use the same reasoning as used in Bailey v. Eminem?
• Should the court’s decision in Pahler be different because a young girl was murdered?
• Recall the difference between a crime and a tort. Based on these two cases, analyze and discuss whether artists should be held liable for the actions of their fans.

I don’t know how to handle this Writing question and need guidance.

Online Database or Online Query-Based Report

Select a database from NCHS or complete a query using CDC WISQARS using the links below.

National Center for Health Statistics. (NCHS)

https://www.cdc.gov/nchs/

Injury Prevention and Control: Data and Statistics. (WISQARS)

https://www.cdc.gov/injury/wisqars/index.html

Select a specific health concern or injury using the population of your choice. Be sure not to limit your query so you have enough data to evaluate, and include a substantial time frame so you are able to identify trends.

Submit a 1,000 word report that provides an overview the database or query results. The report should consist of a demographic description of the chosen population including a review of noticeable trends in morbidity and/or mortality by race, gender, and geographic location where specified.

Based on the results and possible trends, present the implications for public health intervention or involvement.

In your report, include considerations of basic ethical and legal principles pertaining to the collection, maintenance, use, and dissemination of epidemiologic data.

Focus on privacy and security issues surrounding protected health information and how HIPAA protects the confidentiality of the patient.

Consider the ethical implications of whether public health organizations have too much latitude in the use and dissemination of epidemiologic data.

Use examples and evidence to support your report.

Prepare this assignment per the guidelines found in the APA.

An abstract is not required.

Provide In-Text Citations to support your document.

Research should be from only scholarly/academic peer-reviewed sources. (5 or more reviews…)

Sources from sites like Wikipedia is not acceptable.

The body of your document must have sub-headings not forgetting a conclusion.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

You are required to submit this assignment to Turnitin.

I need help with a Management question. All explanations and answers will be used to help me learn.

The CEO calls and is very nervous. It’s the week of the presentation, and she wants to be well prepared to present the plan to the Board of Directors of Venus Widgets. With the possible expansion of the company into foreign markets, it means that the company will be onboarding new and diverse people with different cultural backgrounds and value systems.

The CEO wants you to develop a plan to help address diversity and to provide a smooth transition to the possible overnight expansion of the organization’s workforce.

This week the CEO wants you to construct a diversity plan for the organization.

For your project, please include the following:

• What does having employees from different cultural backgrounds and value systems mean for the company?
• What would be the benefits of diversity for this company?
• What possible hurdles may be encountered with the inclusion of new, culturally different, employees?
• What will you do to ensure that the new work teams are able to work together effectively, while being inclusive and respecting each other’s differences?

Be specific, giving examples of different cultural backgrounds and value systems.

Your paper should be a minimum of 3 pages, using proper APA formatting and including at least 3 credible sources cited in your paper through in-text citations. Include an APA formatted title page and reference page. Your paper should also be free of grammatical errors.

Suggested library databases to research these topics include Business Source Complete via EBSCO and Business via ProQuest for articles, and Safari Business eBooks and eBooks via EBSCO for eBooks.
*A note about credible sources: Credible sources are reliable, accurate, and trustworthy. These sources are written by authors respected in their fields of study. You want to identify sources where the author of the article is listed, if they’ve referenced other information, the sources should be cited so that you can check for the accuracy of and support what they have written. Wikipedia is not considered a credible source.

Submit your completed assignment to the drop box below. Please check the Course Calendar for specific due dates.

Save your assignment as a Microsoft Word document. (Mac users, please remember to append the “.docx” extension to the filename.) The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below:

Need help with my Writing question – I’m studying for my class.

Prepare an initial post on a Christian character development and worldview perspective.

Please write this initial post with 300 – 400 word count with 3 scholarly reference and in text citation and biblical scriputral using APA format paper. Be sure to integrate analysis from a Christian worldview perspective

Read this article to prepare for this forum: Zigarelli, M. (2003). Become a hire authority: How to measure character in your applicants. Regent Business Review, Issue 3, Pg12- Pg16. Please see the attachment for the article.

I need an explanation for this Business question to help me study.

Im having a hard time with this class and I need help with this assignment. Use the case study in the resources section.

For this assignment, you will return to your role as an intern at Nutri Mondo, an organization that uses data science to address issues related to food insecurities and other food-related issues. Read the message from the director of Nutri Mondo, Susana Maciel, to set the context for your assignment this week:

SUBJECT: DATA UNDERSTANDING AND DATA PREPARATION

FROM: SUSANA.MACIEL@NUTRIMONDO.ORG
TO: YOU

Hello,

So, I just want you to know that the data science team is telling me you are doing great! I hope you feel the same way. I know data science gets pretty technical. But I promise you that this team not only loves what they do, they are great at explaining their processes if you don’t have all the technical skills they do…yet. ??

Now that you are up to speed with our project on food insecurity, you know that the next step of the data science methodology is Data Understanding and Data Preparation. The team will explain it a lot more, and there is some content from IBM that will go over the general details as well. And just so you know, I am as excited as you are to see how the data science team constructed their data set from the data they collected and how they are exploring and preparing the data—I haven’t seen it yet!

I am sure I will read all about it in your next reports.

Regards,

Susana Maciel
Director
Nutri Mondo

To prepare for this assignment, review this week’s Learning Resources. Then go the World of Data Science to visit São Paolo and Miami to view the Data Understanding and Data Preparation video.
For this assignment, write a report to your director at Nutri Mondo. In your report:

• Describe the steps taken by the data science team to construct the data set for the case study.
• Describe the initial patterns identified by the team and what these patterns might mean
• Describe how the data science team is exploring and preparing the data

Your report should be 5–8 paragraphs.

Resources:

https://mym.cdn.laureate-media.com/2dett4d/Walden/DSCI/2010/WorldOfDataScience/index.html#

https://www.ibm.com/developerworks/opensource/library/ba-cleanse-process-visualize-data-set-1/index.html?ca=drs-

I’m working on a Psychology question and need guidance to help me study.

Description:

This assignment will help you summarize and convey the key points about approaches to decision making and problem solving.

Objectives:

• Express how humans think and make decisions.
• Interpret creativity, divergent thinking, and common measurements of creativity.

Instructions:

Step 1: Identify a problem you would like to solve.

Think about the problems you are now encountering or may be encountering in the future. Consider problems about relationships, money, living arrangements, school, career, family, friends, or others. Document your problem by writing a paragraph about it.

Step 2: Research various approaches to problem solving.

Use the information in the textbook and perform research on the Internet or other resources to find multiple approaches for solving problems. Key search terms: analogy heuristic, backward search or working backward, means-end analysis, and algorithm. It is recommended that you conduct research through our Online Library (Links to an external site.) or use a scholarly internet search. Wikipedia is not allowed.

Step 3: Use three of the problem-solving approaches and apply each of them to your problem by creating a 3-4 page essay or 7-10 slide PowerPoint.

Document the step-by-step approach to problem solving for each of the 3 approaches you have chosen (cite any sources as necessary).

• Apply that approach to your problem, documenting the results.
• Describe which approach your found easiest to use and why.
• Did each step-by-step approach come to the same conclusion for the problem? Why or why not?
• Conclude the assignment with an assessment on how effective these problem solving techniques were (or will be) on the problem you identified.

Assignment Submission:

• The use of outside resources is strongly recommended, and all work must include citations and be written in current APA format.
• It is recommended that you conduct research through our Online Library (Links to an external site.) or use a scholarly internet search. Wikipedia is not allowed.

Need help with my Economics question – I’m studying for my class.

HB Corp., a UK company, has subsidiaries in the U.S., Germany, Singapore and Australia. It regularly sells goods denominated in U.S. dollars. The company will have two transactions in the near future:

Three months (90 days): Paying 400,000 Euros for imported goods

Six months (180 days): Receiving 600,000 USDs for exports

The following exchange rates and interest rates are available for the company:

Bid Quote Ask Quote

(bank buys) (bank sells)

Spot exchange rate (Euro per £1): 1.17 1.13

Three-month forward rate (Euro per £1): 1.10 1.05

Spot exchange rate (USD per £1): 1.217 1.188

Six-month forward rate (USD per £1): 1.202 1.178

Spot exchange rate (AUD per £1): 1.762 1.735

1-year forward rate (AUD per £1): 1.765 1.738

1 year (360 days) interest rates:
Borrow Deposit

USD 7.8% 4.0%

Pound 6.7% 2.4%

Euro 6.2% 3.2%

AUD 7.8% 5.2%

a) Suggest how HB Corp. could implement a money market hedge for payables, support your answer with detailed calculations. Would HB Corp. be better off using forward hedge or money market hedge? Substantiate your answer with estimated cost each type of hedge. (10 marks)

b) The company has recently received £800,000 and is considering invest in Australia to exploit the higher interest rate. What is the yield to the company if it conducts a covered interest arbitrage? Would covered interest arbitrage work for the company in this case? (Ignore transaction fees and tax effects.) (10 marks)

c) Based on the question above, discuss how the Australian dollar’s spot and forward rates will adjust until covered interest arbitrage is no longer feasible. Why are arbitrage opportunities diminishing quickly after they have been discovered? To illustrate your answer, assume that the immediate purchase and forward sale of Australian dollar is allowed. What is the resulting equilibrium state referred to? (8 marks)

I’m studying for my Psychology class and don’t understand how to answer this. Can you help me study?

This project asks you to assess the current state of your workplace environment in regard to how it motivates–or fails to motivate–employees to cause increased job satisfaction and workplace productivity.

Write a 1,750- to 2,100-word assessment focusing on a selected job or department in your company in regard to the related system of goal setting, performance evaluation, and workplace rewards that affect productivity and job satisfaction.

Address the following:

• Identify the position’s current major components, tasks, or responsibilities.
• Describe the different types of emotions humans experience, and analyze the biological and cognitive factors that affect emotion and their effects on worker productivity in this role.
• Assess whether the position cultivates a sense of intrinsic motivation.
• Briefly discuss current company-wide rewards, such as bonus plans, profit sharing, and one-to-one rewards such as praise or recognition, and how employees’ emotions affect their performance.

Cite at least 3 to 5 scholarly sources.

Format your paper according to APA guidelines.

At the moment I am a stay at home mom but previously I worked as a lead for a sanitation department for a warehouse.