1.DDL
CREATE TABLE `score` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`scoreName` varchar(255) NOT NULL,
`result` decimal(5,2) NOT NULL,
`studentId` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `studentId` (`studentId`),
CONSTRAINT `score_ibfk_1` FOREIGN KEY (`studentId`) REFERENCES `student` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;