***PLEASE WRITE IN MICROSOFT SQL

The assignment for this week will use the same tables you created last week (AviaCo SQL). 1. Write SQL to alter the MODEL table to add the following attribute (column) then update the new attirbute (column) based on the values shown in Table P8.23. Table P8.23 The new attribute (columns) for the MODEL table 2. Write SQL to modify the CHARTER table to add the attributes (columns) shown in Table P8.25. Table P8.25 The new attributes (columns) for the CHARTER table Write the required SQL to implement the changes outlined above to the CHARTER and MODEL tables. Once you have completed the required SQL click the title link above to submit your SQL