Can you answer this two question as MYSQL statement using database that I uploaded Thank you Answer the following questions based on the above database: Create a view named “Atlanta_Charter_Crew_V” that includes the following “For each charter of aircraft to Atlanta (ATL), print the charter date, charter distance, and the corresponding crew (employee) number, last name, first name, and crew job”. Your answer should include both the SQL statement for view creation along with the contents of the view (you get the contents of the view by running the command select * from Atlanta_Charter_Crew_V;). Modify the MODEL table to add the following attribute and insert the values shown in the following table. (Note: use ALTER TABLE and UPDATE commands.) Attribute nameAttribute DescriptionAttribute typeAttribute ValuesMOD_TOTAL_ WEIGHTWeight of each modelNumeric12,500 for C-90A7,300 for PA23-25019,770 for PA31-350 # Database: Ch08_AviaCo## Table: CHARTER- **Fields:** - CHAR_TRIP, CHAR_DATE, AC_NUMBER, CHAR_DESTINATION, CHAR_DISTANCE, CHAR_HOURS_FLOWN, CHAR_HOURS_WAIT, CHAR_FUEL_GALLONS, CHAR_OIL_QTS, CUS_CODE - **Sample Data:** - Charter trip details including trip dates, aircraft numbers, destinations, distances, and customer codes.## Table: CREW- **Fields:** - CHAR_TRIP, EMP_NUM, CREW_JOB - **Sample Data:** - Lists crew members assigned to specific charter trips, with job roles such as Pilot and Copilot.## Table: CUSTOMER- **Fields:** - CUS_CODE, CUS_LNAME, CUS_FNAME, CUS_INITIAL, CUS_AREACODE, CUS_PHONE, CUS_BALANCE - **Sample Data:** - Customer contact details and their account balances with the company.## Table: EMPLOYEE- **Fields:** - EMP_NUM, EMP_TITLE, EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_DOB, EMP_HIRE_DATE - **Sample Data:** - Basic personal and employment details of company employees.## Table: EARNEDRATING- **Fields:** - EMP_NUM, RTG_CODE, EARRTOG_DATE - **Sample Data:** - Certifications and ratings earned by employees, with dates.## Table: RATING- **Fields:** - RTG_CODE, RTG_NAME - **Sample Data:** - Details of various ratings such as Certified Flight Instructor, Instrument, and Single Engine, Land.## Table: MODEL- **Fields:** - MOD_CODE, MOD_MANUFACTURER, MOD_NAME, MOD_SEATS, MOD_CHG_MILE - **Sample Data:** - Aircraft model information, including number of seats and charging per mile.## Table: AIRCRAFT- **Fields:** - AC_NUMBER, MOD_CODE, AC_TTAF, AC_TTEL, AC_ITER - **Sample Data:** - Details of aircraft including model codes and total time in service.## Table: PILOT- **Fields:** - EMP_NUM, PIL_LICENSE, PIL_RATINGS, PIL_MED_TYPE, PIL_MED_DATE, PIL_PT

1. CREATE VIEW Atlanta_Charter_Crew_V AS ( SELECT i.char_date,i.char_distance,c.emp_num,…

Answered: n you answer this two question as MYSQL…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

Can you answer this two question as MYSQL statement using database that I uploaded Thank you

Answer the following questions based on the above database:

Create a view named “Atlanta_Charter_Crew_V” that includes the following “For each charter of aircraft to Atlanta (ATL), print the charter date, charter distance, and the corresponding crew (employee) number, last name, first name, and crew job”. Your answer should include both the SQL statement for view creation along with the contents of the view (you get the contents of the view by running the command select * from Atlanta_Charter_Crew_V;).

Modify the MODEL table to add the following attribute and insert the values shown in the following table. (Note: use ALTER TABLE and UPDATE commands.)

Attribute name

Attribute Description

Attribute type

Attribute Values

MOD_TOTAL_ WEIGHT

Weight of each model

Numeric

12,500 for C-90A

7,300 for PA23-250

19,770 for PA31-350