create table Phy(
	id	int(4),
	name	VARCHAR(20),
	gender	CHAR(1),
	class	CHAR(2),
	PRIMARY KEY (id) 
);

create table Chem(
	id	int(4),
	name	VARCHAR(20),
	gender	CHAR(1),
	class	CHAR(2),
	PRIMARY KEY (id) 
);

create table Bio(
	id	int(4),
	name	VARCHAR(20),
	gender	CHAR(1),
	class	CHAR(2),
	PRIMARY KEY (id) 
);

create table Swim(
	id	int(4),
	event	VARCHAR(20)
);

insert into swim values
(9801,'100m Free Style'),
(9801,'50m Back Stroke'),
(9802,'50m Free Style'),
(9803,'50m Free Style'),
(9804,'50m Breast Style'),
(9805,'100m Free Style'),
(9807,'50m Free Style'),
(9808,'50m Free Style'),
(9809,'50m Breast Style'),
(9810,'100m Breast Style'),
(9811,'50m Free Style'),
(9812,'50m Breast Style'),
(9813,'50m Free Style'),
(9813,'50m Back Stroke'),
(9814,'50m Back Stroke'),
(9815,'50m Free Style'),
(9815,'100m Free Style'),
(9815,'50m Butterfly'),
(9817,'50m Free Style'),
(9818,'50m Free Style'),
(9819,'50m Breast Style'),
(9819,'50m Butterfly'),
(9820,'50m Free Style'),
(9821,'100m Free Style'),
(9828,'50m Free Style'),
(9828,'50m Breast Style');

insert into Phy values
(9801,'Peter','M','1A'),
(9802,'Mary','F','1A'),
(9812,'Aaron','M','1A'),
(9814,'Kenny','M','1B'),
(9815,'Eddy','M','1B'),
(9816,'Teddy','M','1B'),
(9822,'Janet','F','1B'),
(9823,'Queenie','F','1C'),
(9827,'Nancy','F','1C'),
(9704,'Susan','F','2A'),
(9706,'Franky','M','2B'),
(9719,'Josephine','F','2B'),
(9720,'Cindy','F','2C');

insert into Chem values
(9704,'Susan','F','2A'),
(9714,'Samual','M','2A'),
(9715,'Joseph','M','2A'),
(9716,'Linda','F','2B'),
(9801,'Peter','M','1A'),
(9803,'Johnny','M','1A'),
(9804,'Wendy','F','1B'),
(9805,'Tobe','M','1B'),
(9806,'Kitty','F','1B'),
(9807,'Eric','M','1C'),
(9808,'Patty','F','1C'),
(9812,'Aaron','M','1A'),
(9813,'Ron','M','1A'),
(9819,'Vincent','M','1C'),
(9825,'Laura','F','1C');

insert into Bio values
(9803,'Johnny','M','1A'),
(9805,'Tobe','M','1B'),
(9808,'Patty','F','1C'),
(9812,'Aaron','M','1A'),
(9822,'Janet','F','1B'),
(9704,'Susan','F','2A'),
(9709,'Yvonne','F','2C'),
(9713,'Tim','M','2A'),
(9718,'May','F','2B'),
(9722,'Flora','F','2C');
