/* insert into movie*/

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('Godzilla', 1998, 120, 1 , 'Paramount', 123);

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('Pretty Woman', 1990, 120, 1 , 'Disney', 234);

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('Titanic', 1998, 340, 1 , 'Paramount', 123);

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('Mighty Ducks', 1991, 104, 1, 'Paramount', 123);

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('Gone with the wind', 1972, 104, 1, 'Paramount', 300);

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('Wyane', 1973, 134, 0, 'Disney', 234);

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('%AAAA%', 1973, 134, 0, 'Disney', 234);

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('Wayne''s world', 1972, 134, 0, 'Disney', 234);

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('The Man Who Wasnt There', 2001, 116, 0, 'USA Entertainm.', 777);

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('Logan''s run', 1976, NULL, 1 , '', 888);

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('Star Wars', 1977, 124, 1 , 'Fox', 555);

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('Empire Strikes Back', 1980, 111, 1, 'Fox', 555);

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('Star Trek', 1979, 132, 1, 'Paramount', 444);

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('Star Trek: Nemesis', 2002, 116, 1, 'Paramount', 321);

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('The Usual Suspects', 1995, 106, 1, 'MGM', 999);

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('Gone With the Wind', 1938, 238, 1, 'MGM', 123);

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('American Graffiti', 1973, 106, 1, 'Fox', 129);

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('Jailhouse Rock', 1957, 106, 1, 'MGM', 123);

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('That Darn Cat', 1997, 120, 1, 'Disney', 333);

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('The dogs of war', 1980, 116, 1, 'Paramount', 222);

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('A', 1980, 116, 1, 'Paramount', 222);

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('B', 1980, null, 1, 'Paramount', 222);

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('C', 1980, null, 1, 'Fox', 129);

INSERT INTO movie(title, year, length, in_Color, studio, producer_cert)
VALUES('D', 1980, 116, 1, 'Fox', 129);
/* insert into star*/
INSERT INTO star(name, address, gender, birthdate)
VALUES('Julia Roberts', '123 Billings Rd.', 'F', '1963-02-23');

INSERT INTO star(name, address, gender, birthdate)
VALUES('Alec Baldwin', '12 Temple Street', 'M', '1960-08-02');

INSERT INTO star(name, address, gender, birthdate)
VALUES('Kim Basinger', '12 Temple Street', 'F', '1970-06-12');

INSERT INTO star(name, address, gender, birthdate)
VALUES('Robert de Niro', '34 Cambridge Blvd', 'M', '1950-01-03');

INSERT INTO star(name, address, gender, birthdate)
VALUES('Jane Fonda', '22 Turner Av.', 'F', '1937-12-21');

INSERT INTO star(name, address, gender, birthdate)
VALUES('Melanie Griffith', '34 Boston Blvd', 'F', '1957-08-09');

INSERT INTO star(name, address, gender, birthdate)
VALUES('Harrison Ford', '34 Prefect Blvd', 'M', '1942-06-13');

INSERT INTO star(name, address, gender, birthdate)
VALUES('Debra Winger', '344 A way', 'F', '1955-05-16');

INSERT INTO star(name, address, gender, birthdate)
VALUES('Jack Nicholson', '434 X path', 'M', '1937-04-22');

INSERT INTO star(name, address, gender, birthdate)
VALUES('Dean Jones', 'LA lane 25', 'M', '1931-01-25');

INSERT INTO star(name, address, gender, birthdate)
VALUES('John Doe', null, null, '1930-01-25');


/*insert into starsin*/
INSERT INTO starsin VALUES ('Star Wars', 1977, 'Carrie Fisher');

INSERT INTO starsin VALUES ('Star Wars', 1977, 'Mark Hamill');

INSERT INTO starsin VALUES ('Star Wars', 1977, 'Harrison Ford');

INSERT INTO starsin VALUES ('Empire Strikes Back', 1980, 'Harrison Ford');

INSERT INTO starsin VALUES ('The Usual Suspects', 1995, 'Kevin Spacey');

INSERT INTO starsin VALUES ('Terms of Endearment', 1983, 'Debra Winger');

INSERT INTO starsin VALUES ('Terms of Endearment', 1983, 'Jack Nicholson');

INSERT INTO starsin VALUES ('Pretty Woman', 1990, 'Julia Roberts');

INSERT INTO starsin VALUES ('American Graffiti',1973,'Dean Jones');
INSERT INTO starsin VALUES ('Jailhouse Rock',1957,'Dean Jones');
INSERT INTO starsin VALUES ('That Darn Cat',1997,'Dean Jones');
INSERT INTO starsin VALUES ('The dogs of war',1980,'Dean Jones');

INSERT INTO starsin VALUES ('A',1980,'John Doe');
INSERT INTO starsin VALUES ('B',1980,'John Doe');
INSERT INTO starsin VALUES ('C',1980,'John Doe');
INSERT INTO starsin VALUES ('D',1980,'John Doe');
/*insert into movieexec*/

INSERT INTO movieexec VALUES('Melanie Griffith', '34 Boston Blvd', 700, 3000000);

INSERT INTO movieexec VALUES ('George Lucas', 'Oak Rd.', 555, 200000000);

INSERT INTO movieexec VALUES ('Ted Turner', '22 Turner Av.', 333, 125000000);

INSERT INTO movieexec VALUES ('Stephen Spielberg', '123 ET road', 222, 100000000);

INSERT INTO movieexec VALUES ('Merv Griffin', 'Riot Rd.', 199, 112000000);

INSERT INTO movieexec VALUES ('Calvin Coolidge', 'Fast Lane', 129, 20000000);

INSERT INTO movieexec VALUES ('Gene Roddenberry', 'El Paso TX', 444, 5000000);


/*insert into studio*/
INSERT INTO studio VALUES ('Disney', 1);

INSERT INTO studio VALUES ('Paramount', 2);

INSERT INTO studio VALUES ('MGM', 123);

INSERT INTO studio VALUES ('Fox', 129);
