Base De Datos Envio

use master
go
drop database bdenvios
go
create database bdenvios
go

use bdenvios
go
create table proveedores
(
p# varchar(2) not null Primary Key,
pnombre varchar(30) not null,categoria int not null,
ciudad varchar(30) null
)
go

create table componentes
(
c# varchar(2) not null Primary Key,
cnombre varchar(30) not null,
color varchar(30) null,
pesonumeric(2,0) null,
ciudad varchar(30) null
)
go
create table articulos
(
t# varchar(2) not null Primary Key,
tnombre varchar(30) not null,
ciudad varchar(30) null
)
go
create table envios
(p# varchar(2) not null,
c# varchar(2) not null,
t# varchar(2) not null,
cantidad int not null,
Primary Key(p#,c#,t#),
foreign key (p#) references proveedores(p#),
foreign key (c#)references componentes(c#),
foreign key (t#) references articulos(t#)
)
go

insert into proveedores values('p1','Carlos',20,'Sevilla')
insert into proveedores values('p2','Juan',10,'Madrid')insert into proveedores values('p3','José',30,'Sevilla')
insert into proveedores values('p4','Inma',20,'Sevilla')
insert into proveedores values('p5','Eva',30,'Cáceres')
go
insert into componentesvalues('c1','X3A','Rojo',12,'Sevilla')
insert into componentes values('c2','B85','Verde',17,'Madrid')
insert into componentes values('c3','C4B','Azul',17,'Málaga')
insert into componentesvalues('c4','C4B','Rojo',14,'Sevilla')
insert into componentes values('c5','VT8','Azul',12,'Madrid')
insert into componentes values('c6','C30','Rojo',19,'Sevilla')
go
insert into articulosvalues('t1','clasificadora','Madrid')
insert into articulos values('t2','Perforadora','Málaga')
insert into articulos values('t3','Lectora','Cáceres')
insert into articulos values('t4','Consola','Cáceres')insert into articulos values('t5','Mezcladora','Sevilla')
insert into articulos values('t6','Terminal','Barcelona')
insert into articulos values('t7','Cinta','Sevilla')
go
insert into envios...