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 marmol-31',6960217,'guanajuato','aratzipo',36940),

(36,'rey vargas piceno','cejon los vargas#19',6960253,'guanajuato','san bernardo',36940),

(37,'fernando vargas alvares','gabriel#67',6960002,'guanajuato','las cuevas',36940),

(38,'alexis calzada ventura','los amoles#10',6960226,'guanajuato','tacuballa',36940),

(39,'erika zarate vventura','los amoles#2',6960244,'guanajuato','buenavista de cortes',36940),

(40,'azucena lopez ventura','la ranita#45',6960111,'guanajuato','trojes',36940),

(41,'luis linares tule','el nopal#4',6960026,'guanajuato','la araña',36940),

(42,'rene herrera vargas','mariano jimenez#34',6960456,'guanajuato','el talon',36940),

(43,'jesus zarate canchola','la golo#3',6960193,'guanajuato','el marmol',36940),

(44,'yadira medina o segueda','las golondrinas#34',6960005,'guanajuato','el guayabo',36940),

(45,'fernanda paz fuentes','gardemia#45',6960345,'guanajuato','san bernardo',36940),

(46,'vanesa tule garcia','nardo#45',6960254,'guanajuato','el talon',36940),

(47,'laura torres herrera','espina#9',6960765,'guanajuato','san martin',36940),

(48,'francisco galvan hidalgo','capricho#8',6960145,'guanajuato','la colonia',36940),

(49,'gustavo lopez alcantar','azucenas#1',6960,'guanajuato','la esmeralda',36940),

(50,'antonio gonzales silva','perunia#5',6960,'guanajuato','el guayavo',36940);

GO

VALUES Productos([Clave Producto], Cantidad, [Precio Unitario], Nombre, [Fecha Caducidad], [Clave Marca]),

(1,52,20,'jalapeños 250gm','26/8/16',1),

(2,12,10,'salsa picante','12/2/16',1),

(3,15,30,'frijoles negros','31/6/16',1),

(4,100,15,'pure tomate','10/4/16',1),

(5,50,40,'mayonesa','15/2/16',1),

(6,25,20,'catsup','11/3/16',1),

(7,150,15,'chiles en vinagre','20/8/16',1),

(8,100,20,'huitlacoche','25/2/16',1),

(9,200,20,'chipotles','30/3/16',1),

(10,170,30,'ensalada de vcerduras','31/12/16',1),

(11,88,30,'nachos','31/6/17'2),

(12,95,20,'chiles chipothtes',13/2/17',2),

...