Base de datos Bodega Aurrera

CREATE TABLE [Bodega Aurrera]

USE [Bodega Aurrera]

GO

CREATE TABLE DBO.Productos

(

[Clave Producto]int primary key not null,

Cantidad int,

[Precio Unitario]int,

Nombre varchar(60),

[Fecha caducidad] date,

[Clave Marca]int

)

GO

CREATE TABLE DBO.Clientes

(

[clave clientes]int primary key not null,

Nombre varchar (70),

Direcion varchar(70),

Telefono varcaher (70),

Estado varchar (70),

colonia varchar (70),

Codigo Postal int

)

GO

CRETE TABLE DBO. Comprar

(

[Clave Cliente],

[Clave Producto],

Fecha date

)

GO

CREATE TABLE DBO. Marca

(

[Clave Marca]int primary key not null,

nombre varchar (60),

[Descripcion producto] varchar (60)

)

GO

ALTER TABLE DBO.Productos ADD foreign key

([Clave Marca]) REFERENCES DBO. Marca ([Clave Marca])

on delete cascade on op date cascade

ALTER TABLE DBO.Comprar ADD foreign key

([Clave Cliente]) REFERENCES DBO. Clientes ([Clave Cliente])

on delete cascade on op date cascade

ALTER TABLE DBO.Productos ADD foreign key

([Clave Productos]) REFERENCES DBO. Productos ([Clave Productos])

on delete cascade on op date cascade

INSERT Marca ([Clave Marca], Nombre, Descripcion Producto)

VALUES (1,'La costeña','varios productos'),

(2,'La morena','varios productos'),

(3,'Sabritas','varios productos'),

(4,'Cocacola','varios productos'),

(5,'Gameza','varios productos'),

(5,'Jumex','varios productos'),

(7,'Verde valle','varios productos'),

(8,'Bimbo','varios productos'),

(9,'Pepssi','varios productos'),

(10,'Lala','varios productos');

GO

INSERT Clientes([Clave Clientes], Nomre, Direccion, Telefono, Estado, Colonia, codigo Postal)

VALUES(1,'isidro fuentes razo','cjon martinez fuentes', 6960069,'guanajuato','buenavista de cortes',36940),

(2,'christian gerardo gullen bravo','elena#23',3521105656,'michoacan','delta',59300),

(3,'guillermo guardaddo navarro','los zauces#24',3520011011,'michoacan','el colorado',59300),

(4,'edgar garcia tafolla ','las flores#1',3521017811,'michoacan','el colorado',59300),

(5,'alvaro perez prado',' el valcon#2',3522067811,'michoacan','el cielo',59300),

(6,'isabel cano enriquez','los sauces#24',3524167810,'michoacan','cuisillos',59300),

(7,'elizabeth cano enriques','sn antonio#3',3523899110,'michoacan','rio grande',59300),

(8,'ddolores pimentel medoza','los sosos#3',3525101010,'michoacan','ensueño',59300),

(9,'nayeli ramirez ramirez','isidro castillo#558',,'michoacan','vasco',59300),

(10,'michelle perez coronado','acapulco#25',3523456789,'michoacan','cuisillos',59300),

(11,'arelly bautista valades','el cactus#5',3521100135,'michoacan','vanquetes',59300),

(12,'rafael ramirez rizo','cuitzeo#22',3529224117,'michoacan','numaran',59300),

(13,'israel flores favian','las flores310',3521014511,'michoacan','delta',59300),

(14,'alfonzo ramirez cano','san isidro#10',3521116021,'michoacan','vanquetes',59300),

(15,'fernando porras tinajero','lazaro cardenas#11',,'michoacan','delta',59300),

(16,'daniel rizo vargas','san martin#20',3521344513,'michoacan','vasco',59300),

(17,'armado mireles fuentes','las palmas#1',5521461210,'michoacan','los sauces',59300),

(18,'esmeralda alvares pedroza','san rafael#13',3521561500,'michoacan','vanquetes',59300),

(19,'elias solorio tinoco','san panfilo#12',3521678590,'michoacan','santa fe',59300),

(20,'fernando ramirez valadez','el laurel#10',3521794020,'michoacan','camelinas',59300),

(21,'liliana valadez vazquez','santa cecilia#11',3521812220,'michoacan','ensueño',59300),

(22,'janet soto gimenez','los sauces#45',3521915202,'michoacan','cd del sol',59300),

(23,'jazmin bravo olivares','las palmas',3522111111,'michoacan','las cañasdas',59300),

(24,'perla aguilar vega','el cactus#21',3522111028,'michoacan','camelinas',59300),

(25,'adriana perez alejandre','el decierto#4',3522211112,'michoacan','vanquetes',59300),

(26,'guadalupe melgoza gomez','santa cecilia#34',3522354761,'michoacan','rio grande',59300),

(27,'susana nuñes martinez','las flores#15',3522454321,'michoacan','cd del sol',59300),

(28,'juan villalobos cruz','ocales#20',3522314131,'michoacan','santa ana',59300),

(29,'joel ramirez aguiña','pinozuares#100',3522614331,'michoacan','maravillas',59300),

(30,'manuel magdaleno perez','ocales#32',3524567906,'michoacan','el azul',59300),

(31,'felipevaladez hernandez','cejon hernandez',6960027,'guanaguato','buenavista de cortes',59300),

(32,'paola razo cervantes','mariano gimenes#13',6960170,'guanajuato','la estrella',36940),

(33,'jose bonilla ventura','el guayabo#4',6960003,'guanajuato','paloverde',36940),

(34,'iridian cazares cervantes','la soledad#10',6960222,'guanajuato','el talon',36940),

(35,'rosa bonilla morales','el

...