INSERT INTO Scientist VALUES('i.shadforth@bixsolutions.net','Ian','Shadforth','Dr.','Diagnostics',44,07700,900349);
INSERT INTO Scientist VALUES('c.bessant@bixsolutions.net','Conrad','Bessant','Dr.','Toxicology',44,0117,4690808);

INSERT INTO Scientist VALUES('d.oakley@bixsolutions.net','Darren','Oakley','Mr.','Toxicology',44,0117,4691111);
INSERT INTO Supplier
VALUES('Experiments_R_US','Floor 12','Test Tube Towers','Bletchley','Oxford','OX0 1TT','UK');

INSERT INTO Supplier
VALUES('Generic Chem Team','10a','All Hallows','Central','Oxford','OX3 4UV','UK');
INSERT INTO Supplier
VALUES('Epsilon Chemicals','100','Camberley Terrace','Milton','Cambridge','CB20 2LG','UK');
INSERT INTO Kit
VALUES('The Epsilon Kit Company','Basic PCR Kit 1','19.99','Perkin Elmer Cetus',300,'Taq polymerase',
200,'dNTP',200);
INSERT INTO Kit
VALUES('The Epsilon Kit Company','Basic PCR Kit 2','29.99','Chamberlain DMD Buffer',6000,
'Taq polymerase',200,'dNTP',6000);
INSERT INTO Kit
VALUES('Simply Solutions','PCR Visual Dye Kit','49.99','Perkin Elmer Cetus',300,'GreenTaq',200,
'dNTP',300);
INSERT INTO Kit_order
VALUES(00000001,'The Epsilon Kit Company','Basic PCR Kit 1','Epsilon Chemicals');
INSERT INTO Kit_order
VALUES(00000121,'The Epsilon Kit Company','Basic PCR Kit 1','Epsilon Chemicals');
INSERT INTO Kit_order
VALUES(00000115,'The Epsilon Kit Company','Basic PCR Kit 2','Epsilon Chemicals');
INSERT INTO Kit_order
VALUES(00000380,'Simply Solutions','PCR Visual Dye Kit','Experiments_R_US');
INSERT INTO Experiment
VALUES(null,20071210,153000,'GTCAAACTGTTCTTGTCAATCTCACAGGCTCCTGGTTGTCTACCCATGGACCCAGAGGTT',
'Test for hemoglobin',00000001,95,1,54,1,72,1,40,72,1,'AAAGTCCAGGTCGCTTCTCA','GCAAGAAGGTGCTGACTTCC',
10,'Primer3','Prime Primers Ltd.',10.00,null,'Worked well','i.shadforth@bixsolutions.net');

INSERT INTO Experiment
VALUES(null,20071211,110830,'GTCAAACTGTTCTTGTCAATCTCACAGGCTCCTGGTTGTCTACCCATGGACCCAGAGGTT',
'Comparing Basic Kit 1 to Basic Kit 2 for hemoglobin',00000115,95,1,74,1,72,1,40,72,1,
'AAAGTCCAGGTCGCTTCTCA','GCAAGAAGGTGCTGACTTCC',
10,'Primer3','Prime Primers Ltd.',10.00,null,'No appreciable difference seen',
'i.shadforth@bixsolutions.net');
INSERT INTO Experiment
VALUES(null,20080214,213000,'GTCAAACTGTTCTTGTCAATCTCACAGGCTCCTGGTTGTCTACCCATGGACCCAGAGGTT',
'Quick test of the Green Dye system on hemoglobin',00000380,95,1,54,1,72,1,40,72,1,
'AAAGTCCAGGTCGCTTCTCA','GCAAGAAGGTGCTGACTTCC',
10,'Primer3','Prime Primers Ltd.',10.00,null,'May be useful in some circumstances',
'c.bessant@bixsolutions.net');
INSERT INTO Experiment
VALUES(null,20080112,091500,'AAAACCAAGTGAAAGAAAAATACTCATTTGTATCTGAAGTGGAACCAAATGATACTGATCCATTAGATTCAAATGTAGCAAATCAGAAGCCCTTTGAGAGTGGAAGTGACAAAATCTCCA',
'Searching for BRCA2 content',
00000121,95,1,54,1,72,1,40,72,1,'AGCAAACGCTGATGAATGTG','ACCATTCACAGGCCAAAGAC',
10,'Primer3','Prime Primers Ltd.',15.00,null,'Experiment did not work - possible kit problem',
'd.oakley@bixsolutions.net');
INSERT INTO Experiment
VALUES(null,20080112,091500,'AAAACCAAGTGAAAGAAAAATACTCATTTGTATCTGAAGTGGAACCAAATGATACTGATCCATTAGATTCAAATGTAGCAAATCAGAAGCCCTTTGAGAGTGGAAGTGACAAAATCTCCA',
'Repeat searching for BRCA2 content using older kit',
00000001,95,1,54,1,72,1,40,72,1,'AGCAAACGCTGATGAATGTG','ACCATTCACAGGCCAAAGAC',
10,'Primer3','Prime Primers Ltd.',15.00,null,'Experiment worked - possible kit problem for order 00000121','d.oakley@bixsolutions.net');