实验要求:
1,创建 Student 数据库,包括 Students,Courses,SC 表,表结构如下:
Students(SNO,SNAME,SEX,BDATE,HEIGHT,DEPARTMENT)
Courses(CNO,CNAME,LHOUR,CREDIT,SEMESTER)
SC(
SNO,CNO
,GRADE)
(注:下划线表示主键,斜体表示外键),并插入一定数据。
SQL 语句:
Create TABLE Students
(SNO CHAR(9) PRIMARY KEY, SNAME CHAR(20), SEX CHAR(10),
BDATE DATE, HEIGHT FLOAT(3), DEPARTMENT CHAR(20) );
Create TABLE Courses
(CNO CHAR(9) PRIMARY KEY, CNAME CHAR(20), LHOUR FLOAT(3),
CREDIT FLOAT(2), SEMESTER CHAR(20));
Create TABLE SC
(
SNO CHAR(20), CNO CHAR(20), GRADE INT,
PRIMARY KEY(SNO,CNO)
);
评论0