SQL server実験一データ定義

/* 1       */
create table student
(	Sno char(10),
	Sname char(10),
	Ssex char(2),
	Sage smallint,
	Sdept char(20)
);

/* 2       */
create table course
(	Cno char(2),
	Cname char(30),
	Cterm char(2),
	Ccredit tinyint
);

/* 3       */
create table sc
(	Sno char(10),
	Cno char(2),
	Grade tinyint
);