数据库简单建库

建库:
CREATE DATABASE stu1
ON
(NAME=student_data, --数据库的逻辑名为student_data FILENAME='E:\sql_data\student_data.mdf ', --数据库的物理名
SIZE=10MB, --数据库的初始大小为10MB MAXSIZE=50MB, --数据库的最大容量为50MB FILEGROWTH=10% --数据库容量自动按10 %的比例增长
)
LOG ON
(NAME=stu_log, --日志文件的逻辑名为stu_log FILENAME='E:\sql_data\student_log.ldf ',
SIZE=2MB,
MAXSIZE=5MB,
FILEGROWTH=1MB
)
答案
建表:
create table student
(sno char(9) not null,
sname char(8),
ssex char(2),
sage smallint,
sdept char(2),
primary key(sno),
check(ssex in ('男','女')),
check(sage between 15 and 30));
create table course
(cno char(2) not null,
cname char(12),
cpno char(2),
ccredit decimal(1),
primary key(cno));
create table SC
(sno char(9) not null,
cno char(2) not null,
grade decimal(3),
primary key(sno,cno),
foreign key(sno) references student(sno),
foreign key(cno) references course(cno),
check(grade between 0 and 100));
插入记录:
insert into student values('200215121','李勇','男',20,'CS'); insert into student values('200215122','刘晨','女',19,'IS'); insert into student values('200215123','王敏','女',18,'MA'); insert into student values('200215125','张立','男',19,'IS');
insert into course values('1','数据库','5',4);
insert into course values('2','数学',null,2);
insert into course values('3','信息系统','1',4);
insert into course values('4','操作系统','6',3);
insert into course values('5','数据结构','7',4);
insert into course values('6','数据处理',null,2);
insert into course values('7','PASCAL语言','6',4);
insert into SC values('200215121','1',92);
insert into SC values('200215121','2',85);
insert into SC values('200215121','3',88);
insert into SC values('200215122','2',90);
insert into SC values('200215122','3',80);
select * from student;
select * from course;
select * from sc;。