Database Management

Mercy, for the last assignment, you did not identify the primary and secondary key

Also, can you please auto generate the table of content

Key Assignment Draft

You have been asked to develop a database system plan for a local company (or a company of your choosing) that wants to track its customers/clients, appointments, billing, and employees. Structured query language (SQL) is used to create the database schema, maintain the database records, and perform administrative tasks. In addition to the Database System Plan template that includes section headings (project outline), submit a SQL Statements document of 4–5 pages based on the entity relationship (ER) model completed in Week 3. Complete the following:

  • Include SQL statements that use data definition language (DDL) commands to create the database schema specified in the ER diagram created in Week 3.
    • Include indexes, constraints, and relationships.
  • Include SQL statements that use data manipulation language (DML) to do the following:
    • INSERT 15 records into each table.
    • UPDATE 5 sets of records in each table using one specific criteria per update statement (e.g., EXACT MATCH, LIKE, BETWEEN, IN, or HAVING).
    • DELETE 2 records from 1 table based on specific criteria (e.g., EXACT MATCH or LIKE).
  • Create stored procedures to support retrieval of the data from the database, using SELECT statements to accomplish the following:
    • Aggregate (group) functions (count, avg, min, max, sum)
      • Write 4 queries using group functions.
    • Group By
      • Write 2 queries using the Group By, Having, and Order By syntax.
    • Simple queries
      • Write 4 queries that manipulate data in 1 table.
    • Join queries
      • Write 4 queries that join 2 or more tables.
  • Add this section to the SQL Statements section of your database system plan.
  • Name the document as follows:
    • yourname_IT600__IP4.doc
  • All sources should be cited both in-text and in the References section by using APA format.
  • Submit the document for grading

Capstone Project Week 4

W4 Assignment: Capstone Project

Instructions

You will be guiding your work to completion, which is consistent with an independent study format.

You will not be directed to submit a given number of sections for grading each week as you delve through the deliverables, but you are required to submit the entire document each week for grading by Tuesday at 11:59 EST. Ensure that you:

  • Indicate to your instructor that you have implemented the necessary corrections based on the prior week’s feedback, and
  • Show what section is new material, either by color-coding the work or by typing the details in the comment section.
  • Complete the Workplace for week 4.

Literature review paper

Literature Review Paper

Students will submit an 8 – 10 page (not including the cover or References pages) length paper summarizing 6 – 8 evidence based (meaning reports of findings arising from experimental research conducted by the article author[s] and not opinion articles or publications summarizing multiple research studies), peer-reviewed articles retrieved from the APUS online library. These summaries must not be merely one summary after another with no meaningful connections between them, but rather the paper should integrate and demonstrate clearly how the summaries are logically related to one another in a coherent and well-articulated literature review. The paper will end with a minimum of two paragraphs summarizing points made and articulating suggestions for future research directions arising from the article reviews.

This assignment submission will be evaluated based on:

  • The degree to which the article summaries are truly integrated and logically related; arbitrary statements of “This is related to that” without supporting evidence of an actual connection will result in a significant point deduction
  • Evidence of academically mature insight and use critical thinking skills in analyzing and relating the articles to each other and making suggestions for future research directions.

I need help with a discussion

Research Design

To prepare for this discussion assignment, read the information about Post-traumatic stress disorder (Links to an external site.)Links to an external site. (PTSD) at the National Institute of Mental Health website (http://www.nimh.nih.gov/health/topics/post-traumatic-stress-disorder-ptsd/index.shtml). Develop a research question on an aspect of PTSD. Make sure it is phrased as a researchable question. For example, questions containing the word “should” call for a value judgment and thus are generally not researchable.

In your post, present preliminary plans for a research study to investigate your question. You may use the supplemental PSY326 2016 Research Design Template to help you organize the required information. PowerPoint or any other presentation software may be used to create a visual presentation of your research design. Audio content is optional. The file for the presentation should be attached to your post, or if using a screencast, include a link to the online presentation. Regardless of the form of your presentation, your discussion post must include the following elements:

  • Compare and contrast the characteristics of non-experimental (descriptive and correlational) and experimental research designs.
  • State your research question, and specify whether the aim of the proposed research is to describe, predict, or explain.
  • Choose a research design to investigate your research question. Explain why this design is appropriate for the study.
  • Provide a brief overview of the study you would design.

Your post and presentation must utilize at least two peer-reviewed sources, in addition to your textbook, cited in APA format as outlined in the Ashford Writing Center. It is highly recommended that you visit the Research Methods research guide in the Ashford Library to find peer-reviewed journal articles about research methods. All sources used for the post must be cited within the body of the post and included in the list of references at the end.

Annotated Bibliography ENG 1102

Assignment

Submit a 750-1000 word annotated bibliography of the selected sources you will use to write Essay #6 (your annotated bibliography will include a short story and a poem from the Backpack Literature textbook and four essays and/or articles from the TROY Library databases). List your SIX sources in alphabetical order, according to author’s last name. Include all information required by the MLA style for each citation. You can find this in your Writers Reference textbook or online at https://owl.english.purdue.edu/owl/resource/747/01…

Definition

A bibliography is usually thought of as an alphabetical listing of books at the end of a written work (essay or article, book, book chapter, etc.), to which the author referred during the research and writing process. In addition to books and articles, bibliographies can include sources such as reviews, reports, interviews, or even non-print resources like Web sites, video or audio recordings. Because they may include such varied resources, bibliographies are also referred to as “Works Cited” or “Works Consulted” (the latter can include those titles that merely contributed to research, but were not specifically cited in text). The standard bibliography details the citation information of the consulted sources: author(s), title, date of publication, and publisher’s name and location (and for articles: journal title, volume, issue, and page numbers). The primary function of bibliographic citations is to assist the reader in finding the sources used in the writing of a work.

To these basic citations, the annotated bibliography adds descriptive and evaluative comments (i.e., an annotation), assessing the nature and value of the cited works. The addition of commentary provides the future reader or researcher essential critical information and a foundation for further research. Composing an annotated bibliography in the draft stage of a project also helps a writer identify and assess the sources s/he is working with. Be sure to include a statement detailing how the source is useful to your research and how the source will be used in your completed essay.

Composition

While an annotation can be as short as one sentence, the average entry in an annotated bibliography consists of a work’s citation information followed by a short paragraph, roughly 100-150 words in length, which should include brief and selective direct quotes. The annotated bibliography is compiled by:

  • Considering scope: For this assignment, you are required to include the six sources you are using to write Essay #6, which includes primary sources — a short story and a poem, and four secondary sources — the essays/articles you research in the TROY Library databases.
  • Devising a research strategy, conducting a search for the sources, and retrieving them.
  • Evaluating retrieved sources by reading them and noting your findings and impressions
  • Once a final group of sources has been selected, give the full citation data (according to MLA bibliographic style; see your Writer’s Reference textbook) and write an annotation for each source; do not list a source more than once

Annotations begin on the line following the citation data and may be composed with complete sentences or as verb phrases (the cited work being understood as the subject). The annotation should include most, if not all, of the following:

  • Identify the author’s thesis
  • Brief description of the work’s format and content
  • Theoretical basis and currency of the author’s argument or subject/theme
  • Value and significance of the work as a contribution to the subject under consideration
  • Possible shortcomings or bias in the work
  • Any significant special features of the work (e.g., glossary, appendices, particularly good index)
  • Your own brief impression of the work
  • How the source is valuable to your research and how it will be used in your completed essay

Purpose

Not to be confused with the abstract—which merely gives a summary of the main points of a work—the annotated bibliography always describes and evaluates those points.

Example (MLA format)

Waite, Linda J., Frances Kobrin Goldscheider, and Christina Witsberger. “Nonfamily Living and the Erosion of Traditional Family Orientations

among Young Adults.” American Sociological Review 51.4 (1986): 541-554. Print.

The authors, researchers at the Rand Corporation and Brown University, use data from the National Longitudinal Surveys of Young Women and Young Men to test their hypothesis that nonfamily living by young adults alters their attitudes, values, plans, and expectations, moving them away from their belief in traditional sex roles. They find their hypothesis strongly supported in young females, while the effects were fewer in studies of young males. Increasing the time away from parents before marrying increased individualism, self-sufficiency, and changes in attitudes about families. In contrast, an earlier study by Williams cited below shows no significant gender differences in sex role attitudes as a result of nonfamilyliving. The data has led me to research similar studies and add additional perspectives to my thesis claiming that the literary story challenges traditional sex roles. I will use this data in my essay to show contrasting sex roles attitudes over a period of several decades.

flora discussion 1

Reply to this post.

The European Economic Community was replaced by the European Union (EU) as the primary political and economic institution for cooperating European countries. The Maastricht Treaty proclaimed a social protocol providing for common standards related to worker health and safety and in other areas such as crime prevention, immigration, and asylum policy. Each country largely retained ultimate sovereignty, especially in defense, foreign policy, and law enforcement (Shubert and Goldstein, 2012). The upsurge in immigration helped fill the less attractive, low-wage jobs in construction, hospitality, and domestic service. The EU agreed to create a European Monetary Union (EMU) with a single currency called the Euro. Europe also began to catch up with America in information technology.

During this period, Europe continued to de-industrialize and agriculture continued to decline, while the service revolution progressed. The national birth rate decreased because the European women were more likely to attend college and join the workforce. Disagreements over who the actual victims of the Holocaust were, caused divisions. The increase in immigration from outside of Europe, especially that of Muslims, caused concern that the “European values” were being threatened. So, the Muslims replaced the Jews as the enemy of the Anglos. The Roma also suffered discrimination, to the point that countries had to abolish discriminatory practices and establish special programs for them as a part of their admission process.

This period was also marked by genocide. When Slovenia and Croatia declared their independence from Yugoslavia, it resulted in civil war. Because they were confident that the European community would not take any military action, the Bosnian Serbs committed genocide against Muslims. The Serbs persecuted Muslims in ways reminiscent of how the Nazis persecuted the Jews during World War II, with mass shootings, and concentration camps. Over 200,000 Muslim civilians were murdered.

The collapse of Communism had both positive and negative effects on Europe. It brought a greater freedom of expression, but also the commercialization and sexualization of culture. The local film industry collapsed, leading to the growing dominance of United States movies. There were also inconsistencies in the historical memories of countries affected by the Holocaust, which led to conflicts.

References:

Shubert, A., and Goldstein, R. (2012). Twentieth-century europe. [Electronic version]. Retrieved from https://content.ashford.edu/

Genocide in the 20th century. Retrieved from http://www.historyplace.com/worldhistory/genocide/…

Case Study on Biomedical Ethics in the Christian Narrative

Write a 1,200-1,500 word analysis of “Case Study: Healing and Autonomy.” In light of the readings, be sure to address the following questions:

  1. Under the Christian narrative and Christian vision, what sorts of issues are most pressing in this case study?
  2. Should the physician allow Mike to continue making decisions that seem to him to be irrational and harmful to James?
  3. According to the Christian narrative and the discussion of the issues of treatment refusal, patient autonomy, and organ donation in the topic readings, how might one analyze this case?
  4. According to the topic readings and lecture, how ought the Christian think about sickness and health? What should Mike as a Christian do? How should he reason about trusting God and treating James?

Ethical issues along with Christian principles and values pertaining to the case study are identified. Any apparent tensions between religious autonomy and physician recommendation are acknowledged.

The analysis of the application of the Christian Worldview principles regarding the ethical issues is excellent in reaching a viable conclusion. An accurate biblical perspective with detailed interaction with the biblical text regarding medicine is clearly discussed, along with how it relates to the issue of healing.

Thesis and/or main claim are comprehensive. The essence of the paper is contained within the thesis. Thesis statement makes the purpose of the paper clear.

Clear and convincing argument presents a persuasive claim in a distinctive and compelling manner. All sources are authoritative.

Prepare this assignment according to the guidelines found in the APA Style Guide

Can you List five services offered by the bank that were mentioned in Chapter 17

Resource: any bank’s website and Bank Services Grading Guide

Write a paper in 1,050 to 1,400 words.

Access a bank’s website.

Resource: any bank’s website and Bank Services Grading Guide

Write a paper in 1,050 to 1,400 words.

Access a bank’s website.

List five services offered by the bank that were mentioned in Chapter 17.

For each service, describe whether it reflects an asset (use of funds) or a liability (source of funds) for the bank.

What interest rates does the bank offer on its CDs determine?

Evaluate the services you have learned about. What is your overall impression?

Format your paper consistent with APA guidelines.

Click the Assignment Files tab to submit your assignment as a Microsoft® Word document.

For each service, describe whether it reflects an asset (use of funds) or a liability (source of funds) for the bank.

What interest rates does the bank offer on its CDs determine?

Evaluate the services you have learned about. What is your overall impression?

Format your paper consistent with APA guidelines.

Click the Assignment Files tab to submit your assignment as a Microsoft® Word document.

Germany tourism, business and finance homework help

The purpose of the Final Paper is to demonstrate your mastery of the learning objectives stated in the class
Syllabus through explaining how your assigned country fits in to the tourism industry. Please review the Syllabus
to know which learning objectives need to be demonstrated in your paper. You must use APA format. Your paper
will be between 6 and 8 pages (not including your sources or title page). The paper should be double-spaced.
Visuals (charts, pictures, etc.) should be used only if it adds to the paper and should not be used to fill space.
Possible Areas of Focus:
• Class Learning Objectives (page 1 of Syllabus)
• What kind of marketing exists to attract tourists?
• What is the state of the infrastructure and does it limit tourism?
• What natural and/or created attractions exist to attract tourists?
• How does the government support tourism?
• What kind of social, culture, and/or environmental issues exist that impact tourism?
• What is the future of tourism?
• What would it be like to be a tourist there?
• What would someone want to visit there?
• What would it be like to own a company that depended on tourism

Metrics to Assess Success, management homework help

The assignment must be a completed paper, with APA formatting, all
sections complete (using Roman numerals of each section per the
outline), references, and good grammar. You’re working for a company that produces small and medium sized coolers. Typical application is for outdoor picnics. Currently all the production and distribution happens out of a facility on the East Coast. Your company has had challenges reaching the customers on the West Coast as a result of the high freight rates, due low density of the product. The marketing manager tried to mitigate this competitive disadvantage by freight equalization; so that end customers would pay the same amount of shipping costs as the West Coast competition charged, regardless of where they were located. This met with some insignificant success because timeliness of delivery was another important issue. However, this did affect the margins negatively since the company now is taking the hit for the less-than-truck-load shipments to West Coast customers.

CEO of the company asked you assess 3 options and to give your recommendation on the way the company should progress:

  • Keep the current setup, continue shipping products from the East Coast facility and distribution center westward;
  • Contract a distribution facility on the West Coast to ship full
    truck loads from the factory there, thus distributing to the final
    customers using less-than-truck-loads; or
  • Establish both a production facility and the distribution
    facility on the West Coast. One complication with that is the fact that
    all the raw materials are still coming from the East Coast.

Section I: Introduction (200 words)

State the problem at hand and alternatives. What are some of the advantages and disadvantages of the distributing products from multiple locations based on your research?

Section II: Manufacturing operations flows (300-500 words)

Discuss the product flows in the manufacturing environment. What are the steps involved in producing the order and shipping it the customer. List the activities and rough timelines. What are some of the risks behind not completing certain activity on time (hint: think of the customer impact)

Section III: Metrics to Assess Success (300-500 words)

What are some of the reasons to measure the performance metrics (KPIs)? List at least 3 specific metrics to access success, be as specific as possible. How would the metrics be measured? Do you believe they should be shared with employees?