无标题1.sql

学生管理系统

CREATE DATABASE STUDENT
GO

USE STUDENT
GO

CREATE TABLE Student
        (Sno    CHAR(20)   Primary key, 
         Sname  CHAR(20)  UNIQUE,        
         Ssex      CHAR(2),
         Snation   CHAR(2),
         birthday  DATETIME,
         entertime CHAR(6),
         class  CHAR(10),
         home  CHAR(40),
         other   CHAR(10)
       )
GO

insert into Student values('20064051401','张海英','女','汉','1985-10-10','2006','B06514','北京','团员')
Insert into Student values('20064051402','喻欢','男','汉','1989-5-16','2006','B06514','江西','团员')
Insert into Student values('20064051403','吴娟','女','汉','1986-6-12','2006','B06514','云南','团员')
Insert into Student values('20064051405','唐小波','男','汉','1986-7-22','2006','B06514', '四川','团员')
Insert into Student values('20064051406','唐洪江','男','汉','1986-11-26','2006','B06514','河北','党员')
Insert into Student values('20064051407','孙晓哲','女','汉','1986-7-5','2006','B06514','河北','团员')
Insert into Student values('20064051408','陈琦','男','汉','1986-8-9','2006','B06514','河北','党员')
Insert into Student values('20064051409','沈小翠','女','汉','1987-11-21','2006','B06514','河北','团员')


CREATE  TABLE Course(
         
          Cno CHAR(5) Primary key,
          Cname  CHAR(20),
          teacher CHAR(20),
          lacation CHAR(6),
          Credit  int)

INSERT INTO Course VALUES('1','数据库','李伟红''8517',4)
INSERT INTO Course VALUES('2','数学','翟秀娜','8222',2)
INSERT INTO Course VALUES('3','信息系统','贾振华','8413',4)
INSERT INTO Course VALUES('4','操作系统','李新荣','8525',3)
INSERT INTO Course VALUES('5','数据结构','李建义','8623',4)
INSERT INTO Course VALUES('6','数据处理','荆淑霞','8302',2)
INSERT INTO Course VALUES('7','PASCAL语言','邓振杰','8623',4)   

select *
from STUDENT