CREATE TABLE STUDENT
(
SID INT PRIMARY KEY IDENTITY,
SNAME NVARCHAR(50),
SAGE DATETIME,
SSEX CHAR(4)
)
CREATE TABLE TEACHER
(
TID INT PRIMARY KEY IDENTITY,
TNAME NVARCHAR(50)
)
CREATE TABLE COURSE
(
CID INT PRIMARY KEY IDENTITY,
CNAME NVARCHAR(50),
TID INT FOREIGN KEY REFERENCES TEACHER(TID)
)
CREATE TABLE SCORE
(
ID INT PRIMARY KEY IDENTITY,
SID INT FOREIGN KEY REFERENCES STUDENT(SID),
CID INT FOREIGN KEY REFERENCES COURSE(CID),
SCORES INT
)
CREAT