4.4 Find an article about a company that had to deliver a communication of bad-news to its constituents or the general public. The bad-news message could be a result of one of the following situations: A product defect or failure A reduction in workforce An under-performing financial quarter A new but unpopular policy such as a pricing strategy Write a 600 to 800 word paper demonstrating clear, insightful critical thinking on the proper approach to delivering bad-news messages. Review the components of bad-news messages: ease in with a buffer, provide a rationale, deliver the bad news, explain impacts, focus on the future and show goodwill. (see LO 11.3 Components of Bad-News Messages). Which components are included in the bad-news message you are reviewing? Which are missing that should have been included? Explain. How well did the bad-news message meet the needs of the victims and other stakeholders? Do you believe the communication was completely fair? Explain. What are three aspects of the bad news message that could have been improved? Explain. Expert Answer Anonymous answered this Was this answer helpful? 0 0 193 answers The problem pertains to the change management at the organisation and giving bad news about the dissolution of the company and hence termination of employment of the employees with the company. Since this news has financial, emotional, psychological and social implications for the employees, it needs to be dealt with utmost sensitivity keeping in mind that employees have been major stakeholders in the growth of the bank and thus they need to be approach with a mature outlook towards their problems. Most business communication professionals do not feel that email is a good way of communicating when the sender has to convey a bad news and it is much better to have a face to face or telephonic conversation in such cases. But, sometimes it is not feasible to have meetings or conversations because of the large number of people involved, unavailability of all the parties, validity and proof of the conversation and geographical distance between the participants.

Write and run SQL statements to complete the following tasks

1. Show the details of the vendors who are located in area code 615.
2. Show the details of the products that do not have a value for the attribute v_code.
3. Show the details of the invoices whose subtotal is greater than 25 but less than 75.
4. Show the details of the invoice who has the minimum subtotal.
5. Show the codes and names of the vendors who supplied products.
6. Using EXCEPT show the codes of the vendors who did not supply any products.
7. Using ‘NOT IN’ show the codes and names of the vendors who did not supply any products.
8. List the codes of vendors and the number of products each vendor has supplied, i.e. vendor XXX has supplied xxx products, and vendor YYY has supplied yyy products etc.
9. List the names and codes of vendors and the number of products each vendor has supplied, i.e. vendor XXX has supplied xxx products, and vendor YYY has supplied yyy products etc.
10. Add a new attribute (field) status varchar(6) to the EMP table.
11. Update status for employee '100' to 'Temporary'.
12. Using inner join, list the details of the products whose line price is greater than 100.

You are required to answer

1.   The SQL statements for each query, which should be copied and pasted into word.

2. tell all the sql command for each question?

tables: -

VENDOR TABLE

PRODUCT TABLE

CUSTOMER TABLE:

INVOICE TABLE:

LINE TABLE:

EMPLOYEE TABLE:

1. Create a program named MergeSort.java then copy the following code to your program:
   • public static void mergeSort(int[] arr){
        mergeSortRec(arr, 0, arr.length-1);
     }
     private static void mergeSortRec(int[] arr, int first, int last){
        if(first<last){
         int mid=(first+last)/2;
     mergeSortRec(arr, first, mid);
         mergeSortRec(arr, mid+1,last);
         merge(arr, first, mid, mid+1, last);
        }
     }
     private static void merge(int[] arr, int leftFirst,
        int leftLast, int rightFirst, int rightLast){
        int[] aux=new int[arr.length];
        //extra space, this is downside of this algorithm
        int index=leftFirst;
        int saveFirst=leftFirst;
        while(leftFirst<=leftLast && rightFirst <=rightLast){
     if(arr[leftFirst]<=arr[rightFirst]){
        aux[index++]=arr[leftFirst++];
         }else{
        aux[index++]=arr[rightFirst++];
         }
        }
        while(leftFirst<=leftLast){
         aux[index++]=arr[leftFirst++];
        }
        while(rightFirst<=rightLast)
         aux[index++]=arr[rightFirst++];
        for(index=saveFirst; index<=rightLast; index++)
         arr[index]=aux[index];
     }
2. Write a main method that accepts three numbers N, A, B (assume A<B) from the command argument list, then use the number N to create an N-element int array.
3. Assign random numbers between [A, B] to each of the N elements of the array.
4. Call mergeSort method to sort the array.
5. Write instructions to record the time spent on sorting.
6. (Optional) you may write code to verify the array was sorted successfully.
7. Once completed, test your program with different numbers N, A, B and screenshot your result. Your result should include the number of elements and sorting time.
8. Please include the following in the Word document you created for the assignment for the final submission:  
   • Copy/paste your completed code in MergeSort.java
   • Insert at least one screenshot of the running output in #7 above
   • Answer this question: What is the average Big O for this sort?

You work for a hospital in the registration and admissions department, and most of your tasks are performed manually. For example, when an individual checks in, you must obtain personal information, details on an individual’s medical background, and hospitalization insurance. You are a strong advocate for information technology and have proposed to IT management that information systems would be beneficial. The hospital has decided to develop and implement an information system that helps to streamline your processes. Since you have extended personal experience with the processes, and you have considerable knowledge of information systems and technology employed by your counterparts at other hospitals, you have been asked to function as the project business analyst. You will work very closely with the IT department’s system analyst. The system analyst has questions regarding the following:

• What specifically do you do to complete your tasks?
• What are your thoughts about how technology might improve your processes?
• What are the challenges and obstacles that would be overcome with the use of an information system?
• What are your thoughts about the type of information system that might be employed at your hospital?
• Based on your understanding, what components would be required to implement the information system? For example, would you need any special hardware or software?

In a 3–5-page Word document, be sure to include the following.

• Summarized list of tasks, or processes, to register and to check in a patient.
• Benefits of using an information system in support of your day-to-day tasks.
• Specifics regarding how the information system would help to overcome the present challenges and obstacles.
• The specific type of information system you recommend (support your recommendation).
• An outline of all components you see as necessary to implement your recommended information system.
• Explain how the new information system would help your organization to reduce the overall cost of health care and to improve the profitability of your hospital.

As a programmer, you have been asked to write a Java application, using OOP concepts, for a Hospital with the following requirements:
• The Hospital has several employees and each one of them has an ID (int), name (string), address (string), mobile phone number (string), email (string) and salary (double) with suitable data types. • The employees are divided into:
o Administration staff: who have in addition to the previous information their position (string). o Doctor: who have also a rank (string) and specialty (string).
The project requirements: • You will need to create all the needed Java classes with all the required information. • You have to apply all the OOP (Object Oriented Programming) concepts that we have covered in this
module (i.e. inheritance, polymorphism, interface and collections)
• Include a Microsoft Word document (name it as readme.doc) that includes several screenshots of
your Netbeans IDE application GUI interface as well as the output screenshot results. Provide all
assumptions that you have made during design and implementation.
• Include the whole Netbeans Java project with all source codes. Write as much comments as possible

At the end, you will need to create a testing class (e.g. Hospital.java) with the static main() method with the following requirements:
• It must have an initial fixed collection of working staff (at least 3 administration staffs and 2
doctors)
• The program will print a selection screen where the user can choose the operation
he/she wants to perform. The selection screen will be repeated after each selection until the staff
type the number 4 to completely exit from the program:
1. Add an administration staff (by providing all her/his information) to the list of all
administration staff
2. Add a doctor (by providing all her/his information) to the list of all doctors
3. Print all working staff (remember to differentiate between administration staff and doctors
in the output printout
4. Exit the program

You are studying a population of wild turtles on a remote Pacific island. You have been following the allelic frequencies at a single two-allele locus 'S', which controls embryonic survival through simple Mendelian inheritance with dominance. The population has been in Hardy-Weinberg equilibrium at this locus for many generations.

At Hardy-Weinberg equilibrium, the frequency of the recessive allele S^d is 0.88

The genotypic frequencies at Hardy-Weinberg equilibrium are as follows:

f(S^DS^D) = 0.0144

f(S^DS^d) = 0.2112

f(S^dS^d) = 0.7744

An increase in ocean temperature between 2018 and 2019 is thought to have driven the population away from Hardy-Weinberg equilibrium at the S locus.

The numbers of sampled offspring by genotype after the 2019 hatch are as follows:

S^DS^D : 200

S^DS^d : 200

S^dS^d : 40

Calculate the relative fitness (W) values for each genotype (you will need all these values in a subsequent step).

a) The relative fitness value for the S^dS^d genotype is [A] (enter your answer as a decimal in the form '0.x'; do not spell out the number as a word; there are no units to include)

b) The type or form of natural selection that has occurred is [B] (use the specific phrase that describes this form of selection completely!).

Now, calculate all genotypic frequencies in the 2019 offspring (first generation after selection):

c) post-selection f(S^DS^D) = [C] (perform this and the following two calculations (d and e) to four significant figures after the decimal point; enter your answers in the exact form '0.wxyz'; make sure to round off correctly; there are no units)

d) post-selection f(S^DS^d) = [D]

e) post-selection f(S^dS^d) = [E]

f) The frequency of the S^d recessive allele in the 2019 offspring (first generation after selection) is [F] (perform the calculation with four significant figures, then round off to 2 significant figures in the final answer; enter your answer in the exact form '0.xy')

Files that are read by the computer are called ____ files.

As an effective speaker the key element we are taught is to "Know (analyze) your audience". After reviewing this chapter what have you learned are other important elements that you must do (know) when planning a presentation? How many main points should a speaker include in their presentation/speech? Open a dialogue to discuss the effectiveness and ineffectiveness of a speaker's use of humor in presentations/speeches (Respond in agreement or disagreement to other virtual classmates post(s).

Types of Delivery

The word presentation may conjure up images of a speaker standing behind a lectern delivering information to a passive audience. While some business and professional presentations certainly follow this model, many of them are far more interactive.

There are three presentation styles: monologues, guided discussions, and interactive presentations.¹

Monologues are speeches delivered without interruption or audience involvement. An example might be when the presenter of an award introduces the winner to the audience by sharing some kind remarks about that person’s achievements. Monologues are most appropriate in large settings and on formal occasions. In smaller groups, they can feel artificial and create the impression the speaker does not care much about the audience.

Guided discussions are more interactive. In this type of presentation, a speaker provides information and has a preset idea of which material will be covered, but listeners are encouraged to speak up with questions and comments. Managing a guided discussion is more challenging, but the potential for more audience buy-in can be worth the effort.

Interactive presentations, as their name implies, involve the audience even more. Although the speaker still controls the program, an interactive presentation feels more like a conversation than a speech. Interactive presentations are common in sales settings, where customer interest drives the communication.

Speakers have four options when delivering presentations: manuscript, memorized, extemporaneous, 325and impromptu. However, two of them—extemporaneous and impromptu—will serve you best in most situations.