MC$2$ Investco Scout Write CREATE TABLE $($I NEED SQL SCRIPT ALONG WITH OUTPUT$)\backslash$table$[[\backslash$table$[[$Company:$],[$ACF$,$ Acme$],[$Finance$]],\backslash$table$[[$CEO:$],[$Mick$],[$Dempsey$]],\backslash$table$[[$Locations:$],[$Chicago$,$ Denver$]]],[\backslash$table$[[$Company:$],[$TCA$,$ Tara$],[$Capital$]],\backslash$table$[[$CEO: Ava$],[$Newton$]],\backslash$table$[[$Locations:$],[$Houston$,$ New$],[$York City$]]],[\backslash$table$[[$Company:$],[$ALB$,$ Albritton$]],\backslash$table$[[$CEO:$],[$Lena$],[$Dollar$]],\backslash$table$[[$Locations:$],[$Atlanta$,$ New$],[$York City$]]]]$

$\backslash$table$[[$Securities $($ID$,$ Name, Type$),],[$AE$,$Abhi Engineering,Stock$],[$BH$,$Blues Health,Stock$],[$CM$,$County Municipality,Bond$],[$DU$,$Downtown Utility,Bond$],[$EM$,$Emmitt Machines,Stock$]]$

$\backslash$table$[[$Mutual Funds by Investment Company $($Inception Date, ID$,$ Name, Mix$)],[$ACF:$],[\frac{1}{1}\frac{?}{2005},$BG$,\backslash$table$[[$Big$],[$Growth$]],\backslash$table$[[(500$ AE Stocks, $300],[$EM Stocks$)]]],[\frac{1}{1}\frac{?}{2006},$SG$,\backslash$table$[[$Steady$],[$Growth$]],\backslash$table$[[(300$ AE Stocks, $300],[$DU Bonds$)]]],[$TCA:$],[\frac{1}{1}\frac{?}{2005},$LF$,\backslash$table$[[$Tiger$],[$Fund$]],(1000$ EM Stocks, $1000$ BH Stocks$)],[\frac{1}{1}\frac{?}{2006},$OF$,\backslash$table$[[$Owl$],[$Fund$]],(1000$ CM Bonds, $1000$ DU Bonds$)],[$ALB:$],[\frac{1}{1}\frac{?}{2005},$JU$,$Jupiter,$(2000$ EM Stock, $1000$ DU Bonds$)],[1/1/2006,$SA$,$Saturn,$(1000$ EM Stock, $2000$ DU Bonds$)]]$ statements to create the tables for the Investco Scout Funds Database depicted by the relational schema created in mini case MC$1$ in Chapter $3.$ Assume that the following addition is made to the Investco Scout Funds Database requirements listed in mini case MC$1$ in Chapter $2$:Investco Scout will keep track of the CEOFName and CEOLName for each investment company $($in addition to keeping track of a unique investment company identifier, a unique investment company name, and names of multiple locations of the investment company for each investment company$).$ Change the ER diagram created in mini case MC$1$ in Chapter $2$ to reflect the new addition to the requirements. Change the relational schema created in mini case MC$1$ in Chapter $3$ to reflect the change in the ER diagram. Write ALTER TABLE commands that reflect the change in the relational schema. Observe the following information about investment companies and mutual funds, and create INSERT INTO statements that insert the information into the created tables of the Investco Scout Funds Database.

$\backslash$table$[[\backslash$table$[[$Company:$],[$ACF$,$ Acme$],[$Finance$]],\backslash$table$[[$CEO:$],[$Mick$],[$Dempsey$]],\backslash$table$[[$Locations:$],[$Chicago$,$ Denver$]]],[\backslash$table$[[$Company:$],[$TCA$,$ Tara$],[$Capital$]],\backslash$table$[[$CEO: Ava$],[$Newton$]],\backslash$table$[[$Locations:$],[$Houston$,$ New$],[$York City$]]],[\backslash$table$[[$Company:$],[$ALB$,$ Albritton$]],\backslash$table$[[$CEO:$],[$Lena$],[$Dollar$]],\backslash$table$[[$Locations:$],[$Atlanta$,$ New$],[$York City$]]]]$

$\backslash$table$[[$Securities $($ID$,$ Name, Type$),],[$AE$,$Abhi Engineering,Stock$],[$BH$,$Blues Health,Stock$],[$CM$,$County Municipality,Bond$],[$DU$,$Downtown Utility,Bond$],[$EM$,$Emmitt Machines,Stock$]]$