Note: 数据库原理与应用P113 sql表创建

CREATE TABLE Student(
	Sno Char(3) NOT NULL PRIMARY KEY,
	Sname CHAR(3) NOT NULL,
	Ssex CHAR(2) NOT NULL,
	Sbirthday datetime,
	Class CHAR(5)
)

CREATE TABLE Teacher(
		Tno CHAR(3) PRIMARY KEY,
		Tname CHAR(4) NOT NULL,
		Tsex CHAR(2) NOT NULL,
		Tbirthday datetime,
		Prof CHAR(6),
		Depart VARCHAR(10) NOT NULL
)

CREATE TABLE Course(
	Cno CHAR(5) NOT NULL PRIMARY KEY,
	Cname VARCHAR(10) NOT NULL,
	Tno CHAR(3) NOT NULL,
	FOREIGN KEY (Tno) REFERENCES Teacher(Tno)
	)

CREATE TABLE Score(
		Sno CHAR(3) NOT NULL,
		Cno CHAR(5) NOT NULL,
		Degree Decimal(4,1)
		FOREIGN KEY (Sno) REFERENCES Student(Sno),
		FOREIGN KEY (Cno) REFERENCES Course(Cno)
)