I did the first one where I create the table but I’m confused on how to adjust e

Question

I did the first one where I create the table but I’m 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.

Explanation / Answer

Hi,

In the given question you are asked to ALTER an existing table. You need to add 2 columns namely CEOFname and CEOLname. Below is the syntax for the alter statement-

Syntax:-

ALTER TABLE <Table_name> ADD COLUMN <<column_name>> <<column_data_type>>;

In you case you need to use below two statements as per the syntax-

a) ALTER TABLE COMPANY ADD COLUMN CEOFname VARCHAR(15);

b) ALTER TABLE COMPANY ADD COLUMN CEOLname VARCHAR(15);

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.