I’m working on a databases exercise and need an explanation to help me study.
The database class is being taught using pgAdmin4. The homework asks for the following:Write a SQL query using the university schema to find the ID of each student who has never taken a course at the university. Do this using no subqueries and no set operations (use an outer join).You must submit your answer by writing the query text into the response area (i.e. no pictures, PDFs, Word documents, etc).***PLEASE IGNORE WHERE IT SAYS COMPUTING LANGUAGE!! I needed to add a language for it to continue but SQL wasn’t listed***
DTSC 660 Eastern University Mod 4 SQL Query for University Schema Report
You are working as an analytics developer for a government firm such as CDC. You have collected close to 200 TB of medical health records. CDC needs to convert all the existing data to another format such as parquet within three weeks. It takes three days to convert one terabyte of existing data to the parquet format. So it is impossible to use the traditional approach to convert 200 TB of data from one format to the other within three weeks.
You are required to use Big Data architecture on the cloud platform. You need to design the system architecture and write one page summary about how your job is complete within three weeks.
Provided the detailed architecture diagram.
One or two pages of summary document.
Screenshot of SAS script output.
Big Data Architecture on the Cloud Platform
Associate Professor: Joseph G. Radzikowski,Select any four of the six questions of your choice. Each question should be at a minimum of two pages with all parts answered. No title page necessary, you can use any sources to develop your answers and you do not need to cite the sources. This first research set the foundation, parameters expectations for all other critical thinking assignments. Once completed submit as up load into canvas. Grader will be posted to the grade book. This first research counts for twenty percent of your overall grade.Compare Lincoln’s plan for Reconstruction, the Wade Davis Bill, Johnson’s plan, and Radical Reconstruction. Evaluate the successes and failures of Reconstruction2 Define the problems faced by Radical Reconstruction governments. List the major accomplishments of these governments.3.How did the Federal government post-Civil-War policies in the West affect Native Americans? Discuss the characteristics of the Carlisle Indian School. How successful was the school in achieving assimilation of the Indian children? How did decisions regarding mining, farming, and ranching shape the development of the Southwest?Explain the conditions that led to the rise of big business in the nineteenth century. Define the terms vertical and horizontal integration, trusts, and corporations.Why did American cities experience explosive growth in the late nineteenth century? How did municipal governments respond to the challenges of urban growth?
ECON 101 Grossmont College American History Discussion
“Travels With Charley” a Book by John Steinbeck Essay
Charley is a traveling companion of the semi-autobiographical novel by John Steinbeck. Although his participation is sometimes attributed to the author’s fascination with dogs, Charley actually serves two functions in the novel: he is an important character that helps to highlight the author’s point and a plot-forming device, and object that triggers certain events that are unlikely to happen otherwise. Travels With Charley is structured in the form of a travel diary. It recounts the observations and impression which emerged during the trip undertaken by the author in his late fifties. The most often cited reason for the endeavor, stated by Steinbeck himself, was the disconnection from the country he was writing about, and the desire to experience it closely rather than from the bird-eye view. Besides, he probably wanted to taste the local culture instead of the blurred non-distinctive nation-wide image, which can be seen in Steinbeck’s statement “There are customs, attitudes, myths and directions and changes that seem to be part of the structure of America. And I propose to discuss them as they were the first thrust on my attention” (Steinbeck 44). A peculiar detail that often draws the attention of scholars and readers alike is his choice of partner – his French poodle, Charley. While the simpler explanations, like an attachment to a pet, are tempting, there are likely deeper reasons for this move. The research by some specialists that point to discrepancies and inconsistencies within the story and suggest that it is at least partially fictionalized, further strengthen the suspicion that Charley is not simply a random or a sentimental choice, but rather a deliberately selected way of conveying the intended message, the idea permeating the book. First of all, it is important to note the time at which the journey was undertaken: The early sixties. The era which is commonly associated with the disillusionment in humanity: the ongoing Cold War has already turned the idea of total destruction of mankind into a feasible, and a very real threat, the sharpening civil rights struggles across America have discredited the concept of compassion and brotherhood, the Vietnam War has begun to gain its notoriety on a large scale, and the hippie movement was already emerging as a reaction to all this. This last fact is especially important for us, as the nature-centric approach, the denial of human superiority, and the stressing on the animals’ positive traits compared to humans were on the rise in this period. This alone could serve as an explanation for Charley’s role in Steinbeck’s trip. Indeed, by contrasting the dog’s behavior and character to that of humans he’s encountered on the road, Steinbeck makes an excellent point of his observations. The depiction of animals as demonstrating the features that are deemed positive from the human’s standpoint is nothing new and indeed has been in use long before the publication of Travels with Charley. However, to view the dog simply as a litmus test for emphasizing a point would also be short-sighted. In fact, the author rarely uses the contrasting technique directly, and when he does, he makes it subtly, without ever disrupting the life-like descriptions of the animal behavior. Get your 100% original paper on any topic done in as little as 3 hours Learn More Neither does he grant the dog the unusual and unlikely wisdom or intellect, or in that regard, treats him like the over-important figure. Charley is often portrayed engaging in activities any dog should: “I fed Charley, gave him a limited promenade, and hit the road.” (Steinbeck 34) This strips him of any overly sacred or pompous qualities characteristic of the animals in the Aesops of the “Natural wisdom” literature. While it is true that Steinbeck sometimes compares Charley to a human, it always remains within the domain of the owner adoring his pet, and retains the humorous vibe, like in the description of sequences of Charley trying to wake his master up: “Often the war of wills goes on for quite a time, I squinching my eyes shut and he forgiving me, but he nearly always wins.” (Steinbeck 61) However, we soon notice that whenever the dog is present as a participant of some event, we can’t help but speculate how he would perceive the situation if he had the capability to do it. However, there is another important reason for Charley to appear in the book. His silent presence often triggers the events that serve as a commentary for the trends of the American society of the time. The most memorable passage describes the part of the journey happening in the deep South of the country when Steinbeck reports several occasions on which Charley, who was occupying the seat next to driver’s, was mistaken for an African American by the passers-by: “”Hey, it’s a dog! I thought you had a nigger in there.” And he laughed delightedly. It was the first of many repetitions. At least twenty times I heard it—”Thought you had a nigger in there.” It was an unusual joke—always fresh—and never Negro or even Nigra, always Nigger or rather Niggah.” (Steinbeck 203) In this regard, Charley not only serves a trigger to enable the shameful attitude towards the Black population – he actually seems much more humane contrasted to the people who, either deliberately or by mistake, express their belief that the Black people are actually nothing more than animals. Overall, Charley is preferred by the author over a human companion for two reasons. First, he makes up a subtle yet bright character, who, despite his naivety and humorous vibe, adds an angle to the events. Second, he serves as an object that triggers events that are important for the message of the book. Steinbeck was concerned with America of his day, and Charley helped him make it clear. Works Cited Steinbeck, John. Travels with Charley in Search of America, New York: Penguin, 2012. Print.
I have this asssigment that im making more difficult then it needs to be i will paste the instructions
help writing I have this asssigment that im making more difficult then it needs to be i will paste the instructions.
1. Issue: Affordable Housing Shortage- there is not enough affordable housing for people living in Los AngelesEpstein, Richard A. “Home is where the market is: what we should do–and stop doing—in the quest for ‘affordable housing.’.” Hoover Digest, no. 3, 2017, p. 137+. Opposing Viewpoints in Context, http://link.galegroup.com.libdb.smc.edu/apps/doc/A506674610/OVIC?u=sant99200&sid=OVIC&xid=11d46b10. Accessed 2 Dec. 2018.http://go.galegroup.com.libdb.smc.edu/ps/retrieve.do?tabID=Journals&resultListType=RESULT_LIST&searchResultsType=MultiTab&searchType=BasicSearchForm¤tPosition=1&docId=GALE%7CA506674610&docType=Essay&sort=Relevance&contentSegment=&prodId=OVIC&contentSet=GALE%7CA506674610&searchId=R2&userGroupName=sant99200&inPS=true#Issue network: Network Lobby for Catholic Justice – https://networklobby.org/issues/housing/The housing crisis issue is in the policy maintenance stage. There are currently policies in place that need to be changed. In California we recently voted on proposition 10, which sought to change laws that were put in place in 1995 that allowed property owners to have full control over their rent prices so they could keep up with the market. This has become a problem because owners keep increasing rent making housing unaffordable in some cities throughout the state. In other words, there is a high demand for cheaper rentals and not enough supply. This proposition attempts to fix this by allowing the state to set rent prices.Opposing viewpoints:Cuomo, Andrew. “The Federal Government Should Work to Provide Affordable Housing.” The Homeless, edited by Jennifer A. Hurley, Greenhaven Press, 2002. Opposing Viewpoints. Opposing Viewpoints in Context, http://link.galegroup.com.libdb.smc.edu/apps/doc/EJ3010235218/OVIC?u=sant99200&sid=OVIC&xid=5b7a6bee. Accessed 3 Dec. 2018.Infographic- https://www.freeenterprise.com/these-3-social-impact-startups-are-coding-change-in-detroit/ (Links to an external site.)Links to an external site.MediaNuns on the Bus-https://philadelphia.cbslocal.com/2018/10/25/nuns-on-the-bus-visit-philadelphia-to-highlight-affordable-housing-need/ (Links to an external site.)Links to an external site.Interest GroupsArticle/ infographic http://www.people-press.org/2008/01/24/housing-crisis-more-visible-than-other-economic-problems/ (Links to an external site.)Links to an external site.Housing crisishttp://www.pewresearch.org/fact-tank/2009/02/17/housing-crisis/ (Links to an external site.)Links to an external site.City labhttps://www.citylab.com/equity/2018/05/is-housing-americas-next-big-political-issue/560378/ (Links to an external site.)Links to an external site.Public/CommunityU.S Chamber of Commercehttps://www.freeenterprise.com/these-3-social-impa… (Links to an external site.)Links to an external site.press release:https://housingpartnership.net/ideas/news-media/housing-partnership-network-receives-aaa-2-aeris-rating (Links to an external site.)Links to an external site.As well as examples from other students which will clear up what he is wanting regarding this assignment. This assignment shouldn’t take long!once you view the examples you will understand why. Objective: to identify and analyze public problem (something government needs involvement] outline an external environment/issue network to policymaking stages: agenda setting > policy enactment > post enactment above is an example of what he is looking for.
I have this asssigment that im making more difficult then it needs to be i will paste the instructions
Climate Change A Big Market Failure Politics Essay
Lord Stern has described climate change as “the biggest market failure the world has seen”. What are the major economic features of climate change that make it such a significant market failure? Outline carefully the policy challenges of addressing two of these features. He, who knows what sweets and virtues are in the ground, the waters, the plants, the heavens, and how to come at these enchantments, is the rich and royal man. Only as far as the masters of the world have called in nature to their aid, can they reach the height of magnificence. Whilst thinking about which topic to choose amongst I got this “Having covered environmental issues as a journalist for many years, I have become increasingly alarmed about the problem of climate change and its negative impacts, so I decided to join the Scottish Green Party as the party that I have seen taking this issue most seriously.” – from web site of The Scottish Green Party quoted by Louise Batchelor who has received the British Environment and Media prize twice for her reporting of environmental issues on BBC Scotland. If today climate change is being made slogan of political campaign, that means it is worth to think about it. Market failure is a theory which arises when the distribution of goods and services by a free market is not Pareto efficient. Market failures are generally linked with failure of competition, public goods, externalities, incomplete markets, information asymmetries and other macroeconomic disequilibrium. (Jozeph Stiglitz, Economics of Public Sector, 3rd ed, p. 77-85) In economic terms externality stems from actions of subject which affect others in positive or negative way. In first case person or organization may impose cost on others but does not reimburse it, whereas the latter may cause benefit to others without reaping all of the benefits of the activity. Models where the actions of individual or the firm injures others is called negative externality, however the opposite is referred to as negative externality. The most obvious patterns include climate change and water pollution. Since the end of XX century world community has been facing serious environmental problems, so economic studies of climate change are juvenile and will develop as we face new policy challenges. Emissions by previous generations which polluted our ecosystem demonstrate damage for contemporary society as well as for posterity. While occasionally used synonymously with “global warming,” the climate change implies a considerable change in a climatic condition which has significant economic, environmental and social effects. It may be restricted to a specific locality, or may happen across the whole globe. Not surprisingly, humankind is in the central figure that causes this. Certainly the world’s environment has always changed owing to natural reasons. But what is going down presently is that man-made aspects are now warming up the world’s climate at a more rapidly pace. This increase of carbon emissions set in motion through the industrial revolution. In pre-industrial era – that is, the time prior to the Industrial Revolution – none of modern technologies – automobiles, aircrafts, plant, phones, TV sets exited. The Industrial Revolution came about when people commenced to mass scale production in industries by means of machinery that worked with energy from coal, and later on using oil, gas, and electrical power. This made it much easier for people to produce goods and facilitated the advancement of new technology. Since Industrial Revolution which started round 1750 and picked up the pace in the 1800s and 1900s, civilization has been using fossil fuels in an intensive way. As a consequence of this actions atmosphere has been polluted with large amount of greenhouse gases. The more society manufactures and devours, the more environment is changed we are surrounded by. Climate change is an unavoidable and important worldwide challenge with enduring effects for the sustainable growth of all states that world society has had to deal with up to present time. The relationship connecting climate change and sustainable growth are strong. Climate change influences roundabouts through some channels such as storms, heatwaves, sea level rise, hurricanes, droughts, and floods – create threats for resources of water, food and agriculture. In its turn these unquestionably living standard of population of developing countries. So, developing countries are expected to get the hardest destruction by climate change. Techniques to tackle climate change necessitate worldwide society’s aims to be completely consistent with for economic and civil progress. This task that go beyond national frames and calls for solutions at the global plane. According to Nicholas Stern, climate change should be regarded as externality, because people who release emission to nature do not compensate for it. As a greatest and widest-ranging market failure, it is a challenge for economists itself. Influence of climate change very expansive and interrelate with other types of market failures, from which additional complicated policy problems stem. Lord Stern states that if world society does not take action, the on the whole, overheads and risks of climate change will be correspondent to losing at least 5% of world GDP continuously. If a broader series of shocks is taken into consideration, the approximation of harm could rise to more than 20% of total output. Let’s see it in examples of sectoral perspectives. (The Economics of Climate Change. The Stern Review. Nicholas Stern. Cabinet Office – HM Treasury, 2006, UK. http://www.webcitation.org/5nCeyEYJr. Retrieved 2010-01-31.) Agriculture is sphere of influence of humankind extremely responsive to climate changes. Forces changing our climate are as well important to farm production. Anthropological actions have already changed atmospheric features such as ozone, rainfall, carbon dioxide level. Although production of food may take advantage of warmer climate, the increased probability of natural disasters like heatwaves, floods and droughts will generate problems for agricultural producers. Actually Paul Krugman’s statement in his article on NY Times shows the trouble with its seriousness: “But the evidence tells a different, much more ominous story. While several factors have contributed to soaring food prices, what really stands out is the extent to which severe weather events have disrupted agricultural production. And these severe weather events are exactly the kind of thing we’d expect to see as rising concentrations of greenhouse gases change our climate – which means that the current food price surge may be just the beginning.” ( http://www.nytimes.com/2011/02/07/opinion/07krugman.html ) Source: “Escalating food prices”, UNICEF February 2011 report. Analyses of the effects of global climate change imply that climate change may lead to significant decline in agricultural output in developing nation states. Nowadays international community is getting more concerned about matters vital to developing countries, such as potential changes in total food availability and world food prices. Among other causes 2007-2008 and recent 2011 food crisis are attributed to climate change. First one, was due to the catastrophe of the most terrible drought in a century in Australia, that is why the 2006 crop summed only 9.8m tonnes. After America, Australia is on average the second leading exporter of grain, and in normal times crop would be about 25 million tonnes. Because of that drought world stock of wheat has reached it lowest possible level since 1979. The drought’s impact on rice has made the greatest shock on the rest of the world, to date. It is one factor causative to bubbling prices which is supposed it is among the initial signs that a warming planet is starting to have an effect on production of food. (http://news.bbc.co.uk/1/hi/world/asia-pacific/7289194.stm) According to Reuters food prices have increased by 11.7% in 11 months of 2010 while the general price level (inflation) has upsurged only by 1.9%. This fact indicates a severe difference and obliges preventative measures to impede food crisis founding starving nations. The caution for food crisis in Sri Lanka was issued due to the bad weather condition occurred during the first few weeks of 2011 which caused massive floods in eastern, northern and north central regions of Sri Lanka where the extensive crop growing were taking place. More than 50% season harvest was destroyed resulting in 21% of the rice cultivation of Sri Lanka being destroyed. And the irrigation system of the country is damaged making it unworkable to do forthcoming season cultivation which will promote reduction of the rice cultivation in the future. Apart from that vegetable prices have gone up by more than 200% as a result of floods and the live stock of 240,000 were destroyed which will again result in high price of meat, milk and eggs. And Meteorological Department of Sri Lanka predicts for a drought period towards the mid 2011 which will once more upshot in damage of crops and make people starve again. (http://www.tutebox.com/business/economics/what-is-foodflation/) Africa responds especially badly to climate change given that it is principally agrarian, suffers an undesirable price shock to its exports, has a low capacity to regulate agricultural portfolios, and has a low elasticity of substitution between domestic and imported cereals. The orientation in the direction of cereal self-reliance averts the economy from taking benefit of lower world cereal prices by changing expenditure towards imported cereals. The remarkable raise in cereal imports in Asia and Latin America leads to a high demand for foreign currency. Balance of trade stability is realized by currency devaluation, by 3.5% in Asia and 1% in Latin America. Real exchange appreciation lessens openness of African economy. There is a 5% appreciation of the currency in response to a complex of changes, but primarily due to a large decline in demand for imports. The cereal sector yield shock of -17% cannot be compensated by an increase in cereal imports. In response, the domestic price of cereals rises which induces resource reallocation towards cereal production. Import demand for cereals and industrial goods declines, since real incomes of all households decrease, leading to a lower demand for foreign exchange. The supply of foreign currency falls as export crop production decreases both because productivity falls and in order to allow a shift towards cereal production. The depreciating effect from lower supply of foreign currency is overwhelmed by the significant decrease in industrial imports, which are much larger in value terms than export crops, causing a net appreciation. (Economic and Welfare Impacts of Climate Change on Developing Countries by Paul Winters et al.) Some restricted views claim that climate change will not greatly affect other sectors than agriculture. But according to well constructed climate-economy models, which go beyond above, environmental changes have great influence on other spheres of economy as well. More broadly still, climatic effects may extend to health, crime, conflict, and migration, all of which could have first-order implications for measuring the policy response. (http://wallstreetpit.com/23481-what-are-the-likely-economic-effects-of-climate-change) Dell et al. 2008, find that warming has historically had negative impacts on economic growth – but only in poor countries. The effects in poor countries are remarkably large – with a 1 degree Celsius rise in temperature reducing economic growth by about 1.1 percentage points. Looking underneath national growth, the study also finds large effects on both agriculture and industrial value added, in addition to effects on aggregate investment, political stability, and innovation. Furthermore, study of historical data relating national weather variation to export performance. The findings confirm large negative impacts of temperature on poor countries. On average, we find that a poor country being 1 degree Celsius warmer in a given year reduces the growth of that country’s exports by between 2.0 and 5.7 percentage points in that year. As in Dell et al. (2008), we find no effect on rich countries’ exports. The fact that exports are even more sensitive to temperature than overall GDP is consistent with the idea that domestic consumption is relatively steady, so that volatility in domestic production translates into greater volatility in net exports. (Dell, Melissa, Benjamin F Jones, and Benjamin A Olken (2008), “Climate Shocks and Economic Growth: Evidence from the Last Half Century,” NBER Working Paper 14132.)
Please read the following questions and answer them IN DEPTH, , MACROECONOMICS.
Please read the following questions and answer them IN DEPTH, , MACROECONOMICS..
1. (Shifts in the PPF) Do you think the September 11, 2001 attacks on the World Trade Center and the Pentagon affected short and/or long-term productivity in the United States? (Answers may vary)2. (Technological Change and Unemployment) What are some examples, other than those given in the chapter, of technological change that has caused unemployment? And what are some examples of new technologies that have created jobs? How do you think you might measure the net impact of technological change on overall employment and GDP in the United States?3. (Productivity) As discussed in the text, per capita GDP in many developing countries depends on the fertility of land there. However, many richer economies have little land or land of poor quality. How can a country with little land, or unproductive land, become rich?4. (Labor Productivity) What two kinds of changes in the capital stock can improve labor productivity? How can each type be illustrated with a per-worker production function? What determines the slope of the per-worker production function?5. (Output per Capita) Explain how output per capita can grow faster than labor productivity. Is it possible for labor productivity to grow faster than output per capita?6. (Rules of the Game) How do “rules of the game” affect productivity and growth? What types of “rules” should a government set to encourage growth?7. Please go to the Bureau of Labor Statistics (BLS) page on Quarterly Labor Productivity at http://www.bls.gov/news.release/prod2.nr0.htm (Links to an external site.)Links to an external site. to get the latest news release on productivity and costs. Rank the various sectors of the U.S. economy from highest to lowest according to their most recent productivity growth rates. Briefly comment on what you found.8. The BLS compiles international data on manufacturing productivity at http://stats.bls.gov/news.release/prod4.nr0.htm (Links to an external site.)Links to an external site. Please find which nations have enjoyed the mostrapid growth in manufacturing productivity, for the most recent period. Which nations have experienced the slowest growth? Has productivity actually declined anywhere? (Answers may vary)9. Why do economists care about the long term trend or growth in the economy? Why is growth important? Briefly discuss.10. What is the link between better education and a strong economic growth? Briefly discuss.11. (MPC and MPS) If consumption increases by $12 billion when real disposable income increases by $15 billion, what is the value of the MPC? What is the relationship between the MPC and the MPS? If the MPC increases, what must happen to the MPS? How is the MPC related to the consumption function? How is the MPS related to the saving function?12. (Government Spending) How do changes in disposable income affect government purchases and the government purchase function? How do changes in net taxes affect the consumption function?13. (Net Exports) What factors are assumed constant along the net export function? What would be the impact on net exports of a change in real disposable income?14. Expectations and consumer confidence are important in determining fluctuations in aggregate spending. In your opinion, what is the present status of consumer confidence? Do you think consumers are pessimistic or optimistic? Briefly discuss.15. (Consumption Function) How would an increase in each of the following affect the consumption function? How would it affect the saving function?a. Autonomous net taxesb. The interest ratec. Consumer optimism or confidenced. The price level16. According to the life-cycle hypothesis, what is the typical pattern of saving for an individual over his or her lifetime? What impact does this behavior have on an individual’s lifetime consumption pattern? What impact does the behavior have on the saving rate in the overall economy?17. (Non-income Determinants of Investment) What are some factors assumed to be constant along the autonomous investment function? What kinds of changes in each factor could cause investment spending to increase at each level of real disposable income?18. What factors affect export and import? Briefly discuss.19. Why would the following investment expenditures increase as the interest rate declines?a. Purchases of a new plant and equipmentb. Construction of new housing20. (Aggregate Expenditure) What are the components of aggregate expenditure? In the model developed in this chapter, which components vary with changes in the level of real GDP? What determines the slope of the aggregate expenditure line?21. In 1-2 Paragraphs: It is no secret that U.S. labor productivity accelerated in the second half of the 1990s. The bulk of the spurt can be traced to the boom in investment information technology capital and to the growth in the information technology-producing part of the economy. Measurement issues abound and having better data would help resolve them. Whether or not the change in productivity is cyclical or structural is too soon to tell. Do you think that US economy will experience higher labor productivity soon? Briefly Discuss.
Please read the following questions and answer them IN DEPTH, , MACROECONOMICS.
Essay Writing at Online Custom Essay
Review This Service