Blue Ocean methodology

This assignment aligns with the following objective:

Apply the tools of Blue Ocean to foster disruptive thinking

Companies you can choose from are Pandora, eBay, Doordash, Yelp and P&G (formerly Procter & Gamble).

Please submit 2 pages with your findings, recommendations, and supporting information and analysis including a visual strategy canvas for your selected company.

You will be assessed on the basis of your command of the Blue Ocean methodology, specifically:

1.Ability to formulate the dimensions of a Strategy Canvas for existing competition
2.Creativity in defining new blue ocean attributes for Strategy Canvas
3.Preliminary application of eliminate-reduce-raise-create framework to shape Blue Ocean strategy

Attached Blue ocean meterial for you

Database Management SQL

1. (13 points) Clean and normalize the data. Submit your processed Excel file with a sheet for each relation/table. You do not need to submit screenshots of the Excel data.
a. The raw data contains a multivalued field (Country) that must be resolved before loading the data into APEX
b. The raw data contains a composite field (Laureate) that must be resolved before loading the data into APEX. Hint: Every laureate has a first name. Title, middle name, and last name are optional.
c. Break up the raw data into 3 tables. LAUREATE records information about each woman who has won a Nobel Prize, including ID, name (title, first, middle, last), birthdate, and death date. COUNTRY tracks the ID and country for each laureate. AWARD contains information about the award itself (year, recipient ID, category, reasoning, and whether the prize is shared). Assume that the same person cannot receive multiple prizes in the same year.
2. (23.5 points) Import the data into APEX.
a. Write a CREATE TABLE SQL statement for each table. Select appropriate data
types, sizes, and constraints for each field. Dont forget to add primary and foreign key constraints. Provide screenshots of your SQL statements in your Word/PDF file. Note: Do not use the Table Design wizard or Data Workshop to generate the CREATE TABLE code.
b. Use the Data Workshop to move your data into APEX. You can use the copy and paste or file upload method. Provide screenshots of the first few rows of your populated tables from the Object Browser.
3. (13.5 points) Use the database youve created to answer the following questions with simple queries (each query uses data from only one table). Provide screenshots of your SQL code and results tables in your Word/PDF file.
a. Which countries have had the most female winners? For the top six countries with the most female laureates, return the country name and total winners. Make sure to rename any new, calculated fields.
b. Many Nobel Prize winners have advanced degrees and titles like Doctor or Professor, but which winners do not have any titles? Return their IDs, full names (formatted as one field), and birthdates. Make sure to rename any new, calculated fields.
c. Some Nobel Prizes are awarded to individuals, and some may be shared among multiple people. For all instances where a woman won the prize individually in a category other than Literature or Peace, return the year, category, and reasoning for the award.

HW 4.1 Concepts

Using the book and reference of the course, the Virtual Library, E-Lab, and other academic resources, find information on:

1.Conception
2.Pregnancy
3.Infertility, Abortion
4.Infancy
5.Childhood
6.Self-esteem
7.Intellectual disability
8.Learning process
9.Family systems
10.Child abuse.

Prepare an OUTLINE with your most important findings about each concept.

References needed

Case Study – Southwood School

Format
All papers must be completed in APA format.  This assignment should be between 3 pages in length (the cover page and reference page do not count towards this minimum), and must be typed using Times New Roman 12-point font, double-spaced, and with one-inch margins. Papers should also be spell-checked and grammar-checked.
An abstract is not required, and will not count towards the 3-5 page length requirement if included.  Do not copy and paste the discussion questions into the paper; if the questions are included, they will not count towards the page requirement minimum.

Research
In addition to the case study itself, utilize a minimum of three sources, which can also include the PowerPoint attached, in order to complete this assignment.  These sources must be credible and scholarly (i.e., no blog posts or use of Wikipedia).  Industry organizations such as SHRM, as well as publications such as the Harvard Business Review and other peer-reviewed journals, are all good examples of credible sources. Remember to use parenthetical in-text citations in APA format throughout your paper to indicate the source of your information.

Requirements
Your report for the case study must include the following sections:
**Cover page
**Overview Briefly summarize the case scenario (one or two paragraphs)
**Discussion questions Answer the discussion questions listed below
    1. Would it be appropriate for Southwood to use e-learning to deliver the performance management training? If not, what delivery method(s) would you recommend? Explain your answer.
    2. There were several options available when deciding who would design and deliver the program. Ultimately, Southwood decided the HR manager would be responsible. Discuss the advantages and disadvantages of the training sessions being led by an external consultant instead.
    3. What are the potential challenges the HR manager might experience in delivering successful training sessions for managers (appraisers) and employees (appraisees)? Outline how those challenges might be overcome.
    4. How can the HR manager ensure skills transfer so managers and employees apply the training to the workplace? Provide specific examples.
    5. How would you recommend Southwood evaluate the success of the training program (not including the end-of-session feedback forms)? Provide specific examples.
**Debriefing Reflecting your thoughts and opinions based on the case
**Reference page