Compose a 500 words assignment on advanced sql queries for the pine valley furniture company database. Needs to be plagiarism free!

/in /by

Compose a 500 words assignment on advanced sql queries for the pine valley furniture company database. Needs to be plagiarism free! Advanced SQL Queries for the Pine Valley Furniture Company Database

Question 1: What are the IDs for all orders that include furniture produced by the product line 1?

SELECT ORDER_t.Order_ID, PRODUCT_LINE_t.Product_Line_ID

FROM ORDER_t, PRODUCT_LINE_t

WHERE (((PRODUCT_LINE_t.Product_Line_ID)=1)).

In order to make this query, we need to know which entities or tables we will query. We need the IDs of all the orders that were made on all the furniture processed by product line one.

The most important table in this case is the ORDER table, which we know as ORDER_t. The field from this table that identifies the orders for us is the Order_ID. Given, we need the other table, which has information on product lines. This is the Product_Line table. From this table, we need to query the field that identifies all the product lines for us. It is the Product_Line_ID. We then specify which product line we need to use. This is the product line one. Hence, we have the SQL query above.

Question 2: List the details about the product with the lowest standard price.

SELECT TOP 1PRODUCT_t.Product_ID,PRODUCT_t.Product_Description, PRODUCT_t.Product_Finish, PRODUCT_t.Standard_Price, PRODUCT_t.Product_Line_ID

FROM PRODUCT_t

GROUP BY PRODUCT_t.Product_ID, PRODUCT_t.Product_Description, PRODUCT_t.Product_Finish, PRODUCT_t.Standard_Price, PRODUCT_t.Product_Line_ID

ORDER BY Min(PRODUCT_t.Standard_Price).

In this query, we need to come up with the list of the products that has the lowest price. To get the result, we need to sort the prices of the products and choose the one that is the least among them all. In the parameters for the queries, we indicate that we would like to pick the top item from the field whose values have been sorted in ascending order. From then on, we display the top 1 item to show us the least item in terms of the price.

Question 3: List the employee ID, name, and his/her work center ID for all employees

SELECT EMPLOYEE_t.Employee_ID, EMPLOYEE_t.Employee_Name, WORK_CENTER.Work_Center_ID

FROM EMPLOYEE_t, WORK_CENTER.

This query is obtained from the employee table and the work center table. From the employee table we get the employee identifications and the names of the employees. The work center table is only meant to give us the work center identifications for the employees. Once we get the values from both of the tables, we make the query.

Question 4: How many different items were ordered on order number 1006?

SELECT Order_line_t.Order_ID, Order_line_t.Product_ID

FROM Order_line_t

WHERE (((Order_line_t.Order_ID)=1006)).

The above query is made on the order line table of the database. This table contains both the order ids as well as the product identification numbers. In order to know which different products are contained in the order number 1006, we design the query in such a way that we display the order ids for all the product lines while indicating the product line number 1006 as the only restriction on the query.

Question 5: Give 10% discount to all the products manufactured by the product line 3

SELECT PRODUCT_LINE_t.Product_Line_ID, PRODUCT_t.Standard_Price, PRODUCT_t.Product_Description, PRODUCT_t.Product_ID, PRODUCT_t.Standard_Price*0.9 AS Discounted_Price

FROM PRODUCT_LINE_t INNER JOIN PRODUCT_t ON PRODUCT_LINE_t.Product_Line_ID = PRODUCT_t.Product_Line_ID

WHERE (((PRODUCT_LINE_t.Product_Line_ID)=3)).

In order to know the discounted product prices for the products manufactured by the product line 3, we need to calculate the discounted prices and display them on a different column. The operands for the calculation are the Standard_Price for all the products, and 0.9. Once the calculation has been done, we display the product details of the products manufactured by line 3.

Works Cited

“Chapter 5 Logical Database Design and the Relational Model.” e-Portfolio TurgutTezir.N.p., 2006. Web. 2 Mar. 2012 .

Compose a 250 words assignment on marketting chap 3. Needs to be plagiarism free! Strategic Issues in Marketing and Affiliation Strategic Issues in Marketing What is the issue? What is the source of your information?

/in /by

Compose a 250 words assignment on marketting chap 3. Needs to be plagiarism free! Strategic Issues in Marketing and Affiliation Strategic Issues in Marketing What is the issue? What is the source of your information?

The Impacts of Consumer Behavior in Marketing is one of the issues currently affecting the marketing activities in the world. This is in relevance to the changes in consumer behavior, tastes as well as preferences. This information is retrieved from https://writer.academia-research.com/orders/vieworder/order id/1292282 as the major literary source.

2. How does the issue affect the strategic Marketing of a company? Be sure to use examples.

It is of crucial significance to note that consumer behaviors is always critical in controlling the type of marketing strategies employed by different companies in various measures, as well as, ways. Both small scale and large scale businesses may always employ certain approaches as well as techniques relevant to changes in consumer behavior (Dietrich and Media, 2015)s. In marketing, businesses always need to acquit themselves with certain information from their consumers including their locations, what they want, as well as who their real consumers are. Changes in consumer behaviors always make businesses to conduct thorough researches, as well as, surveys in order to know what the consumers want. For example, in case they fail to satisfy the changing consumer interests and needs, marketing of such products may be compromised and can easily fail. As such, the businesses always conduct surveys and research through sales forecasts, internet researches, as well as, market sensing (Dietrich and Media, 2015). This gives them a competitive advantage in the marketing spectrum as they deeply understand the needs of their customers, failure to which, can lead to failure of the companies.

3. How does the economy of US affect the issue

It is important to note that the issue of consumer behavior is also affected by the economy of the United States in certain ways. For instance, if the economy strengthens, the consumer demands and tastes increases (Rao, 2010). However, if the economy faces some crises, the consumers also feel these economic crises, thereby limiting their consumption demands.

4. How does the legislation affect the issue?

It is of critical significance to note that changes in consumer behavior are not influenced by any legislation. This is because consumer behaviors are majorly dictated by their own personal interests, tastes and preferences. As such, it is important to note that consumer behavior can affect the market in various ways.

5. What is your personal opinion on the issue?

According to my opinion, consumer behavior always controls the markets in various ways. as such, the changes in consumer behavior can always make some companies to experience big losses if they do not device effective marketing strategies to approach the situations occasioned by the changes in consumer behaviors. Therefore, it is always prudent that companies conduct regular surveys, as well as researches on how to best satisfy the needs and demands of their consumers. This is important for such companies to remain economically relevant and competitive in the world marketing fronts.

References

Dietrich, R. and Media, D. (2015). “The Effect of Consumer Behavior in Marketing of Organisation”. Retrieved from http://smallbusiness.chron.com/effect-consumer-behaviour-marketing-organization-17934.html on 4th July 2015.

Rao, S. R. (2010). “Consumer Behavior and Marketing Implications”. Retrieved on 4th July 2015 from http://www.citeman.com/8609-consumer-behavior-and-marketing-implications-2.

Does the USA PATRIOT ACT violate civil liberties? You must choose a side and you must explain why or why not.

/in /by

Write a one page essay (one full page of text – at least 300 words – or there will be a point deduction) addressing the following question: Does the USA PATRIOT ACT violate civil liberties? You must choose a side and you must explain why or why not. Also, remember to cite all sources – proper footnotes and works cited page (or you’ll receive a grade of 0). Proofread for format and mechanics as well (double space, 12 size font, grammar, punctuation, capitalization, spelling, etc.).

Research Paper on Income Inequality: The Causes, Consequences and Solutions.

/in /by

Research Paper on Income Inequality: The Causes, Consequences and Solutions.

 

To do this paper, first you must read Chapter 23 power point that discusses income equality which is at the bottom of the page. Second, you must find at least four additional sources that discuss income inequality. Third, choose a country that has been struggling with economic growth. Fourth, using each of the concepts and theories discussed in chapter 23 as a framework to investigate why there is such a high-income inequality. Finally, explain step by steps how they can apply these concepts and theories can help solving income inequality. The paper must be at least 5 pages and at most 10 pages.

 

Outline

This paper must be written in many paragraphs of 5 to 8 sentences. Each of the topics in this

outline should be and can be at least a paragraph. Also, this outline is only a guide; you should

change it as you think it may be better to write your paper.

 

  1. Introduction
  2. Body

 

Part 1

  1. Define Income Inequality.
  2. Causes of Income Inequality
  3. Consequences of Income Inequality

 

Part 2

  1. Choose a country with income inequality and explain the causes by using theories

in Ch 23.

  1. Causes/ Argument 1 Explanation
  2. Causes/Argument 2 Explanation
  3. Causes/ Argument 3 Explanation
  4. Causes/ Argument 4 Explanation

 

Part 3

  1. Using the deficient found in part 2, explain how the theories in chapter 23 can be

applied to solve income inequality.

  1. Application of Solution/ Argumen1
  2. Application of Solution/Argument 2
  3. Application of Solution/ Argument 3
  4. Application of Solution/ Argument 4

III. Conclusion

  1. Concluding Statement
  2. Analytical Summary
  3. Thesis Reworded
  4. Recommendations

 

References

(APA or MLA) I prefer MLA

This is only an example on how to do your work cited. Please do not use these

sources

[1] Agenor, Pierre-Richard. (2000) “Monetary Policy under Flexible Exchange Rates: An

Introduction to Inflation Targeting.” Unpublished manuscript, 2000.

[2] Akaike, H. (1973) Information Theory and an Extension of the Maximum Likelihood

Principle,

in Petrov, B., Csaki, F., eds., Second International Symposium on Information Theory.

[3] Angeriz, A and P. Arestis (2007) “Assessing Inflation Targeting Through Intervention

Analysis”, Oxford University Press, Vol.,60(2), pp. 293-317

[4] Bamidele, A. (2007) Pre-requisite for Inflation Targeting Country Experiences and Lessons

for

Nigeria, Being a Paper delivered at the Inflation Targeting Workshop organized by the Central

Bank of Nigeria Learning Centre Lagos, July

[5] Bakradze, G. & A. Billmeier (2007) Inflation Targeting in Georgia: Are We There Yet? IMF

Working Paper, WP/07/193, International Monetary Fund, Washington, USA.

[6] Barro, R. (1995) Inflation and Economic Growth, Bank of England Quarterly Bulletin, vol.

35

(May 1995), pp. 166-76.

[7] Bernanke, Ben, Thomas Laubach, Frederic Mishkin, and Adam Posen (1999). Inflation

Targeting: Lessons from the International Experience. Princeton, NJ: Princeton University

Press.

[8] Bernanke, Ben S. (2003) “A Perspective on Inflation Targeting,” remarks at the Annual

Washington Policy Conference of the National Association of Business Economists,

Washington, D.C., March 25. Available via the internet:

[9] Bernanke, B. S. & F. Mishkin (1997) Inflation Targeting: A New Framework for Monetary

Policy? Journal of Economic Perspectives11, 97-116.

[10] Bruno, M. and Easterly, W. (1995) Inflation Crisis and Long-Run Growth, Working Paper,

World Bank, September 1995

 

Specific Instructions

  1. Font 12, Times New Roman, double space
  2. Margins of 1″ to 1-1/4″ on all sides
  3. 5 Pages minimum or 10 pages maximum of written information
  4. The paper must have a cover page, an outline, and a reference page
  5. Cover page, outline, and work cited pages are not counted towards the 5 pages
  6. Paragraphs must have a maximum of 10 sentences.
  7. Extra references are accepted.
  8. They cannot be Wikipedia, Investopedia, or any open platform.
  9. Only books including the textbook and reputable newspapers or magazines such as Wall

Street Journal, New York Times, Financial Times, Forbes Magazine, Money Magazine

etc. will be accepted.

 

 

 

 

Week 5 Paper: Transgender Individuals with HIV/Aids Apply the concepts of population health and epidemiology to the topic.

/in /by

 Infectious disease

Requirement

My state is Maryland.

Week 5 Paper: Transgender Individuals with HIV/Aids

Apply the concepts of population health and epidemiology to the topic.

Synthesize Course content from Weeks 1-5 according to the following sections:

Introduction: Analysis of the communicable disease (causes, symptoms, mode of transmission, complications, treatment) to include demographic break down that includes age, gender, race, or other at-risk indicators (da ta per demographics should include mortality, morbidity, incidence, and prevalence).

Determinants of Health: Define, identify and synthesize the determinants of health as related to the development of the infection. Utilize HP2020.  Robust identification and description of the determinants of health with explanation of how those factors contribute to the development of this disease. Evidence supports background.

Epidemiological Triad: Identify and describe all elements of the epidemiological triad: Host factors, agent factors (presence or absence), and environmental factors. Utilize the demographic break down to further describe the triad. Uses example/s, resources, to fully describe the triad.

Role of the Nurse Practitioner: Succinctly define the role of the nurse practitioner according to a national nurse practitioner organization ( National Board of Nursing or AANP, for example) and synthesize the role to the management of infectious diseases (surveillance, primary/secondary/tertiary interventions, reporting, data collecting, data analysis, and follow-up). This includes the integration of a model of practice which supports the implementation of an evidence-based practice.  Refer to your course textbook for models of practice examples. ( Curley, A.L. & Vitale, P.A. (2016). Population-Based Nursing: Concepts and Competencies for Advanced Practice (2nd ed.). New York, NY: Springer Publishing).

Preparing the paper

Submission Requirements

Application: Use Microsoft Word™ to create the written assessment.

Length: The paper (excluding the title page and reference page) should be limited to a maximum of four (5) pages. Papers not adhering to the page length may be returned to you for editing to meet the length guidelines .

A minimum of three (3) scholarly research/literature references must be used. CDC or other web sources may be utilized but are not counted towards the three minimum references required. Your course text may be used as an additional resource but is not included in the three minimum scholarly references.

APA format current edition.

Include scholarly in-text references and a reference list.

Do not write in the first person (such as “me” “I”)

Follow submission requirements.

Make sure all elements on the grading rubric are included. Organize the paper using the rubric sections and appropriate headings to match the sections.

Rules of grammar, spelling, word usage, and punctuation are followed and consistent with formal, scientific writing.

Title page, running head, body of paper, and reference page must follow APA guidelines as found in the current edition of the manual. This includes the use of headings for each section of the paper except for the introduction where no heading is used.

Ideas and information that come from scholarly literature must be cited and referenced correctly.

A minimum of three (3) scholarly literature references must be used. **See above section on “Preparing the Paper”.

a. We first consider studying the relationship between rm (average number of rooms) and medv (house price). Please make a scatter plot of medv against rm and calculate their sample correlation using Excel. Please comment.

/in /by

MIS 301, Statistical Analysis for Business, Project
Boston all.xlsx contains housing data for 506 census tracts of Boston from the 1970 census.
There are 13 variables and 506 observations:
1. crim: per capita crime rate by town.
2. zn: proportion of residential land zoned for lots over 25,000 square feet.
3. indus: proportion of non-retail business acres per town.
4. chas: Charles River dummy variable (1, if tract bounds river; 0 otherwise).
5. nox: nitrogen oxides concentration (parts per 10 million).
6. rm: average number of rooms per dwelling.
7. age: proportion of owner-occupied units built prior to 1940.
8. dis: weighted mean of distances to five Boston employment centers.
9. rad: index of accessibility to radial highways.
10. tax: full-value property-tax rate per $10,000.
11. ptratio: pupil-teacher ratio by town.
12. lstat: lower status of the population (percent).
13. medv: median value of owner-occupied homes in $1000s.
Our goal is to interpret the house price with all available information.
a. We first consider studying the relationship between rm (average number of rooms) and medv
(house price). Please make a scatter plot of medv against rm and calculate their sample correlation
using Excel. Please comment. (15%).
b. We regress medv (as y) on rm (as x). Please include the Excel output and write down the
estimated regression model. (10%).
c. Secondly, we investigate the relationship between tax (property tax) and medv (house price).
Please make a scatter plot of medv against tax and calculate their sample correlation using Excel.
Please comment. (15%).

What innovative practices have enabled companies to produce and distribute fashion items more quickly and cheaply since the 1990s? What is your opinion about the benefits or drawbacks?

/in /by

Write a source-based essay in which you give your opinion about one of the critical thinking questions about fast fashion (500-600 words). Use at least one quote and one paraphrase from each of your sources.

  • What innovative practices have enabled companies to produce and distribute fashion items more quickly and cheaply since the 1990s? What is your opinion about the benefits or drawbacks?
  • What steps, if any, do you think government authorities should take to reduce the high levels of resource consumption associated with fast fashion? Explain your answer.
  • In your opinion, what factors are most likely to contribute to a slowdown in the global fast fashion industry?

Use MLA format for your essay and include in-text citations with a Works Cited page.

1-What did you learn about Africa? 2-How does not knowing this information contribute to stereotypes about Africa?

/in /by

watch these two videos and answers the questions afterwards.

 

Lost Kingdoms of Africa 4 of 4 West Africa(https://www.youtube.com/watch?v=QW_kaUuUg8Y)

 

Africa, you won’t see on TV(https://www.youtube.com/watch?v=ZfG-5ZhI3wk)

 

1-What did you learn about Africa?

2-How does not knowing this information contribute to stereotypes about Africa?

3-Why do you think Hollywood never shows Africa in this way?

In our textbook, Stephen Prothero presents the thesis that “God is Not One.” It has become common in our politically correct, tolerance-obsessed culture to not only not judge or criticize other religions, but also to speak of them as if they are all essentially the same.

/in /by

In our textbook, Stephen Prothero presents the thesis that “God is Not One.” It has become common in our politically correct, tolerance-obsessed culture to not only not judge or criticize other religions, but also to speak of them as if they are all essentially the same. Many people today believe that all religions are just different paths up the same spiritual mountain. Even though the religions have different ideas and practices, ultimately everyone arrives at the same place when they finally make it to the top. Given everything that you have learned this semester, what to you think of this argument? Do you think the one mountain metaphor is accurate — that all religions are essentially the same — or do you agree with Prothero that it is a mistaken, perhaps even a potentially dangerous view to hold?

9 Compare the GCC performance for last 5 years (member country’s GDP nominal and real term) with other regional trading block or union (European Union or G7 or G20 BRICs).

/in /by

CLO3. Analyse the development and diversification policies of GCC states in areas of business, education and localization for socioeconomic development.

CLO4. Compare the GCC performance and achievements with other regional trading blocks and unions.

CLO5. Evaluate the GCC competitiveness performance at the Global level.

Format of the report :

Select any GCC member country of your choice.

Index

(Covering CLO3)

1 Introduction about the country –very brief.

2 Gross domestic product of the country (Nominal and Real)-Compare from 2015 to 2019 and the latest year available-make some tables and graphs

3 Export-Import (2014 to 2020)

4 Unemployment- for these comparable years-table and graph (2015 to 2020)

5 Inflation in the country for these years (2015-to 2020) table and graph

6 Transformation in Education, and Health sector

7 Diversification from Oil-based to non-oil based sector

8 Localization programmers

(Covering CLO4 )

9 Compare the GCC performance for last 5 years (member country’s GDP nominal and real term) with other regional trading block or union (European Union or G7 or G20 BRICs).

(Covering CLO5 )

10 Evaluate GCC member country competitiveness performance (in term of development) at the global level.

11 References

(The assignment should be discussing these points and should between 15-20 pages)

Plagiarism will be checked