Perform the following steps in MySQL: Create the tables and relationships from the database design discussed in Lab 2.  Add at least five (5) records into each table (Note: You must determine the field values). 

Lab 4: Structured Query Language (SQL)

Due Week 7 and worth 75 points

Refer to the database design crested in Lab 2: Modifying a Database Design in Visio to complete this Lab.

Perform the following steps in MySQL:

  1. Create the tables and relationships from the database design discussed in Lab 2.
  2. Add at least five (5) records into each table (Note: You must determine the field values).
  3. Create a query with all fields from the student table, where the student’s last name is “Smith”.
  4. Create a query that includes students’ first names, last names, and phone numbers.
  5. Create a query that includes instructors’ first names, last names, and courses they teach.

Include the following screen shots in a Microsoft Word document to show the completion of the steps above:

  • Screen shot depicting the tables created within MySQL.
  • Screen shots depicting the records added into each table.
  • Screen shots depicting the SQL code and the query results from each of the queries created.

Your assignment must follow these formatting requirements:

  • Submit the lab as a Microsoft Word document.
  • Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page is not included in the required assignment page length.

Submit a PowerPoint presentation (approximately 10 slides) providing your analysis and research findings on the topics indicated. You are expected to include statistical data when possible, including tables, graphs, and other visuals that support and enhance your study. Most importantly, all written assignments and responses should follow APA rules for attributing sources! 

In this assignment, you will research information related to the marketing and promotion of the acquisition by EDUS and provide an assessment. Click here to review the EDUS case and consider the following:

Topics for Research and Analysis

Promotional Goals: Identify specific objectives related to the promotion of EDUS’s acquisition of the institution. In addition, identify specific objectives related to informing potential students of new capabilities and offerings resulting from the acquisition. (Promotional goals vary. Some organizations need to create awareness of their product’s benefits compared to competitors. Other promotional goals may involve communicating new uses for an item, or informing customers or lower prices.)

Business Environment: Identify cultural and legal factors that might influence promotional decisions – both in announcing the acquisition within the region and recruiting new students to the institution. (In some countries, certain information is required in television commercials selling products aimed at children.)

Media Plan: Analyze media availability to determine cost-efficient methods of communicating with potential students within the country and within the geographic region. (While television, radio, newspapers, magazines, and the Internet may be common in industrialized countries, developing economies may require other different media. In some countries, advertising messages are broadcast through large speakers mounted on moving trucks.)

Promotional Strategy: Compare the benefits of push-and-pull promotions for acquiring new students at the institution. Devise a promotional strategy that will help EDUS expand the student body and also inform potential students of increased capability of the institution resulting from this acquisition.

Economic, Cultural, and Political-Legal Environment: Investigate the economic, cultural, and political-legal environment that might affect promotional messages and media relevant to this acquisition.

Recommended Actions: Recommend EDUS actions related to promotional goals, needed adaptations due to cultural or legal factors, and a media plan. Provide evidence to support your recommendations.

Conclusions: Draw conclusions about the material you have presented. The opinions or judgments you present should be supported by your research.

 

Submit a PowerPoint presentation (approximately 10 slides) providing your analysis and research findings on the topics indicated. You are expected to include statistical data when possible, including tables, graphs, and other visuals that support and enhance your study. Most importantly, all written assignments and responses should follow APA rules for attributing sources!

This week, you will select an article to review for your final assignment in the course, the Article Review, which is due in Week Six. Each article represents a topic and area of psychology. See the attached PSY600 Article Review List to read the articles and make your choice.

Choosing an Article for the Article Review Final Paper
This week, you will select an article to review for your final assignment in the course, the Article Review, which is due in Week Six. Each article represents a topic and area of psychology. See the attached PSY600 Article Review List to read the articles and make your choice.

In your paper, clearly identify your article selection. Analyze psychology as a science as it is presented in your chosen article and explain why you have decided to focus on this particular topic. Assess the professional roles presented in the chosen article and describe the interactions between psychology professionals and professionals in other fields, if any. Explain any psychological theoretical perspectives presented in the article and why they are of particular interest to you.

The Paper:

Must be one to two double-spaced pages in length (excluding title and reference pages) and formatted according to APA style as outlined in the Ashford Writing Center.
Must include a title page with the following:
Title of paper
Student’s name
Course name and number
Instructor’s name
Date submitted
Must address the topic with critical thought.
Must use at least one peer-reviewed source chosen from the PSY600 Article Review List .
Must document all sources in APA style as outlined in the Ashford Writing Center.
Must include a separate reference page that is formatted according to APA style as outlined in the Ashford Writing Center.

Carefully review the Grading Rubric for the criteria that will be used to evaluate your assignment.

Prior to beginning work on this discussion, read the required chapters from the Harré (2006) Key Thinkers in Psychology e-book. Examine one of the schools of thought (psychoanalysis, behaviorism, etc.) presented in the reading that is significant in the evolution of modern psychology.

Past to Present

Prior to beginning work on this discussion, read the required chapters from the Harré (2006) Key Thinkers in Psychology e-book. Examine one of the schools of thought (psychoanalysis, behaviorism, etc.) presented in the reading that is significant in the evolution of modern psychology. Select one theorist associated with this school of thought and explain the specific theoretical perspective(s) and/or contribution(s) this individual made to the field of psychology. Evaluating the impact of the theory and/or contribution(s) to the field as a whole, identify the strengths and weaknesses of your theorist’s contribution(s).

Choose one contemporary issue or problem that is prevalent in today’s news and research a minimum of one peer-reviewed article on this issue in the Ashford University Library. Evaluate the issue from your chosen school of thought and your theorist’s perspective. Explain how the theory provides a deeper understanding of and insight into the conditions and behaviors related to the contemporary issue. Evaluate contemporary applications of psychological theory to the issue. Support your evaluation of the news piece with your peer-reviewed research on the topic.

Select two complaints presented in the Grenyer & Lewis article (see Table 1) and explain the ramifications of these violations applying the APA’s Ethical Principles of Psychologists and Code of Conduct to each situation. Assess the role of the APA in assisting psychology professionals in the identification of potential areas of misconduct. Describe and recommend a course of action to avoid these areas.

Ethical Pitfalls for Psychology Professionals

Prior to beginning work on this discussion, read the Grenyer & Lewis (2012) “Prevalence, Prediction, and Prevention of Psychologist Misconduct” article and the APA Practice Central’s Professional Health and Well-being for Psychologists , Tips from Practitioners on Finding Work-Life Balance , and Tips for Self-Care online articles.
Select two complaints presented in the Grenyer & Lewis article (see Table 1) and explain the ramifications of these violations applying the APA’s Ethical Principles of Psychologists and Code of Conduct to each situation. Assess the role of the APA in assisting psychology professionals in the identification of potential areas of misconduct. Describe and recommend a course of action to avoid these areas. Evaluate the contemporary role of psychology professionals and elaborate on the relationship between self-care and the issue of maintaining ethical principles and professional standards. Identify one or two self-care tips, tools, or suggested courses of action provided on the APA’s Self-care resources for psychologists website that might address the issues which lead to the chosen complaints.

Review the complete rules and regulations for your state and pay special attention to the sections concerning rules for working with minors. Then, conduct an Internet search for information on consent and confidentiality for mental health treatment for minors in your state of residence. In the discussion, you will address the following case study:

Rules and Regulations Governing Psychology Professionals

Prior to beginning work on this discussion, read the required Boldt (2012) article.
A psychology professional must be knowledgeable of the rules and regulations that govern the profession in his or her state of residence. For this discussion, access your state board of psychology’s website. Conducting an Internet search for your state’s name and “State Board of Professional Psychology” will likely produce the link to the website (i.e., California State Board of Professional Psychology). Once on the website, look for the state’s rules and regulations governing professional psychology. These are often listed as links or tabs with titles such as “Laws and Regulations”, “Rules and Regulations”, “Laws, Policies, and Rules”, “Statutes and Rules”, “Statutes and Administrative Codes”, etc. Review the complete rules and regulations for your state and pay special attention to the sections concerning rules for working with minors. Then, conduct an Internet search for information on consent and confidentiality for mental health treatment for minors in your state of residence. In the discussion, you will address the following case study:
You are a counselor. Twelve-year-old Billy is using drugs without his parents’ knowledge and has come to see you for help. Billy wants outpatient treatment for his substance abuse and informs you that his parents do not know about his drug use. He refuses to permit you to share information with his parents. While a person under the age of 18 is often considered a minor and generally most states would require them to obtain consent from a parent or guardian prior to receiving mental health treatment, there are several exceptions to this general rule.
In your initial post, analyze your state’s rules and regulations governing psychology as a profession as well as your state information on consent and confidentiality with regard to minors. Apply these regulations to Billy’s case. Elaborate on how you would approach the case by providing information on your state’s consent and confidentiality laws and assessing any impact these may have on your options for Billy’s treatment. Apply any relevant ethical principles and professional standards of psychology as they relate to this complex situation. Evaluate any personal beliefs that may conflict with legal requirements you have as a counselor within your state. Detail what actions you would take to be true to both yourself and the professional requirements.

In your initial post, analyze your state’s rules and regulations governing psychology as a profession as well as your state information on consent and confidentiality with regard to minors. Apply these regulations to Billy’s case.

Rules and Regulations Governing Psychology Professionals

Prior to beginning work on this discussion, read the required Boldt (2012) article.
A psychology professional must be knowledgeable of the rules and regulations that govern the profession in his or her state of residence. For this discussion, access your state board of psychology’s website. Conducting an Internet search for your state’s name and “State Board of Professional Psychology” will likely produce the link to the website (i.e., California State Board of Professional Psychology). Once on the website, look for the state’s rules and regulations governing professional psychology. These are often listed as links or tabs with titles such as “Laws and Regulations”, “Rules and Regulations”, “Laws, Policies, and Rules”, “Statutes and Rules”, “Statutes and Administrative Codes”, etc. Review the complete rules and regulations for your state and pay special attention to the sections concerning rules for working with minors. Then, conduct an Internet search for information on consent and confidentiality for mental health treatment for minors in your state of residence. In the discussion, you will address the following case study:
You are a counselor. Twelve-year-old Billy is using drugs without his parents’ knowledge and has come to see you for help. Billy wants outpatient treatment for his substance abuse and informs you that his parents do not know about his drug use. He refuses to permit you to share information with his parents. While a person under the age of 18 is often considered a minor and generally most states would require them to obtain consent from a parent or guardian prior to receiving mental health treatment, there are several exceptions to this general rule.
In your initial post, analyze your state’s rules and regulations governing psychology as a profession as well as your state information on consent and confidentiality with regard to minors. Apply these regulations to Billy’s case. Elaborate on how you would approach the case by providing information on your state’s consent and confidentiality laws and assessing any impact these may have on your options for Billy’s treatment. Apply any relevant ethical principles and professional standards of psychology as they relate to this complex situation. Evaluate any personal beliefs that may conflict with legal requirements you have as a counselor within your state. Detail what actions you would take to be true to both yourself and the professional requirements.

Briefly elaborate on the information provided on the job you searched, and be sure to include educational requirements, duties, future outlook, and salaries related to the position.

Exploring the Influence of the APA Within the Psychology Profession

Prior to beginning work on this discussion, read the Schantz (2014) “A Young Scholar’s Guide to Building a Professional Network” article, review the Divisions listed on the APA website paying special attention to the divisions that may interest you, and review the O*Net Online website.
In your initial post, identify one division related to your career interest that you would consider joining and one specific job related to that division. Conduct a search on your chosen job using O*Net Online. Briefly elaborate on the information provided on the job you searched, and be sure to include educational requirements, duties, future outlook, and salaries related to the position. Use the Internet to search for and compile information about the leading employer prospects for this position in your geographical area. Compare and contrast the compiled information with that from O* Net. Include expected duties, number of job offerings found, educational requirements, job experience, and salary levels where applicable. Analyze psychology as a profession and assess the role the APA could play in aiding you in the development of a professional network. Briefly detail an initial plan for building your professional network as well as obtaining your selected job.

What changes can the company/brand expect in the future? How can the company/brand better serve its customers? Include information about potential opportunities and threats.

In this assignment, you will create a Situation Analysis for one (1) of the following companies / brands: Fiat Chrysler, Amazon.com, or Google.

Each of these three (3) companies (Fiat Chrysler, Amazon.com, and Google) has been through numerous changes in recent years. For this assignment, select only one (1) company / brand. Use the information listed, as well as your own knowledge and research, to complete the provided situation analysis template. Additional research should include the use of the company’s Website, the course textbook, and other online sources.

*Remember to only select one (1) brand from the options

TEMPLATE 

Based on what you’ve learned so far in this course, regarding the 5 Cs, 4Ps, and STP, complete the assessment questions below. Submit the completed template in the Week 10 assignment submission link.

 

Name:

Professor’s Name:

Course Title:

Date:

Company/Brand Selected (Fiat Chrysler Automobiles, Amazon, or Google):

 

1. Customers

Who are the current customers/users? Include information related to demographics, psychographics and buying behavior, price sensitivity, customer satisfaction and loyalty.

For example: You could include information such as whether the brand is trying to appeal to a certain social or cultural group and how customers perceive the product/brand. It’s also possible to include demographic information related to: age, educational attainment, geographic area, gender, race, employment status and/or home ownership. Additionally, you can discuss psychographic information which includes those attributes that relate to personality, values, attitudes, interests, or lifestyles of people. This area is also related to situational life stages as well as customer beliefs, and how customers want to see themselves and be perceived. Some examples of psychographic groups include video gamers, soccer moms, sports fanatics, hipsters, and single moms. Life cycle stages include: retirees, new homeowners, college students and new parents. Be aware that some products/brands may appeal to a wider customer base than others.

[Insert response]

 

What do the customers buy/use?

[Insert response]

 

What changes can the company/brand expect in the future? How can the company/brand better serve its customers? Include information about potential opportunities and threats.

For example, you could include information about the current demand for the product/brand, and how it is changing or has changed including possible variations or modifications in the future. You may also determine/discuss if the brand/company can take advantage or has taken advantage of the changes. It’s also possible to consider and talk about whether the product/brand is a less expensive substitute, perhaps, or maybe a product/brand that is easier to use with more features.

[Insert response]

 

 

2. Company

[This is what the brand is currently.]

Identify strengths and weaknesses of the company/brand as it exists today. What does the company/brand do well and not so well at this very moment?

[Insert response]

 

[This is what the company/brand needs to become.]

How can the company/brand improve its weaknesses and maintain or grow its strengths? Suggest how the company/brand can improve upon the things it does well and not so well.

[Insert response]

 

3. Context

Define the current business environment. Include information about political, legal, economic technological and societal factors that may influence sales.

For example: You could perhaps discuss the current trends and conditions for this Industry and for the brand. It’s possible to include information about how the Economy affects this industry. This could include changes in income: are people losing jobs, or getting paid more?  Changes in spending habits could be considered as well. Other factors such as use of public transportation and shopping online may also be relevant. Whether or not the product is high-tech, or state-of-the-art can be also be included in describing the context. For example, are there other companies producing new versions of the product? Is the market changing quickly? How is technology affecting this product or service? Are there any new laws that may affect the brand?

[Insert response]

 

4. Collaborators

Define the business partnerships. Does the company/brand have any current partnerships? What other company/brand may be a good partner for them?

[Insert response]

5. Competitors

Who are the main competitors?

[Insert response]

 

6. Recommendations

Based upon the analysis you just completed in this worksheet, what are three (3) key recommendations that you could pass along to Management regarding the future direction of the company you selected?

1. [Insert response]

2. [Insert response]

 

3. [Insert response]