MC$2$ Investco Scout $($SQL SERVER WITH SCRIPT ALONG$)$

Write CREATE TABLE 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.

MC$2$ Investco Scout

Write CREATE TABLE 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.