CREATE TABLE Student (S INT NOT NULL PRIMARY KEY, sname VARCHAR(20), sage tinyint , ssex bit --0表示男,1表示女 ) ENGINE=INNODB;CREATE TABLE Teacher ( T INT NOT NULL PRIMARY KEY, Tname VARCHAR(20) ) ENGINE=INNODB;CREATE TABLE Course ( c INT NOT NULL PRIMARY KEY, cname VARCHAR(20), T INT, CONSTRAINT FK_Teacher_T FOREIGN KEY T REFERENCES Teacher(T) ) ENGINE=INNODB;CREATE TABLE SC ( S INT, C INT, score INT ) ENGINE=INNODB;
(S INT NOT NULL PRIMARY KEY,
sname VARCHAR(20),
sage tinyint ,
ssex bit --0表示男,1表示女
) ENGINE=INNODB;CREATE TABLE Teacher
(
T INT NOT NULL PRIMARY KEY,
Tname VARCHAR(20)
) ENGINE=INNODB;CREATE TABLE Course
(
c INT NOT NULL PRIMARY KEY,
cname VARCHAR(20),
T INT,
CONSTRAINT FK_Teacher_T FOREIGN KEY T REFERENCES Teacher(T)
) ENGINE=INNODB;CREATE TABLE SC
(
S INT,
C INT,
score INT
) ENGINE=INNODB;
http://www.accessbbs.cn/bbs/viewthread.php?tid=18114