Database design discusion | Computer Science homework help
Part 1 Combining Tables
Please respond to BOTH of the following questions:
Question A
What is a join command? In addition, How can you combine two tables/views together? For instance one table contains 100 rows and the other one contains 200 rows, have exactly the same fields and you want to show a query with all data (300 rows).
Question B
Why can a group by or order by clause be expensive to process? What is the difference between a where and having clause?
Part 2 Peer Responses
Please respond to two peers.
Peer 1 Bill
The join clause does as it sounds, it will join two more tables in a relational database. I looked at some forums for suggestions, and one of the better answers I found in how to join the tables would be using the following syntax:
CREATEVIEW vw_combined AS
SELECT *
FROM TABLE1 t1
JOIN TABLE2 t2 ON t2.col = t1.col
Again, both tables need to have the same columns of data. The having clause is a limit on the results that are produced on the search. The where clause determines what row to be included on the select and what it is specifically looking for.
Peer 2 Teds responce to Bill
Bill, how would you combine the contents of two tables without a JOIN?
Pcn 515 week 8 assignment 1 collaborative learning community
This is a CLC assignment.
Imagine a new organization that you and your colleagues are developing. The purpose is to provide information to those in need of counseling services. This information will be presented to the community in a brochure. In order to evaluate the resources, as a group, decide on the format you will utilize while compiling the resources (this brochure can be in a PowerPoint or
Word document format). Include all of the criteria below:
Provide the organizations and/or agencies names which offer support or counseling groups. For each organization and/or agency provide:
Location
Contact person
Description of the services provided
Outline of the theories that apply
Provide the organizations and/or agencies names which offer career counseling services. For each organization and/or agency provide:
Location
Contact person
Description of the services provided
Outline of the theories that apply
As a group, present the brochure addressing what the group feels is essential information that will be useful to members of this new organization.
APA format is not required, but solid academic writing is expected.
You are not required to submit this assignment to Turnitin, unless otherwise directed by your instructor. If so directed, refer to the Student Success Center for directions. Only Word documents can be submitted to Turnitin.
Finance help research ford and general motors and answer four
I can fill in the blanks and do not need a lengthy story for each of the questions. Just help me with the highlights and Ill take it from there.
Consider General Motors and Ford, both automobile manufacturers, examine their financial data online and answer the following questions.
Select three items from the income statements that you feel would be important to an investor. Analyze and compare your two companies in terms of these items and how they are performing relative to each other and in general.
Select three items from the balance sheet that you feel would be important to an investor. Analyze and compare your two companies in terms of these items. How they are performing relative to each other and in general? Provide a rationale for your conclusions.
Based upon information contained in the Statement of Cash Flows for General Motors and Ford:
What are the two largest investing activities and financing activities for each firm?
Compare and contrast the investing and financing activities of the two companies.
Evaluate the investing and financing strategies of the two firms? Provide a rationale for your opinion as to the effectiveness of each of the strategies.
What does the literature suggest regarding the impact that
What does the literature suggest regarding the impact that globalization is having on the HR function specifically? You will now have the opportunity to enhance your knowledge of the global future by writing a paper focusing on of the major elements of globalization.
Conduct research to locate at least two (2) scholarly sources regarding globalization and its effect on human resource management specifically. Write a comprehensive paper on the following topic:
The core competencies of a Global Human Resources specialist are critical to the success of a global organization. (Be sure to provide specific examples of what these core competencies consist of and how they are applied in a global versus a domestic setting.)
Support your paper with a minimum of three (3) resources, which may include your required text. In addition to these specified resources, other appropriate scholarly resources, including older articles, may be included.
Length: 5-7 pages not including title and reference pages
Your paper should demonstrate thoughtful consideration of the ideas and concepts presented in the course and provide new thoughts and insights relating directly to this topic. Your response should reflect scholarly writing and current APA standards. Be sure to adhere to Northcentral Universitys Academic Integrity Policy.
Management 371 final project | English homework help
.In this paper the purpose of the project is to give insight into the practical applications of the management principles. The paper should specifically include. Planning-How are goals and plans made and rewarded with the organization? The managers role and responsibilities in planning and goal setting? What changes would you recommend to improve effectiveness, if any?
Organizing-What type of organizational structure? Centralized vs decentralized authority? Use of teams? The organizations culture? The managers role in the organization and responsibilities related to organizing? What changes would you recommend, if any and why?
Leasing-What leadership traits did you observe in the manger? What support or training does the company provide to foster leadership? What functions does the manager perform as a leader? What changes would you recommend to improve the mangers effectiveness as a leader/
Controlling- How does the company and manger monitor employees, performance, results, etc and provide feedback? Bureaucratic control vs decentralized control? The use of technology? What changes would you recommend? Does the manager appear to be well suited for her current position and would they be appropriate for a higher position YESbecause they have the ability to train others-What are the major things learned from this exercise?
Case Study Sales Promotion Essay
Café Sunshine is a fictional coffee and sandwich shop in the fictional US city of Seaside. The café sells excellent coffee drinks, house-made muffins and cookies, and delicious fresh sandwiches at reasonable prices. Café Sunshine is an independent operation, whose main competitors are other nearby sandwich shops and Starbucks.Café Sunshine is located in the business district of the city, and its target market is people who work in the area. It is open Monday through Friday from 6:00am to 4:00pm.The café is extremely busy in the morning, selling coffee, muffins, and breakfast sandwiches. Business also picks up from 2:00-3:30pm, when customers come in for afternoon coffee and treats. However, business is a little slow at lunchtime. The owners would like to increase lunch business. They have asked you, a marketing communications expert, for help.Your task: Design a sales promotion program with the objective of increasing lunch sales.Instructions:Create a sales promotion campaign using one of the following tools: samples, premiums, or contest/sweepstakes/game. Describe the campaign in detail.Describe your method for measuring and evaluating the results of the campaign.Describe your plan to promote the campaign on social media. Choose your platform (such as Instagram, Facebook, Twitter), and describe your messages.
Online homework | Psychology homework help
Assignment 3: Cultural Influence in Business Psychology
Mark Jones, a Production Manager, has been transferred from the manufacturing plant in his hometown of Chicago to his companys overseas manufacturing plant in Osaka, Japan.
You are the companys I-O psychologist. Using Hofstedes Five Basic Elements of Culture Distinction, write an e-mail message to the Vice President (VP) of Production discussing at least three cultural differences that Mark will experience in managing front-line plant workers in Japan in contrast to in the United States. Also address how cultural differences may play a role in individual differences Mark will experience.
Your e-mail message should also include at least three recommendations on how managers can take up overseas tasks with minimum transition problems. State the rationale for your recommendations.
Because the VP of Production is a busy individual, restrict your e-mail message to one to two pages. Type the e-mail message in Microsoft Word, and send it to theM1: Assignment 3 Dropbox by Wednesday, March 19, 2014.
Where appropriate use structured textbold format, headings, bulleted lists, and graphicsto clarify your meaning and to make your document easier to read. Remember texting language will not be acceptable.
Hollands theory theoretical model to use as a lens for discussion | COUN 6215 Lifespan Development
For this discussion, you will be working once again with your client family. Your client is a young adult with specific presenting issues. The clients and age areKelsey (Jeong) age 26
main discussion post should address all areas of the discussion prompt. An outline for your post might look like this:
Introduction (no heading) brief overview of Kelsey Jeong presenting issues identification of developmental theory you are using to conceptualize this client. The Theory is Holland
identification of Kelsey Jeong developmental level or stage according to the Hollands theoryPromoting Positive Development how you will develop rapport and promote engagement in counseling how the Hollands theory will help you with this task approach/goals based on (Hollands theory) developmental theory and levelSummary why and how developmental theory helps to conceptualize client why and how developmental theory supports counselors efforts to facilitate development
References
Resources used should include the Broderick and Blewitt (2020) text and at least 1-2 peer-reviewed articles you found to support your points.
Your main discussion post should demonstrate critical thinking and analysis and an ability to apply concepts. All posts should adhere to APA format
UDC Nietzsche Questions
I dont understand this Philosophy question and need help to study. For the passage below, give: each question only 2-3 sentence showing the main points 1) an explanation of what Nietzsche means in the passage quoted,2) the general context in which it occurs, and3) how that which Nietzsche intends to communicate through the quote fits into On the Advantage and Disadvantage as a whole.What the world is there for, what humanity is there for is not to concern us for the time being, unless we want to be funny: for there just isnt anything funnier and more cheerful on the worlds stage than the presumptuousness of those little worms called man; but do ask what you, the individual, are there for, and if no one else can tell you then just try sometime to justify the meaning of your existence a posteriori, as it were, by setting yourself a purpose, a goal, a for this, a lofty and noble for this. And perish in the attempt I know of no better lifes purpose than to perish, animae magnae prodigus, in attempting the great and impossible. (p. 54-55)
Migration/population | Social Science homework help
Migration
The human population has lived a rural lifestyle through most of history. The worlds population, however, is quickly becoming urbanized as people migrate to the cities. Developed nations have a higher percentage of urban residents than less developed countries. However, urbanization is occurring rapidly in many less developed countries, and it is expected that most urban growth will occur in less developed countries during the next decades.
In this Case, you are to select a country (not Nigeria and Canada) which is experiencing rural-urban migration and answer the following questions.
1. Identify the Country you have selected and briefly describe its demographics.
2. Discuss the factors that are driving rural-urban migration in your selected country? (Hint: Migration is often explained in terms of either push factors conditions in the place of origin which are perceived by migrants as detrimental to their well-being or economic security, and pull factors the circumstances in new places that attract individuals to move there).
3. Describe the impact of rural-urban migration in your selected country? Consider health, environmental, economic and social implications.
