Shock

CREATE TABLE `Division` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT,
  `Name` VARCHAR(32) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

INSERT INTO `Division` (`ID`, `Name`) VALUES
(1, 'First'),
(2, 'Second');

CREATE TABLE `Employee` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT,
  `Name` VARCHAR(32) NOT NULL,
  `DivisionID` INT(11) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `DivisionID` (`DivisionID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

INSERT INTO `Employee` (`ID`, `Name`, `DivisionID`) VALUES
(1, 'Andrew', 1),
(2, 'Arthur', 1),
(3, 'Atos', 1),
(4, 'Barbos', 1),
(5, 'Bores', 1),
(6, 'Tostor', 1),
(7, 'Rosor', 1),
(8, 'Coster', 1),
(9, 'Moster', 2),
(10, 'Lolor', 2);