用SQL语句定义一些关系模式组成的数据库?

2025-06-20 12:24:03
推荐回答(1个)
回答1:

create database SPJ
go
use SPJ
create table s
(
sno int not null primary key,
sname varchar(10) not null,
city varchar(10) not null
)
go

create table p
(
pno int not null primary key,
pname varchar(10) not null,
weight varchar(10) not null,
color varchar(10) not null
)
go

create table j
(
jno int not null primary key,
jname varchar(10) not null,
city varchar(10) not null
)
go

create table spj
(
sno int not null constraint s_fk foreign key references s(sno),
pno int not null constraint p_fk foreign key references p(pno),
jno int not null constraint j_fk foreign key references j(jno)
)