Mr. Potter Data

/************************************************************************************ Adds data aboout who played Mr. Potter in "It's a wonderful Life" Assumes you have built the table structure with the script available at: https://byuis302.blogspot.com/2023/09/association-class.html and added the information about George and Mary Bailey with the script at: https://byuis302.blogspot.com/2023/09/association-class-its-wonderful-life.html *************************************************************************************/ ------------------------set the default date format------------------------- alter session set nls_date_format = 'YYYY-MM-DD'; ------------------------Add the data for Mr. Potter------------------------- insert into actor(first_name, last_name, middle_name, sag_name, birthdate, gender) values('Lonnel', 'Blyth', 'Herbert', 'Lionel Barrymore', '1878-04-28', 'Male'); insert into character (first_name, last_name, gender) values( 'Henry', 'Potter', 'Male'); insert into role(movie_id, character_id) values( (select movie_id from movie where title like '%Wonderful Life'), (select character_id from character where last_name = 'Potter') ); insert into actor_in_role(actor_id, movie_id, character_id) values( (select actor_id from actor where last_name = 'Blyth'), (select movie_id from movie where title like '%Wonderful Life'), (select character_id from character where last_name = 'Potter') ); ------------------------Show Data For It's a Wonderful Life------------------------- select * from all_movie_data where title = 'It''s a Wonderful Life';