课设数据表.txt

学生管理系统

CREATE DATABASE STUDENT
GO
-----------学生表
USE STUDENT
GO

CREATE TABLE Student
        (Sno    CHAR(15)   Primary key, 
         Sname  CHAR(10)  UNIQUE,        
         Ssex     CHAR(2),
         nation   CHAR(2),
         birthday  DATETIME,
         year     CHAR(6),
         home  CHAR(5),
         other   CHAR(10)
       )
GO

insert into Student values('20064051401','张海英','女','汉','1985-10-10','2006', '北京','团员')
Insert into Student values('20064051402','喻欢','男','汉','1989-5-16','2006', '江西','团员')
Insert into Student values('20064051403','吴娟','女','汉','1986-6-12','2006','云南','团员')
Insert into Student values('20064051404','唐小波','男','汉','1986-7-22','2006', '四川','团员')
Insert into Student values('20064051406','唐洪江','男','汉','1986-11-26','2006','河北','党员')
Insert into Student values('20064051407','孙晓哲','女','汉','1986-7-5','2006', '河北','团员')
Insert into Student values('20064051408','陈琦','男','汉','1986-8-9','2006', '河北','党员')
Insert into Student values('20064051409','沈小翠','女','汉','1987-11-21','2006', '河北','团员')
----------课程表
CREATE  TABLE Course(
         
          Cno CHAR(5) Primary key,
          Cname  CHAR(20),
          period   int,
          Credit   int,
          Style    char(10),
          number   int,
          des    CHAR(500))

INSERT INTO Course VALUES('1','数据库',80,4,'科学类',10,'简单介绍数据库基础知识及SOL语句的简单应用')
INSERT INTO Course VALUES('2','数学',60,2,'科学类',10,'讲解有关微积分的应用')
INSERT INTO Course VALUES('3','C++',60,3,'科学类',17,'C++语言基础知识')
INSERT INTO Course VALUES('4','计算机组成原理',84,2,'科学类',8,'计算机基本组成及工作原理')
INSERT INTO Course VALUES('5','ENGLISH',60,4,'人文类',10,'基础英语知识')
INSERT INTO Course VALUES('6','数字电路',60,4,'科学类',20,'基础数字电路知识介绍')   
INSERT INTO Course VALUES('7','电路基础',60,4,'科学类',12,'基本电路的分析及应用')

-----教师表
CREATE TABLE TEACHER(
          Tno  CHAR(5) primary key,
          Tname CHAR(15),
          Tsex CHAR(5),
          Title CHAR(10))
 
GO

INSERT INTO TEACHER VALUES('001','郑元畅','男','教授')
INSERT INTO TEACHER VALUES('002','吴尊','男','教授')
INSERT INTO TEACHER VALUES('003','林依晨','女','副教授')
INSERT INTO TEACHER VALUES('004','贺军翔','男','讲师')






-----------学生选课表
CREATE TABLE SC(
            Sno CHAR(15)  REFERENCES STUDENT(Sno),
            Cno CHAR(5)   REFERENCES COURSE(Cno),
            score int, 
            Primary key (Sno, Cno))

insert into sc values('20064051409','1',88)
insert into sc values('20064051401','2',80)
insert into sc values('20064051402','3',78)
insert into sc values('20064051405','4',86)
insert into sc values('20064051406','6',92)
insert into sc values('20064051406','5',85)
insert into sc values('20064051407','7',88)
insert into sc values('20064051408','8',90)
insert into sc values('20064051409','4',92)
insert into sc values('20064051402','1',78)
insert into sc values('20064051403','1',78)

-------------教师任课表
CREATE TABLE TC( 
    Tno  CHAR(5)  REFERENCES TEACHER(Tno),
    Cno  CHAR(5)  REFERENCES COURSE(Cno)
    PRIMARY KEY(Tno,Cno))

GO

INSERT INTO TC VALUES('001','1')
INSERT INTO TC VALUES('001','5')
INSERT INTO TC VALUES('002','2')
INSERT INTO TC VALUES('003','4')
INSERT INTO TC VALUES('003','3')
INSERT INTO TC VALUES('004','6')
INSERT INTO TC VALUES('003','7')
INSERT INTO TC VALUES('002','7')