DROP TABLE Animal CASCADE constraints;

CREATE TABLE Animal(
	animalid		NUMBER(4,0),
	name		VARCHAR2(30),
	species		VARCHAR2(30),
	birthday		DATE,
	sex			CHAR(1),
	father		NUMBER(4,0),
	mother		NUMBER(4,0),
	PRIMARY KEY (animalid),
	FOREIGN KEY (father) REFERENCES Animal (animalid),
	FOREIGN KEY (mother) REFERENCES Animal (animalid)
);

INSERT INTO Animal VALUES (1001, 'Bokito', 'Monkey', to_date('1999/01/02', 'yyyy/mm/dd'), 'M', NULL, NULL);
INSERT INTO Animal VALUES (1002, 'Jaap', 'Horse', to_date('1995/04/12', 'yyyy/mm/dd'), 'M', NULL, NULL);
INSERT INTO Animal VALUES (1003, 'Bello', 'Horse', to_date('1995/04/12', 'yyyy/mm/dd'), 'M', NULL, NULL);
INSERT INTO Animal VALUES (1004, 'Mary', 'Monkey', to_date('1996/04/12', 'yyyy/mm/dd'), 'F', NULL, NULL);
INSERT INTO Animal VALUES (1005, 'Hank', 'Horse', to_date('1996/05/12', 'yyyy/mm/dd'), 'M', NULL, NULL);
INSERT INTO Animal VALUES (1006, 'Lulu', 'Monkey', to_date('1997/04/06', 'yyyy/mm/dd'), 'F', 1001, 1004);
INSERT INTO Animal VALUES (1007, 'Bobo', 'Horse', to_date('1997/03/12', 'yyyy/mm/dd'), 'M', NULL, NULL);
INSERT INTO Animal VALUES (1008, 'Flappie', 'Horse', to_date('1997/04/12', 'yyyy/mm/dd'), 'M', NULL, NULL);
INSERT INTO Animal VALUES (1009, 'Ann', 'Horse', to_date('1999/02/20', 'yyyy/mm/dd'), 'F', 1002, NULL);
INSERT INTO Animal VALUES (1010, 'Aly', 'Horse', to_date('1999/08/23', 'yyyy/mm/dd'), 'F', 1002, NULL);
INSERT INTO Animal VALUES (1011, 'Rambo', 'Monkey', to_date('1999/04/23', 'yyyy/mm/dd'), 'M', 1001, 1004);
INSERT INTO Animal VALUES (1012, 'Tarzan', 'Horse', to_date('1999/11/12', 'yyyy/mm/dd'), 'M', 1003, NULL);
INSERT INTO Animal VALUES (1013, 'Zaza', 'Monkey', to_date('1999/12/22', 'yyyy/mm/dd'), 'M', 1001, 1006);
INSERT INTO Animal VALUES (1014, 'Tom', 'Horse', to_date('2000/02/02', 'yyyy/mm/dd'), 'M', 1002, 1009);
INSERT INTO Animal VALUES (1015, 'Ann', 'Horse', to_date('2000/02/12', 'yyyy/mm/dd'), 'F', 1002, 1009);
INSERT INTO Animal VALUES (1016, 'Hank', 'Horse', to_date('2000/04/12', 'yyyy/mm/dd'), 'M', NULL, NULL);
INSERT INTO Animal VALUES (1017, 'Jerry', 'Horse', to_date('2001/04/12', 'yyyy/mm/dd'), 'M', 1003, 1009);
INSERT INTO Animal VALUES (1018, 'Abby', 'Monkey', to_date('2001/07/26', 'yyyy/mm/dd'), 'F', 1013, 1004);
INSERT INTO Animal VALUES (1019, 'Linda', 'Monkey', to_date('2002/04/26', 'yyyy/mm/dd'), 'F', 1013, 1006);
INSERT INTO Animal VALUES (1020, 'Ann', 'Monkey', to_date('2003/09/13', 'yyyy/mm/dd'), 'F', 1001, 1004);
INSERT INTO Animal VALUES (1021, 'Tweety', 'Horse', to_date('2004/09/12', 'yyyy/mm/dd'), 'F', NULL, NULL);
INSERT INTO Animal VALUES (1022, 'Mary', 'Horse', to_date('2005/11/14', 'yyyy/mm/dd'), 'F', 1002, 1009);
INSERT INTO Animal VALUES (1023, 'Ann', 'Monkey', to_date('2009/11/14', 'yyyy/mm/dd'), 'F', 1013, 1006);