I did the first one where I create the table but Im confused on how to adjust everything else and how to create the alter table. The last two picture are the MC1 er diagram and relational schema from chapter 3. Thank you!

321 Display uultName, dorName for products whose price is below the the BuildingID, AptNo, and ANoOfBed- and Ven- average price of all products rooms for all apartments that are not leased Additional (larger) data sets available at dbtextbook.com Mini Cases MC1 Investco Scout Write CREATE TABLE statements to create the tables for the company mame, and na of a unique investment company identifier, a unique investment mes of muttiple locations of the invest Investco Scout Punds Database depicted by the relational ment company for each investment com schema created in mini case MC1 in Chapter 3 Change the ER diag to reflect the new * , Assume that the following addition is made to the Investco addition to the requirements Scout Funds Database li in Chapter 2 Investco Scout will keep track of the CEOFName and CEOL- Name for each investment company (in addition to keeping track ase requirements listed in mini case MC1 Change the relational schema created in mini case MC1 in Chapter 3 to reflect the change in the ER diagram