--开设3个班级：软件一班、软件二班、计算机应用技术班
create database Class;
create table Class(  
	ClassId int not null identity(1,1),
	ClassName nvarchar(50) not null
);
insert into Class (ClassName) values ('软件一班');
insert into Class (ClassName) values ('软件二班');
insert into Class (ClassName) values ('计算机应用技术班');

select * from Class;

	--软件一班开设课程
	create database Course;
create table Course(
	CourseId int identity(1,1),
	CourseName nvarchar(50),
	CourseCredit int
);
insert into Course ( CourseName,CourseCredit) values ('数据库高级应用', 3)
	,('javascript编程基础', 3)
	,('web前端程序设计基础', 4)
	,('动态网页设计.net基础', 6);
	select * from Course;

	--	--软件二班开设课程
	insert into Course (CourseName,CourseCredit) values  ('数据库高级应用', 3)
	,('javascript编程基础', 3)
	,('web前端程序设计基础', 4)
	,('动态网页设计.net基础', 6);

----计算机应用技术班开设课程
	insert into Course (CourseName,CourseCredit) values  ('数据库高级应用', 3)
	,('javascript编程基础', 3)
	,('web前端程序设计基础', 4)
	,('动态网页设计.net基础', 6);

--软件一班有3个同学
create database Student;
create table Student (
	StudentId int not null identity(1, 1),
	StudentName nvarchar(50),
	StudentSex tinyint not null,
	StudentBirth date,
	StudentAddress nvarchar(255) not null
);
drop table student;
insert into Student (StudentName, StudentSex, StudentBirth, StudentAddress, ClassId) 
    values ('刘正',1,'2000-01-01','广西省桂林市七星区空明西路10号鸾东小区', 1);
insert into Student (StudentName, StudentSex, StudentBirth, StudentAddress, ClassId) 
    values ('黄贵',1,'2001-03-20','江西省南昌市青山湖区艾溪湖南路南150米广阳小区', 1);
insert into Student (StudentName, StudentSex, StudentBirth, StudentAddress, ClassId) 
    values ('陈美',2,'2000-07-08','福建省龙岩市新罗区曹溪街道万达小区', 1);

		select * from Student;
		select * from Class;

	--软件二班有2个同学

insert into Student (StudentName, StudentSex, StudentBirth, StudentAddress, ClassId) 
    values ('江文',1,'2000-08-10','安徽省合肥市庐阳区四里河路与潜山路交汇处万科城市之光', 2)
		, ('钟琪',2,'2001-03-21','湖南省长沙市雨花区红花坡社区', 2);

	--计算机应用技术班有4个同学
insert into Student (StudentName, StudentSex, StudentBirth, StudentAddress, ClassId) 
    values ('曾小林',1,'1999-12-10','安徽省合肥市庐阳区四里河路与潜山路交汇处万科城市之光', 3)
		,('欧阳天天',2,'2000-04-05','湖北省武汉市洪山区友谊大道与二环线交汇处融侨悦府', 3)
		,('徐长卿',1,'2001-01-30','江苏省苏州市苏州工业园区独墅湖社区', 3)
		,('李逍遥',1,'1999-11-11','广东省广州市白云区金沙洲岛御洲三街恒大绿洲', 3);

--- 东方不败 保密 1999-12-11 河北省平定州西北四十余里的猩猩滩
--	- 令狐冲 男 2000-08-11 陕西省渭南市华阴市玉泉路南段
	insert into Student (StudentName, StudentSex, StudentBirth, StudentAddress, ClassId) 
    values ('东方不败',3,'1999-12-11','河北省平定州西北四十余里的猩猩滩', 0);
	insert into Student (StudentName, StudentSex, StudentBirth, StudentAddress, ClassId) 
    values ('令狐冲',1,'2000-08-11','陕西省渭南市华阴市玉泉路南段', 0);