create table people(
person varchar(20) not null,
sex char(1) not null,
born dec(4),
nationality varchar(30),
primary key (person))

insert into people (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 people(person),
foreign key(parent) references people(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")