第1个回答 2018-10-09
create table sc --创建表sc
(sno char(7) foreign key references student(sno), --加外键约束
cno char(10) foreign key references course(cno), --加外键约束
grade int check (grade between 0 and 100)); -- 取值范围在0-100
create table student --创建表student
(sno char(7) primary key, --设置sno为主键
sname char(10),
ssex char(2) check(ssex '男' or '女'),
sage int check(sage between 15 and 45),
sdept char(20) default '计算机系' );
第2个回答 2018-10-04
create database abc
on
(name='a_data',
filename='e:\sql\a_data.mdf',
size=5MB,
MAXSIZE=50MB
)
---------
create table book(
bNo char(2) not null primary key,
bName varchar(50) not null,
bAuther varchar(30) not null,
bPublisher varchar(30) not null,
bPrice money not null,
bMout int not null
)
追问。。貌似和我题目不一样啊
本回答被网友采纳
第3个回答 2018-11-16
--SC表
CREATE TABLE SC(
Sno varchar(7),
Cno varchar(10),
Grade INT,
PRIMARY KEY (Sno) REFERENCES Student(Sno) ,
PRIMARY KEY (Cno) REFERENCES Course(Cno) ,
CHECK Grade>=0 AND Grade <=100
)
--学生表
CREATE TABLE Student(
Sno varchar(7) ,
Sname varchar(10) NOT NULL,
Ssex varchar(2),
Sage INT,
Sdept varchar(20) DEFAULT '计算机系',
PRIMARY KEY (Sno)
CHECK (Ssex IN ('男','女'))
CHECK (int>=15 AND int <=45)
)
--课程表,貌似没给截图 = =
CREATE TABLE Course(
Cno varchar(7),
Cname varchar(10) NOT NULL,
PRIMARY KEY (Cno)
)