CREATE TABLE `class` (
`Cno` char(10) NOT NULL,
`Fno` int(4) NOT NULL,
`Pname` char(20) CHARACTER SET gb2312 NOT NULL,
`Ctime` year(4) DEFAULT '0000',
`Camount` int(10) NOT NULL,
PRIMARY KEY (`Cno`),
KEY `class_ibfk_1` (`Fno`),
CONSTRAINT `class_ibfk_1` FOREIGN KEY (`Fno`) REFERENCES
`faculty` (`Fno`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
C.建立系表 faculty
DROP TABLE IF EXISTS `faculty`;
CREATE TABLE `faculty` (
`Fno` int(4) NOT NULL,
`Fname` char(20) CHARACTER SET gb2312 NOT NULL,
`Foffice` char(20) CHARACTER SET gb2312 DEFAULT NULL,
`Fresidence` char(20) CHARACTER SET gb2312 NOT NULL,
`Famount` int(10) NOT NULL,
PRIMARY KEY (`Fno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
D.建立学生组织表 organization
DROP TABLE IF EXISTS `organization`;
CREATE TABLE `organization` (
`Ono` int(4) NOT NULL,
`Oname` char(20) CHARACTER SET gb2312 NOT NULL,
`Osetup` year(4) NOT NULL,
`OSite` char(20) CHARACTER SET gb2312 DEFAULT NULL,
PRIMARY KEY (`Ono`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
E.建立学生表 student
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`Sno` char(10) NOT NULL,
`Sname` char(15) CHARACTER SET gb2312 NOT NULL,
`Ssex` enum('m','f') NOT NULL DEFAULT 'm',
`Sage` int(4) NOT NULL,
`Cno` char(10) NOT NULL,
PRIMARY KEY (`Sno`),
KEY `Cno` (`Cno`),
CONSTRAINT `student_ibfk_1` FOREIGN KEY (`Cno`) REFERENCES
评论0