association class It's a Wonderful Life

/************************************************************************************ Adds data aboout who played George and Mary Bailey 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 *************************************************************************************/ ------------------------set the default date format------------------------- alter session set nls_date_format = 'YYYY-MM-DD'; -- movie data insert into movie(title, release_date) values('It''s a Wonderful Life', '1947-01-07'); -- characters insert into character (first_name, last_name, gender) values('George','Bailey','Male'); insert into character (first_name, last_name, gender) values('Mary','Bailey','Female'); -- Roles insert into role (movie_id, character_id) values(102, 202); insert into role (movie_id, character_id) values(102, 203); -- Actors insert into actor(first_name, last_name, middle_name, sag_name, birthdate, gender) values('James','Stewart','Maitland','James Stewart','1908-05-20','Male'); insert into actor(first_name, last_name, middle_name, sag_name, birthdate, gender) values('Robert','Anderson','J.','Bobbie Anderson','1933-03-06','Male'); insert into actor(first_name, last_name, middle_name, sag_name, birthdate, gender) values('Donna','Mullenger','Belle','Dona Reed','1921-01-27','Female'); -- Casting insert into actor_in_role(actor_id, movie_id, character_id) values(303,102,202); insert into actor_in_role(actor_id, movie_id, character_id) values(304,102,202); insert into actor_in_role(actor_id, movie_id, character_id) values(305,102,203); -- Nominations insert into actor_nomination(actor_id, movie_id, character_id, award_id) values(303, 102, 202, 400); select * from all_movie_data where title = 'It''s a Wonderful Life';