Question: Make a table called status selects and groups all status values from my_contacts and stores the unique values in the new table. 2. (If you

Make a table called status selects and groups all status values from my_contacts and stores the unique values in the new table. 2. (If you need to) alter the new status table to contain a primary key - if you did this in the last step you can skip to step 3. 3. Use an UPDATE statement to make the my_contacts.status column to contain the ID values from the status table (rather than the status values as provided) 4. After step 3 is successful, the my_contacts.status field will now contain integer values rather than text values. Alter the column to store integer values, decide whether you want to rename the column, then choose whether a MODIFY or CHANGE statement is more appropriate. In your report, justify your choice of MODIFY or CHANGE.

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 Databases Questions!