Use SQL.
–Skeleton Candy Part 1 – extract from 2017, 2018, 2019 tables and put into stagingTable
–Students, see notes below where it says –you need to fill this in here
–Create the staging table
DROP TABLE IF EXISTS stagingTable;
CREATE TABLE stagingTable (
yearInt INT(4),
monthInt INT(2),
–there will be more you need to fill in here
);
–Insert 2017 Data
INSERT INTO stagingTable(“monthInt”, “state”, “country”, “region”, “Product_Name”, “unitPrice” –you need to fill this in here)
SELECT “Month”, “State”, “Country”, “Region”, “Product”, “Per-Unit_price”, “Quantity”, “Order_Total” FROM pd2017
;
UPDATE stagingTable SET yearInt=2017;
–Insert 2018 Data
INSERT INTO stagingTable( — you need to fill this in here –)
SELECT … FROM pd2018
;
UPDATE stagingTable SET yearInt=2018 WHERE yearInt ISNULL;
–Insert 2019 Data
INSERT INTO stagingTable(– you need to fill this in here –)
SELECT … FROM pd2019
;
UPDATE stagingTable ( — you need to fill this in here );
SELECT * FROM stagingTable;
That is the ·
Candy_part_1_skeleton_for_students.SQL
Author: admin
-
“Creating a Staging Table for Skeleton Candy Sales Data from 2017-2019 using SQL”
-
Title: “Exploring Key Aspects of the US Constitution: Supreme Court Nominations, Political Parties, the 14th Amendment, and Federalism”
I need 1.5 pages for each, double spaced. 1. If you were the President of the USA, who would you nominate for the Supreme Court and why?
2. What does the USA Constitution say about parties?
3. What is so important about the 14th Amendment?
4. Do you consider yourself a Federalist or an Anti-Federalist and why? -
Title: Applying Economic Concepts to Current Events: A News Article Analysis
Select an article from the news of the past week that illustrates one or two of the concepts that are discussed in chapters 1 and 2. In a paper of no more than two pages (double spaced, one inch margins, 12 point type) briefly summarize the article and discuss the underlying economic concept(s) of the article. remember to cite / reference page
-
Title: Exploring the Ethics of Physician-Assisted Suicide Introduction: Physician-assisted suicide, also known as assisted dying or euthanasia, is a highly debated and controversial topic in the field of medical ethics. It involves a physician providing
Every one of us has different values, beliefs, and thoughts that define who we are. Some topics are harder to discuss that others. From the list of topics, choose one that you want to learn about. • Choose an ethical topic from below and Compose a two-page paper
• Answer the four questions below. I suggest a small paragraph for each question • You must utilize 2 scholarly references and utilize APA formatting • You may choose your own ethical issue -
Title: A Letter from Hamlet to Ophelia Letter: To my dearest Ophelia, I hope this letter finds you well. It has been quite some time since we last spoke, and I must admit, I have missed
To Whom it May Concern:
Choose a character from any story we’ve read for Unit 1 and from their point of view, write a
letter to any of the other characters we’ve encountered in Unit 1 – you can choose another
character from the same story or choose another story altogether. The content of the letter is
entirely up to you, you can discuss an event that takes place in the story you’ve chosen,
real
world current events, or anything in between. However, using your interpretation of the text, you
will need to justify and explain every choice you make.
Requirements:
1. letter around 800 words
2. rational 800 words (around 800 words
Letter (around 800 word Rationale (around 800 words -
The Importance of Collaboration in Case Management: Understanding the Multifaceted Roles Involved Introduction Case management is a collaborative process that involves various roles and responsibilities to provide comprehensive care for individuals with complex needs. These roles include case managers, healthcare
Why do you think so many roles are involved in case management? Include specific examples to illustrate your response.
-
Title: Understanding the Scientific Method in Educational Research: An Outline and Explanation
The scientific method is the foundational approach for rigorous empirical investigation and needs to be thoroughly understood prior to embarking upon a choice of research methodology or the overall design of an educational research study. Different types of research across research methodologies (qualitative, quantitative, and mixed-methods) and across research paradigms (post-positivist, interpretivist/constructivist, transformative, and pragmatic) all require adherence to this method.
Your assignment should include an outline and a brief essay. For help with an outline, check out the link in this week’s resources.
Create an outline of the steps involved in conducting a research study (1-2 pages). This outline of the steps that codify the principles and conventions involved in conducting research should be an expanded list based on the four broad steps illustrated in Figure 2 in the week’s lesson.
Compose a short, explanatory essay explaining the role of the scientific method in conducting research (1 page).
Length: 1-2 page outline and 1-page essay uploaded as one Word document
References: Include a minimum of 3 scholarly resources that are cited within the text and referenced at the end of the document in APA style. -
Title: “The Impact of Neural Networks in Healthcare: Advantages, Limitations, and Future Developments”
PLEASE PROVIDE A TURNITIN REPORT.
===============================================================
INSTRUCTIONS:
===============================================================
In brief, this paper should be focused on a specific segment of AI – e.g. Machine
Learning, Neural Networks, Speech Recognition, Face Recognition, etc. — and their
advantages, disadvantages, usage, as well as impact on business or society, and
possible future developments/applications.
==============================================================
I want to select the Neural Networks with an example of its application in healthcare (maybe Medical Imaging sector).
I will provide some articles for references – I have compiled partial info that may interest this assignment in a word document with the APA format reference.
You can choose at least one article to include in the references and use some info from them. Otherwise, internet resources are fine as a source for this assigment. (SEE WORD DOC ATTACHMENT)
==============================================================
•
1) Briefly define the selected AI field/technology/AI-based information system,
2) describe its advantages, benefits, negatives or risks,
3) specify how it is used
today (if possible, please, try to find a real-world case study), and also
4) focus on possible trends and future developments.
• The paper should have approximately 6 pages of text (excluding the cover
page and references), and may be divided by titles / subtitles into four main
sections and even subsections.
• You should use at least 4 credible sources;
==============================================================
Example of the content STRUCTURE
1 Definition of Neural Networks
2 Pros and Cons
a. advantages
b. limitations
c. risks
3 Usage
a. healthcare
b. decision-making in business
c. specific example (based on case study|
4 Future developments and applications
==============================================================
PLEASE PROVIDE A TURNITIN REPORT. -
Title: The Impact of Capitalism on Society: A Synthesis and Counterargument In today’s society, capitalism plays a dominant role in shaping our economic and social structures. Karen Ho, in her article “Biographies of Hegemony,” and
Based on my rough draft, that I have written, synthesize all the quotes that I have written and add another 3rd body paragraph for a counter arguement. Use the format of a synthesis essay: First body paragraph is about the synthesis and connection of article 1 and 2 combined ( Karen Ho and Mario Ariza, the second body parragraph is a synthesis and connection of article 2 and 3 combined (Marrio Ariza and Navneet Alang), and the third body paragraph (which you have to add) is a counterarguement using Navneet Alang.
The prompt is provided below along with the three texts (Karen Ho, Mari Ariza, and Naveneet Alang), and my rrough draft that you will have to add on to. -
“IT Strategy for Rite Aid: Enhancing Organizational Effectiveness and Information Security”
This is a group project that unfortunately I did not have a partner to do it with. The project is to ” select any Fortune 500 business and after researching their various business model(s) develop an IT Strategy your team feels will carry them for the next 3-5 years.” In this case, the company is RITE AID. I only need help with the following portion of the project:
What is Rite Aid’s Organizational Effectiveness Plan, Information Security Framework, IS Governance Structures, Partnerships and Vendor Management Strategies, Resource allocation and Planning.
Please let me know if you need further details. Thank you so much for your help!