1. Your task is to create the SQL that will build a

1. Your task is to create the SQL that will build a. 1. Your task is to create the SQL that will build a.

1. Your task is to create the SQL that will build a set of database objects and columns that matches the Final Project Data File. You will provide the SQL to do the following:

a. CREATE each object – note the following:

i. You should have all columns provided in the spreadsheet

ii. Use whatever column names you choose (except for column1, column2, etc.). Some names have been provided for clarity of the data but you may use your own.

iii. Build relationships where necessary

iv. You may need to create surrogate keys

v. You should eliminate redundant data (don’t store the customer name multiple times)

b. INSERT the data provided in the Final Project Data File spreadsheet into your database

2. Write the DML SQL queries to provide the following answers

a. Show all suppliers where they are missing a fax number

b. Show all products where they are missing a fax number of the supplier and the Retail Price of the product is over $40.00

c. Show all orders that total over $4,000. Be sure to include Order Number, Customer First and Last Name, Order Date, Product Ordered, Quantity, and how much they paid for the product

d. Show the customers first and last name that have at least $1000 in total orders and live in France

3. You should make sure your SQL runs because you will only be submitting the SQL and your grade will be dependent on whether the SQL functions as requested.

4. Be sure to submit ONE .SQL or .TXT file (do not submit a .pdf or .doc file)[supanova_question]

Consider Captain Jonsen as the tragic hero

Consider Captain Jonsen as the tragic hero.

Description

Begin your essay with an evocative hook. Mention the author and title of the work somewhere in your introductory paragraph, AFTER your hook but BEFORE you mention characters. an original title that provides insight into your essay, an engaging hook that makes me want to read your essay FIRST, an arguable thesis, topic sentences that support it, textual evidence, including direct quotations, to support your topic sentences, and analysis rather than a summary. Avoid “if” statements like “If Jonsen had only…, then he…” Instead, discuss and analyze what actually happens. You can focus on motivations and consequences (intended and unintended).

Prompt: Consider Captain Jonsen as the tragic hero of this novel. In many ways, he certainly bears a resemblance to a tragic hero. This is Aristotle’s definition of a tragic hero, as put forth in his Poetics: “…the character…of a man who is not eminently good and just, yet whose misfortune is brought about not by vice or depravity, but by some error or frailty…” Keeping this in mind, consider the “nails” in Captain Jonsen’s “coffin”—i.e., his errors or tragic missteps or frailties. Then trace a path for your reader, identifying the three most damning choices Captain Jonsen makes that lead to his ultimate destiny. Your thesis will be a thoughtful evaluation of Captain Jonsen and the role he plays in his own downfall (it will be more than a simple statement like “Captain Jonsen is responsible for his own fate”). Incorporate direct quotations as evidence and analyze each observation you make as well as each direct quotation you use. Admonition: Remember NOT to retell the story. Instead, use direct quotations from the text as a springboard for your own analysis (refer to your list of analytical terms). Your essay should be AT LEAST 70% your analysis with no more than 30% direct quotations in service to your analysis

https://anyessayhelp.com/

[supanova_question]

Compare and contrast financial and managerial accounting

1. Your task is to create the SQL that will build a Writing Essay Help Compare and contrast financial and managerial accounting.

Description

Write a 750 – 1250 word paper on the following topic: Compare and contrast financial and managerial accounting. Provide one specific, real-life example (i.e. what specific person in what specific company saw what specific accounting information and used it in what way to make what specific decision?) of how either financial accounting helps external stakeholders make informed decisions or how managerial accounting helps managers to improve operational and financial performance. Paper must be formatted according to APA 6th edition guidelines, and you need to use at least three external sources. Do not use the following sources: Hermanson, R. H., Edwards, J. D., & Maher, M. W. (2013). Accounting principles: A business perspective, financial accounting (chapters 1—8). (8th ed.). Textbook Equity, Inc. Hermanson, R. H., Edwards, J. D., & Maher, M. W. (2013). Accounting principles: A business perspective, financial accounting (chapters 9—18). (8th ed.). Textbook Equity, Inc. 

https://anyessayhelp.com/

[supanova_question]

Roles of the courtroom work group.

Roles of the courtroom work group..

Description

Write a 700- to 1,050-word paper describing and evaluating the roles of the courtroom work group. Answer the following questions in your paper: What is a courtroom work group? How does this courtroom work group interact on a daily basis? What changes to the courtroom work group would you recommend? What is the role of the prosecutor? How does a prosecutor determine which cases to pursue? What would happen if the criteria for taking a case were more or less stringent? How is sentencing determined? What are the different forms of punishments? What are the effects of the criminal justice funnel and the backlog of cases on the court system and the courtroom work group? What are some solutions to help eliminate the funnel and reduce the backlog of cases? Provide examples. 

https://anyessayhelp.com/

[supanova_question]

Policy and practice in the education of bilingual children

Policy and practice in the education of bilingual children.

Description

Policy and practice in the education of bilingual children

You are required to write an essay discussing the teaching of bilingual children you have observed in a school setting. Your essay will include a description and analysis of the educational context. The practice you observed will be related to the analysis of the specific needs of bilingual pupils and recommended teaching strategies identified in a selected policy document, and will be analyzed critically in relation to theories and recent research evidence. (Classroom observation notes is included below) The aim of the essay is to Link relevant theoretical content (will be provided) with the appropriate/relevant elements of the classroom observation data. Explain the Lucas and Villegas in one paragraph and use the Lucas and Villegas structure through the essay. (Lucas and Villegas content will be attached). Use the DFE policy (PDF File will be included as an attachment). Must demonstrate this policy and embed it throughout the essay. Mention recommended teaching strategies with the DFE policy document. Learning outcomes that need to be addressed: -Critically evaluate a range of recommended teaching strategies for linguistically and culturally diverse classrooms with reference to theory and research evidence. -Identify and analyse the contribution of government policy to the development of pedagogy and practice in linguistically and culturally diverse mainstream classrooms.

https://anyessayhelp.com/

[supanova_question]

1. Your task is to create the SQL that will build a

1. Your task is to create the SQL that will build a