· 8 years ago · Mar 15, 2018, 03:22 PM
1CREATE TABLE IF NOT EXISTS `Student` (`StudentId` VARCHAR(6) NOT NULL,`StudentName` VARCHAR(250) NOT NULL,`DegreeScheme` VARCHAR(250) NOT NULL,PRIMARY KEY (`StudentId`),FOREIGN KEY (`StudentId`) REFERENCES Registered(`StudentId`) ON DELETE CASCADE ON UPDATE CASCADE)ENGINE=MyISAM DEFAULT CHARSET=UTF8;