Get help from the best in academic writing.

Database Management SQL Statement Discussion Board Response

Database Management SQL Statement Discussion Board Response.

I’ve provided 2 discussions about SQL statements that need to be responded.1-)PatientPk Pat_IDPat_FirstPat_LastAdm_DateAdm_TimeFk NU_LocPat_DOBDisc_TimeDisc_Date
I’ve chosen the Create View statement for my post.
CREATE VIEW V_Admissions AS SELECT Pat_First Pat_Last Adm_Date Adm_Time FROM Patient WHERE NU_Loc=’West-wing’; 2-)Select one of the following SQL statements. You need to identify the statement and the syntax. Provide an example of the SQL statement using a table and attributes from the database, you are designing for your data management project.
Select with Where clause
Find medication with quantities less than 3
SELECT Med_Name, Med_Qty FROM Medication WHERE Med_Qty <3;
Find medication Amoxicillin or Penicillin with medication date of 02/01/2019.
SELECT Med_Name, Med_Date FROM Medication; WHERE (Med_Name LIKE ‘%Amoxicillin’ OR Med_Name LIKE ‘%Penicillin’) AND Med_Date = 02/01/2019;
Database Management SQL Statement Discussion Board Response

annotate 2 sources for my annotated bibliography. my question is why should college athletes be paid?.

I need 2 sources that are against college athletes getting paid.Complete 2 sources Each source should have a bibliographic citation and 2 paragraphs. one of the paragraphs need to be explaining the thesis and main supporting points of the source, as well as its purpose audience. the other paragraph needs to have a description of the sources credentials and an evaluation of the sources quality and relevance. include its potential contribution of the source to my research project, its best evidence, and how it relates to the other sources.Follow MLA formatting.
annotate 2 sources for my annotated bibliography. my question is why should college athletes be paid?

In this assignment, I will conduct an ethical analysis of companies partaking in random mandatory employee drug testing within the workplace. To support my findings, I will refer to both non-consequentialist and consequentialist theories which will enable me to put forward a non-bias argument both for and against this action. For the purposes of this report my primary focus will be on the non- consequential theory with particular reference to Deontology. To support my analysis, I will refer to multiple perspectives such as; political, economic and sociological. These tools will enable me to identify the moral fundamentals of random drug testing within the work place and to create a non-biased argument within in my findings as well as expressing my opinion to a degree. In relation to a non-consequential theory the consequences of an action are not the primary focus of the ethical justification. Instead the focus is solely on the impact of the actions carried out and whether the actions are deemed to be ethical right or wrong. In relation to drug testing within the work place this action is ethically right. As per the SAFETY, HEALTH AND WELFARE AT WORK ACT 2005, employers hold a level of responsibility of the health and safety of their employees. Within this act it states that employers have the responsibility to ensure the employees are not under the influence of an intoxicant to the extent that he or she is in such a state as to endanger his or her own safety, health or welfare at work or that of any other person. If this is deemed the case employers should action drug testing accordingly. In my opinion random drug testing is an important part of an ethical working environment to ensure health and safety regulations are kept inline and thus providing a safe working environment for their employees. (SAFETY, HEALTH AND WELFARE AT WORK ACT 2005, 2005). CAUSE OF DEATHS PrescriptionDrugs Street DrugsCombined: 39% 45% (Amphetamine Heroin Methamphetamine Cocaine) (Foundation for a Drug-Free World, 2017) The Deontology theory is the study of duty and obligations. This theory considers that some acts are right or wrong independent of their consequences. In the good will section of Kant deontology the focus is on the action rather than the consequences. By introducing random drug testing within an organisation, the employer can sanction random drug testing at any time. This theory which was later revised by the scholar Immanuel Kant offers significant ethical guidance when making a decision. Kant believed that morality is a key component when a decision is being made. A “moral maxim must be disconnected from the particular physical details surrounding its proposition and should be applicable to any rational being.” (,2017) Regarding the random drug testing within the work place in this instance, despite the action impeding privacy of a company’s employees, the employer has a duty of care to provide a safe working environment for their employees and therefore this action is deemed ethical correct. This will ensure all staff are safe in their workplace that they will not be under the influence of any substances that may endanger themselves or their work colleagues. Deontology theory is all about the action rather than the consequence, when practising this theory, the following questions must be addressed and implemented along with the actions. The focus of the theory is that one action is determined by weather or not the answer to the following questions are ethically correct or incorrect. What should I do? Why should I do it? (Ridge, 2017) The political perspectives in this instance refer to the statue laws/ law of the land that are in place to protect people so that they are safe and well. This is a guide that companies must obey if they wish to set up in the country of choice. The idea behind drug testing would be that they wore aiming to make a safe work place for both employees and employers. Drug use is not a reflection of drug use in the work place because of your job it’s a reflection on drugs in society. A true drug user won’t leave their drug usage at the door and say I won’t do that inside my job they will do it either way. (Fay, 2010) As mentioned above drug use and drug addiction may refer to prescription drugs also. In recent years, the number of deaths and instances involving prescription drugs has been on the rise within this society. don’t show up on some drug tests as they are legal and prescribed to a person. More people die from prescription drugs than what die from illegal drugs. Per the foundation of a drug free world, 45% of deaths are caused by legal drugs whilst 39% of deaths are relative to illegal street drugs. This shows that it isn’t only street drugs we need to be testing but also all the drugs available. This statistic also steers people away from the general stigma associated with drug addiction and street drugs. As legal drugs, may be prescribed to a person from their doctor. In this cases this opens many doors for not only indication to prescribed medication but also to illegal distribution of these prescribed substances. This I believe is another reason why drug testing in the working place is ethically the right action to take, not only to support a healthy and safe working environment but also to ensure staff are in a good place and offer help and guidance for people who are suffering once the problem has been identified. On the other scale of events some people need these types of tablets to function due to injury. This should all be considered when the drug testing is being done. That no adverse judgements are made on the employee. It is also important that when this is being done that prior to test employee gives full disclosure if none already given so it is expected to fail or so on. Sociology perspectives within mandatory drug testing in employees comes as a sharp rise in drug use in modern day society. This is down the easy availability of drugs on our life’s you can get over the counter drugs and street drugs. Because of this many companies are bringing in enforcements at the work place like drug testing and dismissal for breach of contracts which I believe to be the correct option for companies going forward. A consequential theory refers to a situation whereby the consequences of the actions are taking into consideration when an act is determined to be ethical right or wrong. This theory type focuses on actions rather than the consequences of those said actions. Once the consequences are assessed and justified it can then be actioned accordingly. Consequentialism ensures that the consequences are considered before an action is decided upon. Whilst briefly assessing the Utilitarianism model it conveyed that considering the consequences of random drug testing may cause some negative moral and feedback within the organisation from employees. This is a result of the action of these random tests invading employee privacy whilst hindering the company’s fidelity agreement with their employees. In my opinion drug testing doesn’t invade people’s privacy it focuses on the protection of the people from others who may be on drugs or addicted to drugs to help them deal with a certain type of strain in their life. Fidelity agreement between employee and employer. It is about the duty and good faith between employee. This is an underlying term in your contract that says employee must be faithful and honest it’s the fidelity agreement that is about duty the employee must its employer. In this agreement, it shows that you can be trustworthy person and what you say you are is what you are. Even though this agreement may be effected and deemed void once mandatory drug testing occurs, based on the deontology no consequential theory and my findings listed above this is the action which is ethical correct. Conclusion In this report, I have assessed the ethical nature of mandatory drug testing in the work place and weather it should or should not be carried out. Within my assessment above I have put forward both for an against arguments as to whether introducing random mandatory drug tests to the work place is ethically correct or incorrect. Throughout this report my primary focus was on the ethical value of introducing these checks in the work place. To support my findings, I focused on the non-consequential theory- Deontology. This theory focuses on the action rather than the consequences. Even though the consequences refer to the invasion of employee privacy and the breech of their fidelity agreement based on my chosen theory this is not important. In my opinion the action should be implemented to provide a safe working environment for employees per regulatory legislation and to provide a duty of care to those who work within the organisation. Unless they don’t do drugs and leave the problem at the gate they will end up bringing this into the workplace and end up bringing an unstable working environment for all other employees. The number one concern for employers is to make sure that a safe working environment is provided always. Bibliography Ridge, K. (2017). Ethic ideas and action. Ridge, K. (2017). Ethic ideas and action. Foundation for a Drug-Free World. (2017). Watch Truth About Drugs Documentary Video
Experts Urge Hospitals Systems to Trade in Traditional Budgeting Process Discussion.

An independent family clinic located in a poor neighborhood struggles to reach its breakeven point each month. At their current visit levels, they need to collect an average of $100 per patient visit in order to breakeven each month. They have asked for your consultation on some options that could help them remain profitable and not have to shut down, even if they have tough decisions to make. What advice would you offer them? Reference the Flexing Your Budget article as part of your response, in addition to at least one other literature/article.
Experts Urge Hospitals Systems to Trade in Traditional Budgeting Process Discussion

Delta State University Psychosocial Theory and Diverse Groups Discussion

Delta State University Psychosocial Theory and Diverse Groups Discussion.

** Social Work Theory Discussion: Psychosocial Theory and Diverse GroupsThere will be times when a social worker is presented with a case where they are not familiar with the surrounding psychosocial issues. Because social workers are on a continual journey in learning, it is important to read pertinent literature. This Discussion provides an opportunity to visit Walden Library and strengthen your skills in identifying and locating an empirical research article.To prepare:Select one of these three groups: (1) an immigrant individual from a racial or ethnic minority group, (2) a gay, lesbian, bisexual, or transgender (LGBT) individual, OR (3) an individual who is physically disabled.Review the Walden Library resources listed in the Learning Resources.Then conduct a library search for an empirical study focused on one of the groups above and the unique psychosocial factors or issues a social worker should be aware of when working with that group.By Day 3Post:Post the APA-style reference for the article you found in the library.Describe four specific psychosocial factors that should be taken into account in order to understand the psychosocial context when working with the group you selected. (Two of these factors should be psychologically related and two of these factors should be socially related).Identify and explain a psychosocial intervention that addresses one of the four specific psychosocial factors you described above.Identify 1 to 2 outcomes you might measure if you were to evaluate the effectiveness of the intervention.Evaluate one advantage of using a psychosocial framework in social work practice with the group you chose.**Social Work Theory Assignment: Application of Role Theory to a Case StudyThis week, you will use role theory to apply to your chosen case study. In other words, your theoretical orientation—or lens—is role theory as you analyze the case study.Use the same case study that you chose in Week 2. (Remember, you will be using this same case study throughout the entire course). Use the “Dissecting a Theory and Its Application to a Case Study” worksheet to help you dissect the theory. You do not need to submit this handout. It is a tool for you to use to dissect the theory, and then you can employ the information in the table to complete your assignment.To prepare:Review and focus on the same case study that you used in Week 2.Review the websites and guides for developing PowerPoint skills found in the Learning Resources.Use Personal Capture to record the PPT slides on your screen and your audio as you present the information. You will then use Kaltura Media to upload this recording to the assignment link.Submit a narrated PowerPoint presentation using Kaltura Media that includes 11 to 12 slides.Each slide should be written using bullet points, meaning no long paragraphs of written text should be in the slides.The recorded audio takes the place of any written paragraphs, while the bullet points provide context and cues for the audience to follow along).Your presentation should address the following:Identify the presenting problem for the case study you selected. (Remember the presenting problem has to be framed from the perspective of role theory. For example, the presenting problem can be framed within the context of role functioning).Identify all the relevant roles assumed by the client.Analyze the social expectations and social and cultural norms revolving around the role, social position, and role scripts of one of the roles assumed by the client.Explain the role and social position of the social worker in working with the client in the case study.Describe how the role(s) and social position(s) assumed by the social worker will influence the relationship between the social worker and the client.Identify three assessment questions that are guided by role theory that you will ask the client to better understand the problem.Identify and describe two interventions that are aligned with the presenting problem and role theory.Identify one outcome that you would measure if you were to evaluate one of the interventions you would implement to determine if the intervention is effective.Evaluate one advantage and one limitation in using role theory in understanding the case.Be sure to:Identify and correctly reference the case study you have chosen.Use literature to support your claims.Use APA formatting and style.Include the reference list on the last slide.**Advanced Clinical Discussion 1: Attachment TheoryThe adolescent stage can be described as a time where there is a loss of innocence and a preentry into adulthood. A large part of being an adolescent is beginning that process of stepping out into the world and learning about oneself as a unique and autonomous individual. This movement out into the world is contingent upon the knowledge that this young person will have a safe and secure home to return to at the end of the day. If a traumatic loss or event has occurred in the adolescent’s life, there may be no safe base to which this individual can return. Attachment theory teaches us that a young person’s ability to attach/engage with peers, family, and other potential support systems is an important aspect of the developmental process. During the adolescent stage of development, assessing attachment styles is important because it provides a window into how the adolescent relates to others, which allows the clinician to choose the appropriate intervention.For this Discussion, choose either the program case study for the Bradley family or the course-specific case study for Brady.By Day 3Post an application of the attachment theory to the case of either Tiffani or Brady. Discuss the connection between his or her attachment style and the exhibiting behavior.Support your posts with specific references to this week’s resources. Be sure to provide full APA citations for your references**Advanced Clinical Discussion 2: Developmental StagesUnderstanding an adolescent’s behavior can be at times elusive and even frustrating. Due to the multiple aspects of the developmental tasks during these years, it can be at times quite challenging to clearly define the issue(s) at hand. Assessment during this stage will include an evaluation of whether an adolescent’s actions are indicative of unhealthy behavior or merely representative of being an adolescent. A comprehensive assessment that includes an evaluation of the client’s developmental stage is a priority when working with this age group.For this Discussion, choose the opposite case from Discussion 1 and use Erikson’s developmental theory.By Day 4Post an assessment of whether the client is mastering the stage of identity. Identify the areas that should be addressed in an intervention based on his or her developmental stage. Describe how you might address those areas.Support your posts with specific references to this week’s resources. Be sure to provide full APA citations for your references.By Day 6Respond to at least two colleagues who identified a different case and provide feedback on the client’s stage of development. Identify another area that should be addressed, based on developmental stage.Support your responses with specific references to this week’s resources. Be sure to provide full APA citations for your references.
Delta State University Psychosocial Theory and Diverse Groups Discussion

SOC 120 UCLA Globalization & Sociology The Global Economy Discussion

essay writing service free SOC 120 UCLA Globalization & Sociology The Global Economy Discussion.

Format: 12pt font, Times New Roman, 2 pages Single SpacedNOT DOUBLE SPACEDHello, I need help with my weekly reflection for Sociology. I will provide you with (1) Powerpoint which is split into 2 pdfs, (2) the readings which is 1 article, 1 book (ignore chapter 2 & 6 pls), (3) and a link to the documentary. The reflection is not an essay with an intro, body, and conclusion, but rather just shows the understanding of this weeks material and develop an analytical perspective on it. It is encouraged to use quotes from both the readings and Powerpoint. Down below I will attach the syllabus instructions for the weekly and the “Orientating Question” that was emailed to us after the lecture to help guide our reflection. THANK YOU._______________________________________________________________________________________MUST ANSWER THE QUESTION IN REFLECTIONSDear students, Here is your orienting question for this week’s reflection. Remember that the question is just a jumping off point for those who feel they need one. Tonight’s theme was the global economy. Discuss how the PowerPoint and also the class discussion helped make sense of the terms, concepts, and theories put forward in the readings. What do you now understand by “the global economy”? You are not required this week to talk about documentaries; Marti Gras, Made in China, but you are welcome to discuss it again in relation to this week’s readings. Your professor_________________________________________________________________________________________Read these guidelines carefully. Each week, on 8 occasions, you will prepare a reflection essay of approximately 2-3 pages (single-spaced). You are of course free to write more than the minimum required. These are not academic papers in which you need an introduction, hypothesis, conclusion, etc. They are reflections and you may use a more informal style, even stream of consciousness prose. Please note: there are two criteria we will use in grading these assignments:Does your reflection demonstrate that you have participated in and paid attention to the lecture/powerpoint, done the readings, and engaged with the documentary?Have you developed analytical discussion, including bringing in the terms, concepts, and theories that we discuss in the lecture and are in the readings? Have you shown how the three (lectures, readings, documentaries) are related to one another, and have you identified and discussed the underlying theme(s) that run through all three? In addition, I will generally send out an email shortly after class with several orienting questions that you should respond to in the context of your reflection. We will be looking very carefully to see how you respond to these orienting questions, especially with regard to the readings.Note that these reflections should not be a summary of the lecture, readings, and documentary, and nor should they be a question and answer format. Avoid mere description. The purpose is three-fold: 1) that you demonstrate you have attended the lectures done the readings, watched the documentaries, and given thought to them; 2) to identify what you did not understand and what you think is important to discuss in class, in relation to the course, and; 3) this is crucial, that you are able to synthesize the three (lecture, readings, documentary) to develop a meaningful analytical discussion on the topic of the week.As you write these reflections, you should use the sociological concepts and terms you have acquired in the course and through the readings. We will be looking for this as we grade.
SOC 120 UCLA Globalization & Sociology The Global Economy Discussion

Apple and Samsung Companies: HR Practices Essay

Table of Contents Introduction Comparing and Contrasting Apple and Samsung Electronics Conclusion References Introduction Successful companies implement effective strategies and policies to support their business models. At the heart of every organization’s performance, there is a successful human resource (HR) process (Hamid, Maheen, Cheem,

Read the following two case studies and answer the questions that follow: CASE STUDY #1 Chen is cooking dinner

Read the following two case studies and answer the questions that follow: CASE STUDY #1 Chen is cooking dinner for his family. He moves to pull a pot off the stove and accidently touches the burner. Reflexively he pulls his finger away from the stove and immediately feels the pain. 1. What is the role of the brain and spinal cord in this response? 2. Describe the three types of neurons involved in this response and their role in the reflex arc. Explain the withdrawal reflex that results in Chen moving his hand away from the stove. 3. Evolutionarily, why do you think the human body has this system in place? Why is this reflex important? 4. Chen’s wife, Amira, was born with congenital insensitivity to pain, a condition that inhibits the ability to perceive physical pain. Find a reliable source related to congenital insensitivity to pain and address the following questions: a. What is congenital insensitivity to pain? b. What are some of the signs and symptoms of this condition? c. In this week’s reading, you learned about the role of sodium ions in the conduction of nerve impulses. Individuals with congenital insensitivity to pain are unable to make a sodium channel called NaVi.7. How is this related to the signs and symptoms of the disease? d. What might happen if Amira had touched the burner? How would her response be different than Chen’s? e.What advice would you give to a child who has this condition and is interested in playing contact sports? What would happen if this child experienced a fracture? CASE STUDY #2 Monica just celebrated her 30th birthday. During her annual physical exam, Monica mentions symptoms she has been experiencing over the last few months. These symptoms include blurred vision, numbness in her fingers and face, dizziness, fatigue, weakness, and depression. Although Monica believes that these symptoms are related to stress and aging, her physician is concerned and suspects that Monica may have multiple sclerosis (MS). 1. What is MS? 2. What is the main cell structure affected in MS? What is the role of this structure? 3. How does the impact of MS on this cell structure help to explain Monica’s symptoms? Include an explanation of how the action potential of a neuron is affected in MS. What is the treatment for multiple sclerosis? What is the mechanism of action of the treatment? 4. The origin or etiology of MS is not clear. Find a reliable source related to the etiology of multiple sclerosis. Based on your research, what do scientists hypothesize to be the causes of MS? Include the appropriate reference and citation for the source you consulted.