Case Vignette: Which Trauma based disorder (Posttramatic stress disorder (PTSD), Acute stres disorder (ASD) or adjusment disorder is Bethany and Charles each suffering from and why? Dignosis Bethany and Charles and use symptoms from the case vignette (story below) to supportthe dignosis.

Bethany Pinsky, age 23, has gone to a theater to see the local premiere of a big-budget movie. As she settles into her seat, waiting for the show to begin, a young man in a ski mask suddenly appeared in front of the screen. Brandishing an assault rifle, he fired directly into the audience. She saw many people get shot, including the woman sitting next to her. People all around began screening, and there was a confused stampede for the exit door. Terrified, she somehow fought her way to the exit and escaped, uninjured, to the parking lot, where police cars were just arriving.

Charles Quigley, age 25, went to the same movie theater at the same time. He too feared for his life. Hiding behind a row of seats, he was able to crawl to the aisle and quickly sprint to the exit.   Although covered in blood, he escaped without physical injury.

Bethany, Two Weeks Later

Bethany comes to see you. She has not recovered 2 weeks later. She feels emotionally constricted, and unable to experience pleasant or positive feelings. She jumps at the slightest sound, she is unable to focus on her work and her sleep has been fitful and marked by traumatic nightmares. She has tried to avoid any reminders of the shooting but nevertheless relentlessly recalls the sounds of gunfire, the screams, and the sticky feel of the blood pouring out of her neighbor's chest in the movie theater. She feels the experience has changed her life forever.

Charles, Two Months Later

Charles comes to see you as he has been having a difficult time sleeping and concentrating. He feels like he wasn't impacted as much as others by the event but continues to think about the shooting. He finds himself sad at times and easily cries. He feels his heart rate increase and becomes slightly nervous at a loud sound. He feels anger towards others who tell him that they understand how he feels. When asked about his job and personal relationships, he states that he has been able to keep his job. However, he is afraid he may get fired soon as his performance at work has been poor due to his inability to concentrate. His girlfriend tries to help him but he feels she can't understand his pain since she wasn't there. She has noticed his low energy and feeling of hopelessness lately and suggested that he see someone.

The average density of planet earth is 5.52 g/cm3. Knowing that Earth has a mass of 5.97*10^27g, determine the earth radius in miles. ( 1 mile = 1609 meters).

In 50-100 words describe ADS-B. Explain how this technology will allow for reduced separation during cruise flight (from 3 miles down to as little as 1 mile).

A bicyclist is riding on a path modeled by the function

f(x) = 0.07x,

where x and f(x) are measured in miles (see figure). Find the rate of change of elevation at

x = 5.

She has just hired an additional employee. He lives in a different city and travels 90 miles a day on public transportation. Recompute the mean and median. Describe the effect of this outlier

An airplane flies 560 miles with a tailwind in 2 hours 20 minutes. It takes 3 hours to fly against the headwind. Find the speed of the airplane in still air and the speed of the wind.

DROP DATABASE class;CREATE DATABASE class;Use class;drop table if exists Class;drop table if exists Student;CREATE TABLE Class (CIN int PRIMARY KEY, FirstName varchar(255), LastName varchar(255), Gender varchar(1), EyeColor varchar(50), HairColor varchar(50), HeightInches int,CurrentGrade varchar(1));CREATE TABLE Student (SSN int PRIMARY KEY,FirstName varchar(255),LastName varchar(255), Age int,BirthMonth varchar(255),HeightInches int,Address varchar(255),City varchar(255),PhoneNumber varchar(12),Email varchar(255),FavColor varchar(255),FavNumber int);INSERT INTO Class VALUES(1, "David", "San", "M", "BRN", "BLK", 72, "-");INSERT INTO Class VALUES(2, "Jeff", "Gonzales", "M", "BRN", "BLK", 68, "B");INSERT INTO Class VALUES(3, "Anna", "Grayson", "F", "BRN", "BRN", 62, "A");INSERT INTO Class VALUES(4, "Kathryn", "Moloney", "F", "GRN", "BLK", 68, "B");INSERT INTO Class VALUES(5, "Randy", "Bernard", "M", "GRN", "BRN", 69, "A");INSERT INTO Class VALUES(6, "Andy", "Lam", "M", "BRN", "BLK", 59, "C");INSERT INTO Class VALUES(7, "Makoto", "Yuki", "F", "BRN", "BRN", 61, "A");INSERT INTO Class VALUES(8, "Pranil", "Watakana", "M", "BRN", "BLK", 63, "D");INSERT INTO Class VALUES(9, "Pierce", "Santos", "M", "BRN", "BLK", 74, "B");INSERT INTO Class VALUES(10, "Soliel", "Estrada", "F", "BRN", "BLU", 66, "B");INSERT INTO Class VALUES(11, "Jeff", "Bezos", "M", "BRN", "BRN", 65, "B");INSERT INTO Class VALUES(12, "Andy", "Chen", "M", "BRN", "BLK", 69, "A");INSERT INTO Class VALUES(13, "Makoto", "Amagi", "F", "BRN", "BRN", 64, "C");INSERT INTO Student VALUES(1, "David", "San", 22, "March", 72, "1234", "Flowerville", "231-246-4361", "[email protected]", "Blue", 7);INSERT INTO Student VALUES(2, "Randy", "Bernard", 21, "February", 69, "7123", "Rossette Park", "634-124-7452", "[email protected]", "Green", 12);INSERT INTO Student VALUES(3, "Andy", "Lam", 24, "December", 59, "9072", "Jefferson", "124-564-6354", "[email protected]", "Grey", 32);INSERT INTO Student VALUES(4, "Pranil", "Watakana", 23, "February", 63, "2146", "Rossette Park", "543-325-3521", "[email protected]", "Grey", 3);INSERT INTO Student VALUES(5, "Jeff", "Bezos", 22, "April", 65, "6312", "Grey Valley", "351-532-6439", "[email protected]", "Yellow", 0);INSERT INTO Student VALUES(6, "Makoto", "Amagi", 21, "September", 64, "39857", "Flowerville", "314-352-5321", "[email protected]", "Black", 3);

INSERT INTO Student VALUES(7, "Jeff", "Gonzales", 20, "October", 68, "4361", "Flowerville", "231-342-5467", "[email protected]", "Blue", 21);INSERT INTO Student VALUES(8, "Anna", "Grayson", 21, "January", 62, "6543", "Rossette Park", "634-423-5763", "[email protected]", "Green", 12);INSERT INTO Student VALUES(9, "Kathryn", "Moloney", 24, "May", 68, "5437", "Jefferson", "124-684-4131", "[email protected]", "Grey", 3);INSERT INTO Student VALUES(10, "Makoto", "Yuki", 19, "April", 61, "75632", "Rossette Park", "543-354-6421", "[email protected]", "Grey", 7);INSERT INTO Student VALUES(11, "Pierce", "Santos", 21, "January", 74, "3543", "GreyValley", "351-542-7541", "[email protected]", "Yellow", 10);INSERT INTO Student VALUES(12, "Soliel", "Estrada", 20, "June", 66, "3754", "Flowerville", "314-325-6543", "[email protected]", "Black", 5);INSERT INTO Student VALUES(13, "Andy", "Chen", 22, "September", 69, "3865", "Flowerville", "314-231-4233", "[email protected]", "Black", 3);

-----------------------------------------------------------------------------------------------------------------------

1. Assign grades for students who lived in Rossette Park to be a B
2. Add another table for students who had an altered grade (in this case students who lived in Rossette Park)
3. Add the CIN, FirstName, LastName, Gender, Address, City, and Email of the students who had an altered grade to the table
4. Remove students from the student table who live in Rossette Park
5. Join all 3 tables and display the Names, Gender, and City of the students (Going to need to use ON)

Use
SET SQL_SAFE_UPDATES = 0;
To disable Safe Mode if prompted.

Not sure where to begin, as my instructor taught the theory but never any live coding session.

A car dealership would like to test the hypothesis that a difference exists in the city gas mileage (miles per gallon when driven in the city) of three cars, Honda Insight, Hyundai Ioniq and Toyota Camry. The following data represent the miles per gallon for a random sample of Honda Insight, Hyundai Ioniq and Toyota Camry cars.

Use Excel to perform a one-way ANOVA and state your conclusion using α = 0.05.

The Highway Safety Department wants to study the driving habits of individuals. A sample of 34 cars traveling on a particular stretch of highway revealed an average speed of 68.8 miles per hour with a standard deviation of 9.8 miles per hour. Round to 4 decimal places.

1.Calculate a 99% confidence interval for the true mean speed of all cars on this particular stretch of highway.

( , )

2. What sample size is needed to estimate the true average speed to within 2.5 mph at 99% confidence? Note: For consistency's sake, round your t* value to 3 decimal places before calculating the necessary sample size.

Choose n =

suppose you have joined the navy and are stationed aboard the nuclear submarine seawolf. your boat has been assigned to conduct torpedo practice in the gulf of Mexico. you enter the practice area point A and travel 40 miles due eat. then you change direction by turning at an angle of 75 degrees northward. the submarine then travels for 30 miles in the new direction. How far is the current location of your submarine at point C from the entry point of the practice area (point A)? c=40mi a=30mi what is the area of the ocean enclosed in triangle ABC? find the measures of all three angles in triangle ABC. explain what methods used.