数据库开发技术视频.rar

CREATE DATABASE TeachingManagement ON ( NAME = TeachingManagement_dat, FILENAME = 'c:\lzh\database\TeachingManagement.mdf', SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 ) LOG ON ( NAME = TeachingManagement_log, FILENAME = ' c:\lzh\database\TeachingManagement.ldf', SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB ) CREATE TABLE Department (DepartmentID tinyint PRIMARY KEY, DepartmentName nvarchar(30) UNIQUE NOT NULL, LeaderName nvarchar(10) null, Office nvarchar(50) null ) CREATE TABLE Student ( StudentID nvarchar(10) PRIMARY KEY, DepartmentID tinyint NOT NULL FOREIGN KEY REFERENCES Department(DepartmentID), StudentName nvarchar(10) NOT NULL, Sex nvarchar(2) CHECK (Sex='男' OR Sex='女'), BirthDay datetime null, ComeFrom nvarchar(20) null, Status nvarchar(4) CHECK (Status IN ('正常','留级','休学','退学')) ) CREATE TABLE Teacher (TeacherID nvarchar(10) PRIMARY KEY, DepartmentID tinyint NOT NULL FOREIGN KEY REFERENCES Department(DepartmentID), TeacherName nvarchar(10) NOT NULL, Sex nvarchar(2) CHECK (Sex='男' OR Sex='女'), BirthDay datetime null, Title nvarchar(6) CHECK (Title IN ('教授','副教授','讲师','助教')), Major nvarchar(20) null) CREATE TABLE Course (CourseID nvarchar(10) PRIMARY KEY, CourseName nvarchar(30) NOT NULL, CourseHours tinyint NOT NULL, CourseType nvarchar(8) CHECK (CourseType IN ('公共基础','专业基础','专业选修','任意选修')), DutyTeacherID nvarchar(10) FOREIGN KEY REFERENCES Teacher(TeacherID) ) CREATE TABLE RegisteredCourse (StudentID nvarchar(10) REFERENCES Student(StudentID), CourseID nvarchar(10) REFERENCES Course(CourseID), Score tinyint CHECK (Score BETWEEN 0 AND 100) DEFAULT NULL Primary Key (StudentID,CourseID) ) Insert into Department values (1,'信息管理学院','李嘉','教一楼1层') Insert into Department values (2,'经济管理学院','吴鸿忠','教三楼1层') Insert into Department values (3,'机电工程学院','刘利国','教二楼1层') Insert into Department values (4,'自动化学院','张敦儒','教三楼2层') Insert into Department values (5,'计算机学院','王晓华','教三楼5层') Insert into Department values (6,'外国语学院','肖金忠','教一楼3层') Insert into Department values (7,'理学院','邱国忠','教二楼6层') Insert into Department values (8,'体育部','文天阳','教五楼2层') Insert into Student values ('04014101',1,'曹波','男','19900731','湖北','正常') Insert into Student values ('04014111',1,'程鸣','女','19900601','湖南','正常') Insert into Student values ('04014122',1,'吴红霞','女','19900504','浙江','正常') Insert into Student values ('04026205',2,'张鸿飞','男','19900308','北京','正常') Insert into Student values ('04026210',2,'张雪梅','女','19900601','贵州','正常') Insert into Student values ('04016108',1,'林报国','男','19901025','上海','正常') Insert into Student values ('04016116',1,'王丽','女','19901111','北京','正常') Insert into Student values ('05113102',3,'郝海涛','男','19901201','河南','正常') Insert into Student values ('05113110',3,'王伟','男','19901201','北京','正常') Insert into Teacher values ('000101',1,'王霞','女','19780704','讲师','信息管理与信息系统') Insert into Teacher values ('000102',1,'刘力','男','19780704','教授','信息管理与信息系统') Insert into Teacher values ('000103',1,'李达','男','19660109','讲师','计算机应用') Insert into Teacher values ('000201',2,'吴凡','男','19861003','助教','信息安全') Insert into Teacher values ('000202',2,'陈丹','女','19700809','讲师','管理科学与工程') Insert into Teacher values ('000301',3,'赵倩','女','19710228','讲师','技术经济及管理') Insert into Teacher values ('000302',3,'钱枫','男','19650308','教授','工业设计') Insert into Teacher values ('000401',4,'孙天','女','19761212','副教授','车辆工程') Insert into Teacher values ('000501',5,'周海','男','19780908','讲师','自动化') Insert into Teacher values ('000502',5,'郑爽','女','19780704','讲师','计算机软件') Insert into Course values ('B00016','数据库',56,'专业基础','000102') Insert into Course values ('B00018','系统分析与设计',48,'专业基础','000101') Insert into Course values ('B00101','运筹学',56,'专业基础','000202') Insert into Course values ('X00201','信息资源管理',32,'专业选修','000102') Insert into Course values ('B00221','经济学原理',56,'专业基础','000202') Insert into Course values ('X00206','系统开发工具与环境',48,'专业选修',NULL) Insert into RegisteredCourse values ('04014122','B00016',88) Insert into RegisteredCourse values ('04014122','B00018',98) Insert into RegisteredCourse values ('04014122','B00101',76) Insert into RegisteredCourse values ('04014122','X00201',55) Insert into RegisteredCourse values ('04014122','B00221',89) Insert into RegisteredCourse values ('04014111','B00101',90) Insert into RegisteredCourse values ('04014111','X00201',NULL) Insert into RegisteredCourse values ('04014111','B00016',NULL) Insert into RegisteredCourse values ('04014101','B00018',NULL) Insert into RegisteredCourse values ('04014101','B00016',66) Insert into RegisteredCourse values ('04016116','B00016',22) 5.3 TeachingManagementDataSetTableAdapters.TeacherTableAdapter teacherTableAdapter = new TeachingManagementDataSetTableAdapters.TeacherTableAdapter(); TeachingManagementDataSet.TeacherDataTable teachers; teachers = teacherTableAdapter.GetData(); dataGridView1.DataSource = teachers; 5.4 BindingSource teacherBindingSource=new BindingSource(); BindingSource departmentBindingSource=new BindingSource(); teacherBindingSource.DataSource = (new TeachingManagementDataSetTableAdapters.TeacherTableAdapter()).GetData(); departmentBindingSource.DataSource = (new TeachingManagementDataSetTableAdapters.DepartmentTableAdapter()).GetData(); comboBox1.DataSource = departmentBindingSource; comboBox1.DisplayMember = "DepartmentName"; comboBox1.ValueMember = "DepartmentID";