create table everyone(
person varchar(20) not null,
sex char(1) not null,
born integer unsigned,
nationality varchar(30),
primary key (person));

insert into everyone (person, sex, born, nationality)
values("Gerry","M",1941,"Australian"),
("Rhonda","F",1943,"British"),
("Sybil","F",1963,"Australian"),
("Gina","F",1985,"Australian"),
("Frank","M",1937,"American"),
("Mary","F",NULL,"American"),
("Paul","M",1962,"American"),
("Peter","M",1963,"Australian"),
("Joe","M",1984,NULL),
("Steven","M",1942,"British"),
("Sue","F",1941,"American"),
("Paula","F",1964,"American"),
("Harry","M",1963,NULL),
("Alan","M",1986,NULL);

create table family(
child varchar(30) not null,
parent varchar(30) not null,
primary key (child, parent),
foreign key (child) references everyone(person),
foreign key(parent) references everyone(person));

insert into family (child, parent)
values("Sybil","Gerry"),
("Sybil","Rhonda"),
("Paul","Frank"),
("Paul","Mary"),
("Peter","Frank"),
("Peter","Mary"),
("Paula","Steven"),
("Paula","Sue"),
("Gina","Sybil"),
("Gina","Paul"),
("Joe","Peter"),
("Joe","Paula"),
("Harry","Frank"),
("Harry","Rhonda"),
("Alan","Paul")