please answer this question

  

Radisson Blue Hotels stores information about their hotels in different countries. Every hotel is identified by hotel id, hotel name, hotel address, city and URL. Every country is identified by country code, country name and country currency. Guests staying in the hotel is identified by guest number, guest name, guest address and guest city. Every room in the hotel is identified by room number, and room floor. Every room booking is identified by booking id, starting date, and ending date. There are different types of rooms in the hotel. Each room type is identified by room type code, room standard rate, and description. In each country, there may be no hotels or more than one hotel. A hotel may have one or more rooms. A guest can book one or more rooms and a room may be booked by one or more guests. A hotel may have one or more bookings and each booking is associated with exactly one hotel. Each room type may have one or more rooms and a room belongs to one room type. 

1) Write the schema of the appropriate relations for the above scenario. Identify the primary key and the foreign key in each of the relations. 

How did you identify the primary key and foreign key? Explain.   

2) Use the designed relations to write SQL statements for the following questions:  –   Explain the working of each query in detail.

a. Display all the rooms having the same rate in the ascending order of room rate.   

b. List the number of hotels in each country. Only include countries with more than 4 hotels.   

 

c. Display the details of hotels that is not yet included in any booking. 

d. Display all the details of guests who booked hotels on ‘2021-05-01’. 

e. Display the room number, room standard rate and the hotel id. 

f. Display the details of countries with country name starting with letters other than any letter within ‘A’ and ‘P’.  

In an essay of at least THREE paragraphs or more.

 

Assignment Content

  1. https://www.ted.com/talks/amy_cuddy_your_body_language_shapes_who_you_are

    View the provided video and think back to a busy social area such as; train station, JAG café, restaurant, or classroom and recall your observations of the people who were engaged in communication. Write down as many nonverbal codes as you can identify; be sure to explain the code with a specific example.

    In an essay of at least THREE paragraphs (at least 5 sentences per paragraph) evaluate what the nonverbal codes tell you about the individuals, their relationship, context, culture, and communication events.

    Requirements:
    Times New Roman Font, 12 points
    Double Spaced

Here is the Chapter 4 of Non-verbal

Nonverbal communication is all the ways people transmit messages through means other than words. What you “physically” say with your words and what you “symbolically” say without words work together to create meaning. So when you talk to your next door neighbor or the person sitting next to you on the bus and smile, move closer to, shake hands, or roll your eyes influences how he or she  interprets your message. 

Like language, nonverbal communication is also related to culture and gender. The meaning of any nonverbal behavior is defined by the cultures of the speaker and receiver. Miscommunication can occur when nonverbal gestures are misunderstood or have another meaning in a different culture. (See video on hand gestures)

Nonverbal communication conveys cultural meanings of gender. Men and women use nonverbal communication to express themselves as gendered. Functions of nonverbal communication include supplementing spoken language, regulating interaction, and conveying relationship level meaning. Nonverbal communication may supplement verbal communication by: repeating words, contradicting a verbal message, complementing verbal statements, replacing language, accenting verbal message by emphasizing certain words. Nonverbal cues may also regulate interaction through behaviors like eye contact and body posture. Women tend to use cues to invite and encourage others into conversations. Men tend to use more cues to maintain attention and discourage others from speaking. 

Nonverbal communication also is the primary conveyance of relationship levels of meaning. Three primary dimensions of relationship level meaning are responsiveness liking and power. Responsiveness conveys interest in the interaction involvement with others. Nonverbal cues indicating responsiveness include nonverbal cues like inflection, eye contact and open body posture. A lack of responsiveness may be indicated through behaviors like looking around, turning away or yawning. Females tend to use nonverbal behaviors to indicate involvement with others and signal empathy. Women also tend to be more overtly expressive of emotions and smile more. Feminine speech communities teach responsiveness to create affiliation. Liking is the nonverbal relationship level meaning that signals whether we like or dislike someone. Nonverbal cues may include display more overt signs of liking and friendliness than men. The power or control dimension of relationship meaning consists of nonverbal cues that display the degree that we act in control of, equal to, or deferential to others. Men tend to incorporate more behaviors that signal dominance and control in conversations through cues such as greater vocal volume, more non-affiliate touch, and use of greater amounts of personal space. 

Differences exist between women and men’s skill for interpreting nonverbal behavior. Generally, females are better able to decode nonverbal behaviors and more accurately perceive others’ emotions. There are cultural values associated with nonverbal communication. Western society has a bias towards favoring masculine qualities, which is indicated through preferences for masculine nonverbal behaviors. Cultural beliefs are changeable. They may be altered as we recognize differences in a nonjudgmental manner and resist restrictive nonverbal gender prescriptions. 

Nonverbal codes are distinct, organized means of expression that consists of symbols and rules for their use.  The five nonverbal codes include: kinesics, paralinguistics, proxemics, haptics, and appearance and artifacts. 

1- Kinesics is nonverbal communication sent by the body, including facial expression, gestures, posture, body movement, and eye behavior. The body movements consist of four types of nonverbal gestures: illustrators, emblems, adaptors, and regulators. Illustrators are signals that accompany speech to clarify/emphasize the message. Emblems are gestures that stand for a specific verbal meaning.  Adaptors are gestures used to manage emotion (often unconscious). Regulators are used to control conversation.  Facial expressions also communicate messages, mostly emotion (think the old saying the “eyes are the window into the soul”).

2- Paralinguistics are the vocal (oral) aspects of nonverbal communication and include voice pitch, rate, volume, inflection, pitch, stress, and pauses.  Male and female physiology doesn’t fully explain differences in pitch.  Men tend to use lower pitch, higher volume, and less inflection to gain and hold attention. Women tend to use softer pitch, lower volume and more inflection to appear polite and caring. One study found that stereotypical perceptions of men and women were related to their vocal qualities.

3- Proxemics is the study of how space can serve as a function of communication. The distance between speaker and receiver symbolizes physical or psychological closeness. There is an acceptable amount of space or distance that people are comfortable with based on their level of intimacy, gender, culture and relationship (see “Close Talker” video). Proxemics or personal space and its use, reflect gendered patterns that reflect society’s values. Space is a primary way that culture indicates privilege and power. Territoriality is personal space that we protect from “invasion” by others. Men are more likely than women to refuse to step back if another steps too close for comfort.

4- Haptics or touch is another aspect of nonverbal communication that is influenced by gender, culture, and level of intimacy. Sons are less likely to be touched and handled than daughters. When touched, sons also are likely to be treated more roughly than daughters. Early childhood relating to touch may account for later differences between men and women. Females are more likely to initiate touches to express support, affection and comfort. Because they are generally larger and stronger than women, men tend to have higher levels of physical confidence and are more willing to use physical force.

5- Artifacts and appearance are personal objects that affect our identity, how we view ourselves, communicate something about ourselves, and develop expectations (especially gendered expectations). Toys demonstrate appropriate behaviors and activities for boys and girls. Clothing another type of artifact, defines women and men differently. A third type of artifact, advertising, reinforces images of women as homemakers or sex-symbols and men as associated with heavy work, sports and outdoor activities. Women are encouraged to be “attractive” through purchase of cosmetics and hair products. Some people use artifacts to challenge cultural prescriptions of masculinity and femininity. 

Understanding nonverbal communication requires an effort to understand respect and appreciate others’ nonverbal communication on their own terms. By recognizing and attempting to understand others’ patterns of nonverbal behaviors, we may increase appreciation for individual differences and less rigidly restrict expectations for nonverbal behaviors. This may also provide a greater range of communicative options. 

Language and Power in Real Life

 

Week 2 Topic 1: Language and Power in Real Life

In this discussion, you will share one of your experiences with language and power and you will examine the experiences of your classmates.

Initial Post (due by 11:59 p.m. on Friday)

Reflect on your experiences with language and power in a personal or professional setting and write 2-3 paragraphs where you:

(1) describe your experience

(2) tell how the experience impacted your perspective on language and power

(3) demonstrate the grammar and writing skills covered in the course so far

Peer Response (due by 11:59 p.m. on Sunday

Respond to at least one of your classmates and comment on her/his experience with language and power. Here are a few things you might consider when writing your response:

  • How are your experiences the same or different?
  • What do you think is the source of any similarities or differences between your and your classmate’s experiences with language and power?
  • What insight have you gained from reading about your classmate’s experience?
  • What insight might you offer your classmate regarding her/his experience?

00

Week 2 Topic 2: Language in the Workplace

In this discussion, you will share your perspective on language in the workplace and you will examine the perspectives of your classmates. Be sure to review the assigned readings before you begin this discussion. 

Assigned Readings:

McWhorter, J. (2012, August 13). Good applicants with bad grammar. New York Times. https://www.nytimes.com/roomfordebate/2012/08/13/is-our-children-learning-enough-grammar-to-get-hired/good-applicants-with-bad-grammar

Rushkoff, D. (2013, January 30). It’s not just grammar: It’s clear thinking. New York Times. https://www.nytimes.com/roomfordebate/2012/08/13/is-our-children-learning-enough-grammar-to-get-hired/its-not-just-grammar-its-clear-thinking

Haussamen, B. (2012, August 13). What good writing indicates, and doesn’t. New York Times. https://www.nytimes.com/roomfordebate/2012/08/13/is-our-children-learning-enough-grammar-to-get-hired/what-good-writing-indicates-and-doesnt

Truss, L. (2012, August 13).The harm when schools play down grammar. New York Times. https://www.nytimes.com/roomfordebate/2012/08/13/is-our-children-learning-enough-grammar-to-get-hired/the-harm-when-schools-play-down-grammar

Challenger, J. (2012, August 13). Consider the candidate and the position. New York Times. https://www.nytimes.com/roomfordebate/2012/08/13/is-our-children-learning-enough-grammar-to-get-hired/consider-the-candidate-and-the-position

Initial Post (due by 11:59 p.m. on Friday)

Reflect on the assigned readings listed above for this week and the debate around grammar and professionalism. Then, write 2-3 paragraphs where you:

(1) identify the reading selection that most resonated with you and why

(2) outline and justify your perspective on whether grammar should play a role in hiring and other professional decisions

(3) explain how your core values affect your perspective on language and power

(4) demonstrate proper verb tense and subject-verb agreement, along with the other grammar and writing skills covered so far in the course

Peer Response (due by 11:59 p.m. on Sunday)

Respond to at least one of your classmates whose perspective is different from your own. Here are a few things you might consider when writing your response:

  • How are your perspectives different?
  • What do you think is the source of the differences between your and your classmate’s perspectives on grammar and professionalism?
  • What insight have you gained from reading about your classmate’s perspective?
  • What insight might you offer your classmate regarding her/his perspective?

Cultural Humility

 Prepare a paper between 9-10 pages that addresses the following parts.Part 1. Watch and take detailed notes on the following two videos:1.   Cultural Humility: People, Principles and Practices a 30 minute documentary by San Francisco State professor Vivian Chavez, that makes his poetry with music, interviews, archival footage, and images of community. https://www.youtube.com/watch?v=SaSHLbS1V4w2.   The Importance of Cultural Humility – Produced in conjunction with the University of Buffalo School of Social Work Institute for Sustainable Global Engagement by Sarah Richards-Desai, MSW and Dr. Laura Lewis. This video defines the concept of cultural humility and highlights related components. Cultural humility is defined as an ongoing process of self- reflection and self-critique. It entails working collaboratively with clients, and embracing difference. Students, faculty and practitioners reflect on the role of cultural humility in their work and share their insights. https://www.youtube.com/watch?v=cVmOXVIF8wc&feature=youtu.bePart 2 – Describing Cultural Humility- Provide answers to the following questions based on the videos (2-3 pages):1.   One theme is a contrast between cultural competence and cultural humility. In your own words, describe cultural competence and cultural humility and describe how you see them relating to one another.2.   Describe how personal narrative and self-reflection are beneficial in developing cultural humility.3.   Highlight the role cultural humility plays in social work practice.Part 3 – Reflecting on Cultural Humility – Provide answers to the following questions based on the videos (5 pages):1.   How do you react to the idea of continually learning about your clients’ backgrounds and the systemic factors that oppress populations? 2.   How is this reflected in social work professional development?3.   There are different voices and experiences represented in the videos. Which phrases or thoughts stood out to you?4.   Is there anything you would say reflects your own ideas? What do you disagree with?5.   Describe a scenario in which you (or someone that you know) experienced cultural humility (or lack thereof) in an interpersonal exchange. Consider the cultural context in which this occurred, and reflect on and evaluate your response.Part 4 – Action Steps toward Cultural Humility. Provide answers to the following questions grounded in your own personal or professional experiences (2 pages):1.   Describe the types of actions or competencies reveal cultural humility to you?2.   Describe three ways that you can recognize and develop cultural humility social work practice. 

Rob Parson Case Study – Intro to Morgan Stanley / Problems

WRITE A 2 1/2 TO 3 PAGE PAPER ABOUT (INTRO) TO MORGAN STANLEY IN REGARDS TO THE ROB PARSON’S CASE STUDY & THE PROBLEMS WITH THE CASE.  ALL THE NOTES ARE BELOW AND NEED TO BE MADE INTO PAPER FORMAT APA (2 1/2 TO 3 PAGES).  ATTACHED IS THE CASE STUDY; BUT ONLY WANT THE PAPER BASE ON THE INTRO (ABOUT MORGAN STANLEY) AND THE PROBLEMS LISTED BELOW.  AGAIN LOOK AT THE NOTES BELOW AND ADD TO IT IF NEED BE!  NO PLAGIARISM.  THANK YOU.  

Intro to Morgan Stanley

 –summary

Morgan Stanley is an American multinational financial services corporation headquartered in the Morgan Stanley Building, Midtown Manhattan, New York City. Morgan Stanley operates in more than 42 countries and has more 60,000 employees.  Morgan Stanley is a global leader in executing transactions in cash equity and equity-related products for institutional clients around the world; to include stocks, global depository receipts and exchange-traded funds.  Morgan Stanley is differentiated by the caliber of our diverse team. Their culture of access and inclusion has built our legacy and shapes our future, helping to strengthen our business and bring value to clients.  Their firm’s commitment to sustainability informs our operations, governance, risk management, diversity efforts, philanthropy and research.  

-vision

“One-Firm Firm”

 –culture

DO THE RIGHT THING

Act with integrity

Think like an owner to create long-term shareholder value

Value and reward honesty and character

PUT CLIENTS FIRST 

Keep the client’s interests first

Work with colleagues to deliver the best of the Firm to every client

Listen to what the client is saying and needs

LEAD WITH EXCEPTIONAL IDEAS 

Win by breaking new ground

Leverage different perspectives to gain new insight

Drive innovation

Be vigilant about what we can do better

COMMIT TO DIVERSITY & INCLUSION 

Value individual and cultural differences as a defining strength

Champion an environment where all employees feel a sense of belonging—are heard, seen and respected

Expect everyone to challenge behavior counter to our culture of inclusion

Attract, develop and retain talent reflecting the full diversity of society

GIVE BACK

Serve our communities generously with our expertise, time and money

Build a better firm for the future by contributing to our culture

Develop our talent through mentoring and sponsorship

mission/goals

Our goal is to be the world’s best investment bank and the Firm of choice for our clients, our people, and our shareholders. 

We will succeed by meeting the global needs of our clients-both providers and users of capital-at a level of performance which is exceptional. This commitment to add maximum value will be characterized by extraordinary effort and innovation, and by conducting ourselves with absolute integrity. 

Morgan Stanley’s people are the source of our competitive advantage. We will distinguish ourselves by creating an environment that fosters teamwork and innovation, by developing and utilizing our employees’ abilities to the fullest, and by treating each other with dignity and respect. 

Closing of the intro to Morgan Stanley:

The mission statement, and the “one firm” vision were intended to reorient the firm towards 

an increasingly complex, fast-paced, global industry. The Morgan Stanley leadership recognized that clients interacted with the firm at many different points of intersection. It was important, from a business perspective, to provide a unified face to the customers and also to have mechanisms in place to effectively coordinate work across the firm. 

Problems:

Paul Nasr has promised a promotion to Rob Parson from capital services to managing director when he recruited him to Morgan Stanley.

Rob Parsons was not complying with the culture of Morgan Stanley and had violated some of the norms set by Morgan Stanley when it comes to adapting to the work environment.

Paul Nasr has not been giving Rob Parson the feedback that was needed at the right time.  

Assignment 1: LASA 2: Prisoner Data Analysis

As part of the criminal justice process, corrections play a very important role for society and public policy. You will become familiar with the trends in local, state, and federal prison populations for the period of 2000–2008. If you desire a career in corrections, you will gain knowledge to help you be better prepared when entering into the corrections workplace. If you are not opting corrections as a career, you will still gain a foundational knowledge of the data used to drive policy decisions in this critical criminal justice entity.

You have been selected for the position of deputy director of public safety and corrections for your state. Your first duty is to prepare for your first top-level meeting with department personnel. Using the data from Prisoners in 2008, (Cooper, Sabol, & West, 2009), you will produce a 10-page paper (title page, abstract, 7 pages of content, and a references page) that summarizes the article and explains how this data influences the decision making for the prison population that you will experience in your new role as deputy director of your state’s Department of Public Safety and Corrections.

Instructions:

  • Synthesize what you have learned from the charts, graphs, and article content about local, state, and federal prisoners from 2000 to 2008.
  • Discuss admissions and releases and the percentage of change from 2000 to 2008 in state and federal prisons by race, sex, and type of release—conditional versus unconditional.
  • Compare the observable trends in adult corrections from 2000 to 2008 in each region—the Northeast, Midwest, South, and West—and for the United States as a whole.
  • Identify and explain the variations between regional data for adult corrections in the Northeast, Midwest, South, and West from 2000 to 2008.
  • Explain the implications of the data from 2000 to 2008 and how this data will influence your decisions for the prison population in your new role as deputy director of your state’s Department of Public Safety and Corrections.

Reference:

Cooper, M., Sabol, W. J., & West, H. C. (2009). Prisoners in 2008. Retrieved from http://bjs.ojp.usdoj.gov/index.cfm?ty=pbdetail&iid=1763

respond to question

 

Internal Promotion

I often hear so much about seniority should be consider first. I do believe at a certain extent yes, but if you are not qualified for the job, then no. There were many times I have seen or heard people complain but was not qualified nor have the knowledge of the position and feel that they should get the job. I feel if you know there is a job becoming available get to know the job, learn what the job is about, then apply yourself. Do not get mad if you are not chosen the first go around. I suggest getting with the hiring team and see what areas where you weak in and if you need more help in that certain area, do your research, and try again.

The solution is for my interview team to get together and discuss details that is needed to show proof that I have the skills to perform the job that is available. I will give my best presentation to show that I am the best candidate for the position and will go above and beyond to show what I can do the job.  I will give them a summary of my background and work experience. I feel any extra training always a plus that the company has to offer. As always you must dress to impress and show them that you came to work.

As for as call to action, I will thank them for their time they took out to interview me. I will do a follow-up call or send a letter/cards within the next day or so to get updated information on the job or have they hired anyone.

only need a paragraph

SOCW6336

 

Required Readings

James, R. K., & Gilliland, B. E. (2017). Crisis intervention strategies (8th ed.). Boston, MA: Cengage Learning.
Chapter 10, “Partner Violence” (pp. 286-330)
Chapter 11, “Family Crisis Intervention” (pp. 331-372)

  

Assignment: Crisis With Individuals, Couples, and Families

Many people do not connect the word crisis to the words couples and families. When considering the impact of issues such as significant illness, death, job loss, addiction, and relationship violence, a crisis is indeed what has happened within a couple or a family. Such an event affects all involved, singularly and collectively. Family systems theories teach that there is a recalibration period after an event occurs for which the collective unit must make adjustments and acclimate to the change, whether that event is positive or negative. When one part of a system is changed, the other parts are impacted as well. For crises that have a family impact, it is important to work within this framework to help the family adjust and recover.

For this Assignment, identify two types of crises experienced by individuals, couples, and/or families. Select two research articles from the Walden Library that discuss interventions for each of the crises you chose (totaling four articles). Think about the merits and limitations of the interventions discussed in your articles and that you would implement in your own practice and why. Consider the cultural, ethical, and/or legal issues related to treating survivors of the two crises you chose.

The Assignment (2–3 pages):

  • Explain the merits and limitations of the interventions discussed/recommended in the articles.
  • Explain which intervention(s) you most likely would use in your own practice and why.
  • Explain the primary cultural, ethical, and/or legal issues related to treating survivors of the two types of crises you chose.

Support your Assignment with specific references to all resources used in its preparation. You are required to provide a reference list and to appropriately cite, in APA style, all references used within your Assignment.

By Day 7

Computer Forensics

 Assignment: Denial of Service ToolsLearning Objectives and Outcomes<li”>Differentiate between tools that are used to create a denial of service (DoS) attack.Assignment Requirements
You have recently been hired by the DigiFirm Investigation Company. The company has clients nationwide. DigiFirm specializes in conducting computer forensics investigations as well as offering preventive services for clients to avoid digital crimes.You are now a member of a team of computer forensics experts who investigate and solve digital crimes and develop digital solutions for clients. A long-running client has just experienced a denial of service attack to its company website. This is serious because they can’t accept orders from their customers. DigiFirm needs you to find out more about what may have happened.Criminals use various tools to create a denial of service attack, including:

  • Tribe Flood Network
  • TFN2K
  • Trin00

For this assignment:

  1. Search the Internet for information about these three tools.
  2. Provide a description of each of the three tools.
  3. Describe the damage or impact of denial of service attacks.
  4. Summarize the efforts used and solutions found to combat these attacks.

Required Resources

  • Course textbook
  • Internet

Submission RequirementsFormat:Microsoft WordFont:Arial, Size 12, Double-SpaceCitation Style:Your school’s preferred style guideLength:1-2 pages
Self-Assessment Checklist

  • I researched the Tribe Flood Network, TFN2K, and Trin00 tools.
  • I described each of the three tools.
  • I described the damage or impact of denial of service attacks.
  • I summarized the efforts and solutions found to combat these attacks.

Man fin d3

 

Part 1: Stockholders and Management Interests

Stockholders and managers want the same thing, don’t they? Theoretically, yes, but in reality, it does not always work that way. Too often, managers’ personal goals compete with shareholder wealth maximization. Sometimes, managers pay themselves excessive salaries or bonuses that are at odds with the idea of shareholder wealth maximization. How many times have you seen in the news examples of CEO excesses or outlandish spending on events or things that definitely do not help the overall goal of stockholder wealth maximization? 

To prepare for this Discussion, think about a time in your professional experience when a decision was made that seemed to benefit a specific manager or small group of managers and not the overall corporation. If you do not have professional experience directly related to this topic, research a situation in the news where this theme is demonstrated. Consider the outcomes of such an imbalance between manager and stockholder interests and research on how to avoid such a situation.

Describe the situation from either your professional experience or your research.

Explain two or more motivational tools that can aid in aligning stockholder and management interests.

Explain how your selected tools are effective in resolving potential conflicts among managers and stockholders.

Support your discussion with appropriate academically reviewed articles. Use APA format throughout.

Part 2: Application of Concepts/Time Value of Money

Review the video links below. Based on the materials presented in these videos, discuss how you will use the time value of money concepts in managerial decision making. Be specific and give examples based on your experience or research.

Time Value of Money