cqkBvqYM

1--
2-- Database: `university`
3--
4-- -------------------------------------------------------- 
5--
6-- Table structure for table `Student`
7--
8CREATE 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;
9--
10-- Table structure for table `Module`
11--
12CREATE TABLE IF NOT EXISTS `Module`(`ModuleId` VARCHAR(6) NOT NULL,`ModuleName` VARCHAR(250) NOT NULL,`Credits` INTEGER(3) NOT NULL,PRIMARY KEY (`ModuleId`),FOREIGN KEY (`ModuleId`) REFERENCES Registered(`ModuleId`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
13--
14-- Table structure for table `Staff`
15--
16CREATE TABLE IF NOT EXISTS `Staff` (`StaffId` VARCHAR(6) NOT NULL,`StaffName` VARCHAR(250) NOT NULL,`Grade` VARCHAR(100) NOT NULL,PRIMARY KEY (`StaffId`),FOREIGN KEY (`StaffId`) REFERENCES Teaches(`StaffId`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
17--
18-- Table structure for table `Registered`
19--
20CREATE TABLE IF NOT EXISTS `Registered` (`StudentId` VARCHAR(6) NOT NULL,`ModuleId` VARCHAR(6) NOT NULL,PRIMARY KEY (`StudentId`,`ModuleId`),FOREIGN KEY (`StudentId`) REFERENCES Student(`StudentId`) ON DELETE CASCADE ON UPDATE CASCADE,FOREIGN KEY(`ModuleId`) REFERENCES Module(`ModuleId`)ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
21-- 
22-- Table structure for table `Teaches`
23--
24CREATE TABLE IF NOT EXISTS `Teaches` (`StaffId` VARCHAR(6) NOT NULL,`ModuleId` VARCHAR(6) NOT NULL,PRIMARY KEY (`StaffId`,`ModuleId`),FOREIGN KEY (`StaffId`) REFERENCES Staff(`StaffId`) ON DELETE CASCADE ON UPDATE CASCADE,FOREIGN KEY(`ModuleId`) REFERENCES Module(`ModuleId`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=MyISAM DEFAULT CHARSET=UTF8;