Держи студент:
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `exams`
-- ----------------------------
DROP TABLE IF EXISTS `exams`;
CREATE TABLE `exams` (
`ID` BIGINT(20) NOT NULL AUTO_INCREMENT,
`SubjectID` BIGINT(1) NOT NULL,
`GroupID` BIGINT(20) NOT NULL,
`TeacherID` BIGINT(20) NOT NULL,
`Date` datetime NOT NULL,
PRIMARY KEY (`ID`),
KEY `GroupID_Group` (`GroupID`),
KEY `TeacherID_Teacher` (`TeacherID`),
KEY `SubjectID_Subject` (`SubjectID`),
CONSTRAINT `GroupID_Group` FOREIGN KEY (`GroupID`) REFERENCES `groups` (`ID`),
CONSTRAINT `SubjectID_Subject` FOREIGN KEY (`SubjectID`) REFERENCES `subjects` (`ID`),
CONSTRAINT `TeacherID_Teacher` FOREIGN KEY (`TeacherID`) REFERENCES `teachers` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of exams
-- ----------------------------
INSERT INTO `exams` VALUES ('1', '1', '1', '1', '2013-03-14 08:00:00');
INSERT INTO `exams` VALUES ('2', '2', '1', '2', '2013-03-15 16:00:00');
INSERT INTO `exams` VALUES ('3', '3', '2', '3', '2013-03-15 08:00:00');
-- ----------------------------
-- Table structure for `groups`
-- ----------------------------
DROP TABLE IF EXISTS `groups`;
CREATE TABLE `groups` (
`ID` BIGINT(20) NOT NULL AUTO_INCREMENT,
`Name` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of groups
-- ----------------------------
INSERT INTO `groups` VALUES ('1', 'Группа 123432');
INSERT INTO `groups` VALUES ('2', 'Группа 234123');
INSERT INTO `groups` VALUES ('3', 'Группа 663422');
-- ----------------------------
-- Table structure for `subjects`
-- ----------------------------
DROP TABLE IF EXISTS `subjects`;
CREATE TABLE `subjects` (
`ID` BIGINT(20) NOT NULL AUTO_INCREMENT,
`Name` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of subjects
-- ----------------------------
INSERT INTO `subjects` VALUES ('1', 'История');
INSERT INTO `subjects` VALUES ('2', 'Алгебра');
INSERT INTO `subjects` VALUES ('3', 'Геометрия');
INSERT INTO `subjects` VALUES ('4', 'Черчение');
INSERT INTO `subjects` VALUES ('5', 'Химия');
-- ----------------------------
-- Table structure for `teachers`
-- ----------------------------
DROP TABLE IF EXISTS `teachers`;
CREATE TABLE `teachers` (
`ID` BIGINT(20) NOT NULL AUTO_INCREMENT,
`Name` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of teachers
-- ----------------------------
INSERT INTO `teachers` VALUES ('1', 'Александр Петрович Груздь');
INSERT INTO `teachers` VALUES ('2', 'Николай Иванович Мастдай');
INSERT INTO `teachers` VALUES ('3', 'Семен Андреевич Зеленый');
INSERT INTO `teachers` VALUES ('4', 'Эльдар Владимирович Пеший');
INSERT INTO `teachers` VALUES ('5', 'Зинаида Ивановна Вашковская');
Code: SQL