USE master GO IF EXISTS (SELECT * FROM sysdatabases WHERE name='MyStudentInfoManage')DROP DATABASE  MyStudentInfoManage         --刪除數(shù)據(jù)庫GO CREATE DATABASE MyStudentInfoManage        --創(chuàng)建數(shù)據(jù)庫GO USE MyStudentInfoManageGO --學(xué)生表IF EXISTS(SELECT * FROM sysobjects WHERE name='Student')DROP TABLE Student        --刪除表GO CREATE TABLE Student(   --  Student(S#,Sname,Sage,Ssex) 學(xué)生表      S# INT NOT NULL PRIMARY KEY ,     --學(xué)號     Sname NVARCHAR(20) NOT NULL,      --姓名     Sage INT NOT NULL ,               --年齡     Ssex CHAR(2) NOT NULL             --性別                             );--教師表IF EXISTS(SELECT * FROM sysobjects WHERE name='Teacher')DROP TABLE TeacherGO CREATE TABLE Teacher(  --Teacher(T#,Tname) 教師表  T# INT NOT NULL PRIMARY KEY,  Tname NVARCHAR(20) NOT NULL  );--課程表IF EXISTS(SELECT * FROM sysobjects WHERE name='Course')DROP TABLE CourseGO CREATE TABLE  Course(   --Course(C#,Cname,T#) 課程表    C# INT NOT NULL PRIMARY KEY ,   Cname NVARCHAR(20) NOT NULL ,   T# INT NOT NULL  REFERENCES dbo.Teacher(T#)  );--成績表IF EXISTS(SELECT * FROM sysobjects WHERE name='SC')DROP TABLE SCGO CREATE TABLE SC(        --SC(S#,C#,score) 成績表         S# INT NOT NULL REFERENCES dbo.Student(S#),        C# INT NOT NULL REFERENCES dbo.Course(C#),        Score INT NOT NULL,        CONSTRAINT FK_Student_Course PRIMARY  KEY(S#,C#)    --學(xué)號和課程號同時座位            );----------------------------------------------------------------------插入測試數(shù)據(jù)到數(shù)據(jù)表(Student)中--------------------------------------------DELETE FROM dbo.Student;INSERT INTO dbo.Student        ( S#, Sname, Sage, Ssex )VALUES  ( 001, -- S# - int          N'張三', -- Sname - nvarchar(20)          20, -- Sage - int          '男'  -- Ssex - char(2)          )          INSERT INTO dbo.Student        ( S#, Sname, Sage, Ssex )VALUES  ( 002, -- S# - int          N'李四', -- Sname - nvarchar(20)          21, -- Sage - int          '男'  -- Ssex - char(2)          ) INSERT INTO dbo.Student        ( S#, Sname, Sage, Ssex )VALUES  ( 003, -- S# - int          N'王五', -- Sname - nvarchar(20)          22, -- Sage - int          '女'  -- Ssex - char(2)          ) INSERT INTO dbo.Student        ( S#, Sname, Sage, Ssex )VALUES  ( 004, -- S# - int          N'周六', -- Sname - nvarchar(20)          18, -- Sage - int          '女'  -- Ssex - char(2)          )                          ------------------------------------------------------------插入數(shù)據(jù)到教師表(Teacher)中----------------------------------------------------------DELETE FROM dbo.Teacher;          INSERT INTO dbo.Teacher        ( T#, Tname )VALUES  ( 01, -- T# - int          N'葉平'  -- Tname - nvarchar(20)          )                ------------------------------------------------------------------插入數(shù)據(jù)到課程表中-------------------------------------------------------------DELETE FROM dbo.Course;INSERT INTO dbo.Course        ( C#, Cname, T# )VALUES  ( 001, -- C# - int          N'語文', -- Cname - nvarchar(20)          01  -- T# - int          )              INSERT INTO dbo.Course        ( C#, Cname, T# )VALUES  ( 002, -- C# - int          N'數(shù)學(xué)', -- Cname - nvarchar(20)          01  -- T# - int          )                         INSERT INTO dbo.Course        ( C#, Cname, T# )VALUES  ( 0003, -- C# - int          N'英語', -- Cname - nvarchar(20)          01  -- T# - int          )                                            --------------------------插入數(shù)據(jù)到成績表（SC）中-----------------------------------------------------------------------------------------------  DELETE FROM dbo.SC;              INSERT INTO dbo.SC        ( S#, C#, Score )VALUES  ( 001, -- S# - int          001, -- C# - int          90  -- Score - int          )