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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get StartedRecommended Textbook for
Concepts of Database Management
Authors: Philip J. Pratt, Mary Z. Last
8th edition
1285427106, 978-1285427102
Students also viewed these Databases questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App