数据库建表代码.txt

java+SQLServer2005编写的学生学籍管理系统

CREATE TABLE class(
	class_No int PRIMARY KEY,
	grade int,
	director char(10),
	classroom_No char(10)
) 


CREATE TABLE [course](
	course_No int PRIMARY KEY,
	course_Name varchar(50),
	course_Type char(10),
	course_Des char(50)
)


CREATE TABLE [gradecourse](
	grade char(10),
	course_Name char(20)
)


CREATE TABLE result(
	exam_No char(10),
	student_ID int,
	student_Name varchar(50),
	class_No int NULL,
	course_Name varchar(50),
	result float
) 




CREATE TABLE student(
	student_ID int PRIMARY KEY,
	student_Name varchar(50) UNIQUE,
	student_Sex char](2),
	born_Date datetime,
	class_NO int,
	tele_Number varchar(50),
	ru_Date datetime],
	address varchar(50),
	comment varchar(200)
)



CREATE TABLE users(
	username varchar(50) PRIMARY KEY,
	pwd varchar(50),
	power varchar(50)
)