Question: need help for this ASAP Leave yoru email so that I can send the file. I've been staying up all night for this. Thanks! Now

 need help for this ASAP Leave yoru email so that I

need help for this ASAP

Leave yoru email so that I can send the file. I've been staying up all night for this. Thanks!

Now that the data is cleaned, we are ready to do some analysis. Initially, we'll create some queries to help explore the data and answer questions that are most easily done in Access rather than Excel. Be sure to use the new tables you created. Do NOT use the imported data we want you to do joins. Save the queries using our usual WAFE naming scheme 1. How many bird strike incidents occurred to each Airplanes and Helicopters. Not that the data also contains some blank aircraft types as well as C. Your result should have two rows, one for Airplanes and one for Helicopters 2. Which airline had the most bird strike incidents? Exclude "UNKNOWN" and MILITARY" from your analysis, i e., find the airline other than UNKNOWN and MILITARY. Display the airline name only 3 of 5 3. Count the number of airlines which had bird strike incidents during either the "Approach" flight phase or the "Climb" flight phase but not both. Hint: Use this as your criteria for the field Flight Phase Approach" OR "Climb" as your first subquery. Afterwards it is easiest to use a set-complement query where you subtract the airlines that had both kinds of incidents.. 4. How many airlines had a bird strike incident during the "Approach" flight phase but not during the "Climb" flight phase. Some airlines may have had incidents during various phases of flight. In this query, we only want to count those airlines that had incidents during "Approach" and no incidents during "Climb". Of course, if they had incidents during "Approach" and "Landing" it would count as long as it did not also have an incident during "Climb". Be sure not to double count any airlines 14 Now that the data is cleaned, we are ready to do some analysis. Initially, we'll create some queries to help explore the data and answer questions that are most easily done in Access rather than Excel. Be sure to use the new tables you created. Do NOT use the imported data we want you to do joins. Save the queries using our usual WAFE naming scheme 1. How many bird strike incidents occurred to each Airplanes and Helicopters. Not that the data also contains some blank aircraft types as well as C. Your result should have two rows, one for Airplanes and one for Helicopters 2. Which airline had the most bird strike incidents? Exclude "UNKNOWN" and MILITARY" from your analysis, i e., find the airline other than UNKNOWN and MILITARY. Display the airline name only 3 of 5 3. Count the number of airlines which had bird strike incidents during either the "Approach" flight phase or the "Climb" flight phase but not both. Hint: Use this as your criteria for the field Flight Phase Approach" OR "Climb" as your first subquery. Afterwards it is easiest to use a set-complement query where you subtract the airlines that had both kinds of incidents.. 4. How many airlines had a bird strike incident during the "Approach" flight phase but not during the "Climb" flight phase. Some airlines may have had incidents during various phases of flight. In this query, we only want to count those airlines that had incidents during "Approach" and no incidents during "Climb". Of course, if they had incidents during "Approach" and "Landing" it would count as long as it did not also have an incident during "Climb". Be sure not to double count any airlines 14

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!