Question: Please answer the question below. MC Investco Scout Write CREATE TABLE statements to create the tables for the Investco Scout Funds Database depicted by the

Please answer the question below.

Please answer the question below. MC InvestcoPlease answer the question below. MC Investco

MC 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 MC1 in Chapter 3. Assume that the following addition is made to the Investco Scout Funds Database requirements listed in mini case MC1 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 MC1 in Chapter 2 to reflect the new addition to the requirements. Change the relational schema created in mini case MC1 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. Investment Companies Company: ACF, Acme Finance CEO: Mick Dempsey Locations: Chicago, Denver Company: TCA, Tara Capital CEO: Ava Newton Locations: Houston, New York City Company: ALB, Albritton CEO: Lena Dollar Locations: Atlanta, New York City Securities (ID, Name, Type) AE Abhi Engineering Stock BH Blues Health Stock CM County Municipality Bond DU Downtown Utility Bond EM Emmitt Machines Stock Mutual Funds by Investment Company (Inception Date, ID, Name, Mix) ACF: 1/1/2005 BG Big Growth (500 AE Stocks, 300 EM Stocks) 1/1/2006 SG Steady Growth (300 AE Stocks, 300 DU Bonds) TCA: 1/1/2005 LF Tiger Fund (1000 EM Stocks, 1000 BH Stocks) 1/1/2006 OF Owl Fund (1000 CM Bonds, 1000 DU Bonds) ALB: 1/1/2005 JU Jupiter (2000 EM Stock, 1000 DU Bonds) 1/1/2006 SA Saturn (1000 EM Stock, 2000 DU Bonds)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!