Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Mary Z. Last

8th edition

1285427106, 978-1285427102

More Books

Students also viewed these Databases questions

Question

What is the shape of the exponential distribution?

Answered: 1 week ago

Question

How do you join tables in an Access query?

Answered: 1 week ago

Question

When do you use OLAP?

Answered: 1 week ago