CREATE DATABASE menagerie;
USE menagerie;
DROP TABLE IF EXISTS pet;
CREATE TABLE pet
(
name VARCHAR(20),
owner VARCHAR(20),
species VARCHAR(20),
sex CHAR(1),
birth DATE,
death DATE
);
INSERT INTO pet VALUES('Fluffy','Harold','cat','f','1993-02-04',NULL);
INSERT INTO pet VALUES('Claws','Gwen','cat','m','1994-03-17',NULL);
INSERT INTO pet VALUES('Buffy','Harold','dog','f','1989-05-13',NULL);
INSERT INTO pet VALUES('Fang','Benny','dog','m','1990-08-27',NULL);
INSERT INTO pet VALUES('Bowser','Diane','dog','m','1979-08-31','1995-07-29');
INSERT INTO pet VALUES('Chirpy','Gwen','bird','f','1998-09-11',NULL);
INSERT INTO pet VALUES('Whistler','Gwen','bird',NULL,'1997-12-09',NULL);
INSERT INTO pet VALUES('Slim','Benny','snake','f','1996-04-29',NULL);
INSERT INTO pet VALUES ('Puffball','Diane','hamster','f','1999-03-30',NULL);
DROP TABLE IF EXISTS event;
CREATE TABLE event
(
name VARCHAR(20),
date DATE,
type VARCHAR(15),
remark VARCHAR(255) DEFAULT NULL
);
INSERT INTO EVENT VALUES("Fluffy","1995-05-15","litter","4 kittens, 3 female, 1 male");
INSERT INTO EVENT VALUES("Buffy","1993-06-23","litter","5 puppies, 2 female, 3 male");
INSERT INTO EVENT VALUES("Chirpy","1999-03-21","vet","needed beak straightened");
INSERT INTO EVENT VALUES("Slim","1997-08-03","vet","broken rib");
INSERT INTO EVENT(name,date,type) VALUES("Bowser","1991-10-12","kennel");
INSERT INTO EVENT(name,date,type) VALUES("Fang","1991-10-12","kennel");
INSERT INTO EVENT VALUES("Fang","1998-08-28","birthday","Gave him a new chew toy");
INSERT INTO EVENT VALUES("Claws","1998-03-17","birthday","Gave him a new flea collar");
INSERT INTO EVENT VALUES("Whistler","1998-12-09","birthday","First birthday");