Базы данных SQL-DDL и SQL-DML. Изучение транзакций. Программирование на языке SQL. Консольное приложение (Цикл лабораторных работ). Вариант № 2, страница 4

VALUES (1, 'The Lord of the Rings: The Fellowship of the Ring',2001,178,93000000,3);

INSERT INTO film (f_id,name,year_of_creation,duration,budget,site)

VALUES (2, 'The Lord of the Rings: The Two Towers',2002,179,94000000,3);

INSERT INTO film(f_id,name,year_of_creation,duration,budget,site)

VALUES (3, 'Titanic',1997,194,200000000,4);

INSERT INTO film(f_id,name,year_of_creation,duration,budget,site)

VALUES (4, 'Avatar',2009,162,237000000,5);

INSERT INTO film (f_id,name,year_of_creation,duration,budget,site)

VALUES (5,'The Terminator 2: Judgment Day',1991,137,102000000,1);

INSERT INTO film (f_id,name,year_of_creation,duration,budget)

VALUES (6, 'Catch Me If You Can',2002,141,52000000);

INSERT INTO film (f_id,name,year_of_creation,duration,budget)

VALUES (7, 'Manhattan',1979,96,39000000);

commit;

INSERT INTO soundtrack (sound_id,name,author,film,duration)

VALUES (1,'My Heart Will Go ON',9,3,'05:08');

INSERT INTO soundtrack (sound_id,name,author,film)

VALUES (2,'You Dont Dream In Cryo',9,4);

INSERT INTO soundtrack (sound_id,name,author,film,duration)

VALUES (3,'Rose',9,3,'03:03');

INSERT INTO award(award_id,year_aw,award,result,category)

VALUES(1,1998,'Oscar','won','Best director');

INSERT INTO award(award_id,year_aw,award,result,category)

VALUES(2,1992,'Saturn Award','won','Best director');

INSERT INTO award(award_id,year_aw,award,result,category)

VALUES(3,1998,'Golden Globe','nominated','Best Performance by an Actor in a Motion Picture');

INSERT INTO award(award_id,year_aw,award,result,category)

VALUES(4,1998,'Oscar','won','Best music');

INSERT INTO award(award_id,year_aw,award,result,category)

VALUES(5,1980,'Oscar','nominated','Best Writing');

INSERT INTO award(award_id,year_aw,award,result,category)

VALUES(6,1998,'Golden Globe','won','Best music');

commit;

INSERT INTO company(com_id,name,year_of_foundation)

VALUES(1,'Paramount Pictures',1912);

INSERT INTO company(com_id,name,year_of_foundation)

VALUES(2,'Warner Bros.Pictures',1918);

INSERT INTO company(com_id,name,year_of_foundation)

VALUES(3,'20th Century Fox',1935);

INSERT INTO company(com_id,name,year_of_foundation)

VALUES(4,'Universal Studios',1912);

INSERT INTO rating(r_id,rating,e_mail,film_id)

VALUES(1,9,'werttanya@mail.ru',3);

INSERT INTO rating(r_id,rating,e_mail,film_id)

VALUES(4,7,'andrey@mail.ru',3);

INSERT INTO rating(r_id,rating,e_mail,film_id)

VALUES(5,5,'masha@mail.ru',6);

INSERT INTO rating(r_id,rating,e_mail,film_id)

VALUES(2,8,'AlenkiiAAA@yandex.ru',6);

INSERT INTO rating(r_id,rating,e_mail,film_id)

VALUES(3,7,'dontsova23@mail.ru',1);

commit;

INSERT INTO part(film_id,man_id,role_id)

VALUES(1,4,1);

INSERT INTO part(film_id,man_id,role_id)

VALUES(2,4,1);

INSERT INTO part(film_id,man_id,role_id)

VALUES(3,2,1);

INSERT INTO part(film_id,man_id,role_id)

VALUES(4,2,1);

INSERT INTO part(film_id,man_id,role_id)

VALUES(5,8,3);

INSERT INTO part(film_id,man_id,role_id)

VALUES(6,7,3);

INSERT INTO part(film_id,man_id,role_id)

VALUES(6,1,1);

INSERT INTO part(film_id,man_id,role_id)

VALUES(3,6,3);

INSERT INTO part(film_id,man_id,role_id)

VALUES(3,7,3);

INSERT INTO part(film_id,man_id,role_id)

VALUES(3,9,5);

INSERT INTO part(film_id,man_id,role_id)

VALUES(1,5,3);

INSERT INTO part(film_id,man_id,role_id)

VALUES(2,5,3);

INSERT INTO part(film_id,man_id,role_id)

VALUES(7,3,1);

INSERT INTO part(film_id,man_id,role_id)

VALUES(7,3,2);

commit;