Remove the entire column prod_id from the movie table:

First, drop the foreign key constraint from the movie table.

You can use the command SHOW CREATE TABLE movie; to see the name of the foreign key constraint you need to drop.

Next, drop the column prod_id from the movie table

2.List the movie titles and the names of their production companies. Only include production companies that have movies. Sort alphabetically by the movie title.

    

Transcribed Image Text:

mysql> select * from movie_prod; movie_id prod_id 2 11 4 6803 WOWNTOFIN id name 16 HH to 12 13 5 3 7 9 10 14 17 mysql> DESC MOVIE; Field | Туре int 1 1 л сл сл сл сл сл сл на со со солон 2 2 3 3 4 5 5 5 5 5 5 19 18 18 rows in set (0.00 sec) 5 6 SO7 6 id title year duration gross rating prod_id int 7 rows in set (0.17 sec) mysql> DESC PRODUCTION; Field Type varchar(80) int int decimal (6, 1) decimal (3, 1) int varchar (30) 2 rows in set (0.00 sec) | Null | Key | Default | Extra NO PRI NO YES YES YES NO YES MUL NULL NULL NULL NULL NULL 10.0 NULL | Null | Key | Default | Extra NO PRI YES auto increment NULL NULL auto_increment mysql> select * from movie_prod; movie_id prod_id 2 11 4 6803 WOWNTOFIN id name 16 HH to 12 13 5 3 7 9 10 14 17 mysql> DESC MOVIE; Field | Туре int 1 1 л сл сл сл сл сл сл на со со солон 2 2 3 3 4 5 5 5 5 5 5 19 18 18 rows in set (0.00 sec) 5 6 SO7 6 id title year duration gross rating prod_id int 7 rows in set (0.17 sec) mysql> DESC PRODUCTION; Field Type varchar(80) int int decimal (6, 1) decimal (3, 1) int varchar (30) 2 rows in set (0.00 sec) | Null | Key | Default | Extra NO PRI NO YES YES YES NO YES MUL NULL NULL NULL NULL NULL 10.0 NULL | Null | Key | Default | Extra NO PRI YES auto increment NULL NULL auto_increment

Answer rating: 100% (QA)

Based on the instructions and images provided I can guide you through the process of removing the pr... View the full answer