数据库上机实验1 数据库定义语言

1. CREATE DATABASE Homework
2. ON
3. (NAME=Homework_Data,
4. FILENAME='D:\HomeworkData.mdf',
5. SIZE=10,
6. MAXSIZE=500,
7. FILEGROWTH=10)
8. LOG ON
9. (NAME=Homework_Log,
10. FILENAME='D:\HomeworkData.ldf',
11. SIZE=5,
12. MAXSIZE=500,
13. FILEGROWTH=5)

1. ALTER DATABASE Homework
2. ADD FILE
3. (NAME=Homework_Datanew,
4. FILENAME='D:\Homework_Datanew.ndf',
5. SIZE=100,
6. MAXSIZE=200,
7. FILEGROWTH=10)

1. 创建学生表（Student）
2. Create table student
3. (sno char(4) not null primary key,
4. Sname varchar(20) not null,
5. Ssex char(2) not null check(ssex in('男','女')),
6. Major varchar(30) not null,
7. Birth date null,
8. Phone char(11) null)

1. 创建课程表（Course）
2. Create table course
3. (cno char(4) not null primary key,
4. Cname varchar(30) not null,
5. Credit numeric(3,1) not null,
6. Stime numeric(4,1) not null,
7. Tname varchar(20) null)

1. 创建学生作业表（Score）
2. Create table score
3. (cno char(4) not null,
4. Sno char(4) not null,
5. Cj1 numeric(4,1) null,
6. Cj2 numeric(4,1) null,
7. Cj3 numeric(4,1) null,
8. Primary key(cno,sno),
9. Foreign key(cno) references course(cno),
10. Foreign key(sno) references student(sno))
11. 5、alter table student
12. Add address nvarchar(20)

1. ALTER TABLE 学生表
2. ADD
3. Address NVARCHAR(20)