Creating Basic QueriesReview SQL Queries & Explore a DatabaseRead Chapters 6, 9, 10, 11, & 12 of Beginning SQL Server 2012 for Developers Watch Lesson 6 in Foundations of Programming: Databases with Simon Allardice Explore a DatabaseGiven the Northwind database, explore the structure of the database, that tables, relationships, and the queries created. Identify the needed enhancements to the database. Perform SQL Intro through SQL Union tutorial at www.w3wchools.com/sql. Submit all the screenshots of the queries done in Step 3.

Read the Frontier and United Airlines case study “Frontier and United Airlines: Competition Heats Up in Denver” on pages 111-113 in your text. Write a two-page paper, typed and double-spaced, using the attached template, in which you respond to each of the following questions. Include a 200-word summary highlighting the importance of this type of competitor analysis. According to the data collected from United Airlines and presented in the preceding multi-attribute matrix, describe five useful pieces of information for United’s future managerial decision making.According to the date collected from United Airlines and presented in the preceding multi-attribute matrix, which airline is preferred by nonbusiness travelers?Compared to the airline preferred by nonbusiness travelers, which attributes should receive the most immediate attention?After flying with United Airlines, passengers were asked to record their perceptions about their experiences pertaining to each of the decision-making criteria. The results are displayed in the table at the end of the text (expectation scores were obtained from the original multi-attributed matrix). Given this information, determine the size and direction of the satisfaction gap and whether customers were dissatisfied, satisfied or delighted.If United’s customers’ expectations are misaligned with their actual perceptions, what can United do to correct the situation so that in future purchase decisions, accurate rankings are entered into the consumer’s multi-attribute matrix?Discuss the pros and cons of United Airlines actively pursuing nonbusiness customers.Include a minimum of three sources