create database productSupplier
create table [P]
(  p# int not null primary key,
type nvarchar(20)  null,
color nvarchar(20)  null,
pcity nvarchar(20)  null
);

create table [S]
(  s# int not null primary key,
sname nvarchar(20) not null,
scity nvarchar(20)  null,
status int not null
);

create table [SP]
(s# int not null references S(s#),
p# int not null,
qty int null,
primary key(s#,p#),
foreign key (p#) references P(p#)

);