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)
)