insert into person (id, name, age, hobbies) values (1, 'Peter Muir', 25, '*works on Seam*, *of course*');
insert into continent(id, name) values(1, 'North America');
insert into continent(id, name) values(2, 'South America');
insert into continent(id, name) values(3, 'Australasia');
insert into continent(id, name) values(4, 'Europe');
insert into continent(id, name) values(5, 'Asia');
insert into continent(id, name) values(6, 'Africa');
insert into continent(id, name) values(7, 'Antartica');

insert into country (id, name, continent_id) values (1, 'USA', 1);
insert into country (id, name, continent_id) values (2, 'Canada', 1);
insert into country (id, name, continent_id) values (3, 'United Kingdom', 4);
insert into country (id, name, continent_id) values (4, 'France', 4);
insert into country (id, name, continent_id) values (5, 'Germany', 4);
insert into country (id, name, continent_id) values (6, 'Spain', 4);
insert into country (id, name, continent_id) values (7, 'Australia', 3);
insert into country (id, name, continent_id) values (8, 'Chile', 2);
insert into country (id, name, continent_id) values (9, 'China', 5);
insert into country (id, name, continent_id) values (10, 'South Africa', 6);

insert into colour(id, name) values (1, 'Red')
insert into colour(id, name) values (2, 'Blue')
insert into colour(id, name) values (3, 'Green')
insert into colour(id, name) values (4, 'Purple')
insert into colour(id, name) values (5, 'Yellow')
insert into colour(id, name) values (6, 'Orange')

insert into book(name,author,nationality) values ('Pride and Prejudice', 'Jane Austin', 'British')
insert into book(name,author,nationality) values ('The Great Gatsby', 'F. Scott Fitzgerald', 'American')
insert into book(name,author,nationality) values ('Romeo and Juliet', 'William Shakespeare', 'British')
insert into book(name,author,nationality) values ('The Illiad', 'Homer', 'Ancient Greek')

insert into film(id,name,director) values (1, 'Blade Runner', 'Ridley Scott')
insert into film(id,name,director) values (2, 'E.T.', 'Steven Spielberg')
insert into film(id,name,director) values (3, 'Star Wars', 'George Lucas')
insert into film(id,name,director) values (4, 'Jay and Silent Bob Strike Back', 'Kevin Smith')
