nada

Codigo

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

Nombre(Artículos)
Placa De Video Msi R9 270x Gaming 2gb Dvi-hdmi Box
Disco Externo Portatil 1tb Usb
Gabinete Noganet Gamer Extrem 4 Cooler Con Led Ng-cp626
Placa Sapphire Radeon R7 260x Oc 2gb Pcie 3.0 1050 Mhz
Disco Rigido Externo Portatil 1tbUsb 3.0
Disco Ssd 120gb Estado Solido Sata 3
Disco Rigido Portatil -Digital Passport Se 1tb Usb
Disco Ssd 240gb Estado Solido Sata 3
Hd 1tb Sata 3 64m 6 Gb/s Wd Caviar Black Disco Rigido - Mexx
Video Geforce Nvidia Gtx 750ti 2gb Ddr5 Hdmi Dvi 128bit Dx11
Disco Rigido Wd 1tb Caviar Green Sata 64mb
HyperX Memory RAM 4gb
AMD Radeon HD 7900 Series Graphics Cards
Gráficos AMD Radeon Serie R9AMD Radeon™ HD 7300M Series Graphics
GeForce GTX TITAN
GeForce GTX 980
GeForce GTX 780 Ti
GeForce GTX 650
DataTraveler 100 G3 2GB
DataTraveler HyperX Predator 1TB.
DataTraveler microDuo 4GB.
DataTraveler 101 G2 128GB.
DataTraveler SE9 16GB.
DataTraveler HyperX 3.0 256GB.
Smart TV Premium HD 40pulg.
LED TV All Around Performance. HD-3D 50pulg.
4K Ultra HD TV-Ultra HDTV 50pulgGabinete de aluminio para Disco Duro SURE Enclosure 3.5” SATA a USB
Parlantes SURE Subwoofer 2.1 QQ003
Parlantes SURE Subwoofer 2.1 S-230
Parlantes SURE Subwoofer 2.1 S-280
JOYSTICK SURE WIRELESS 2.4GHZ
JOYSTICK SURE X-SHOCK-2.2
JOYSTICK SURE X-SHOCK2
My Book AV-TV

Precio
1566
420
360
1050
430
560
500
200
666
440
450
33
500
244
342
223
100
123
21
10
100
23
50
45
114400
560
1000
20
134
89
280
24
43
23
46

codigof
1
2
3
1
2
5
5
5
6
7
6
5
1
1
1
7
7
7
7
5
5
5
5
5
5
2
2
2
3
3
3
3
3
3
3
6

código

nombre

Fabricantes

1
2
3
4
5
6
7

amd
Toshiba
Sure
Samsung
Kingston
Wd Western
Nvidia

Creando base de datos
CREATE DATABASE almacén;

Creando la Tabla
CREATE TABLE maker (codMaker INTAUTO_INCREMENT PRIMARY KEY,name CHAR(25) NOT NULL);

Creando la tabla Artículos (articles)
CREATE TABLE articles (
codArticles INT AUTO_INCREMENT PRIMARY KEY,
name CHAR(25) NOT NULL,
price INT(10) NOT NULL,
codMaker INT NOT NULL REFERENCES maker (codMaker)ON DELETE CASCADE ON UPDATE CASCADE);

Insertando datos en la tabla fabricantes (maker)
INSERT INTO maker (name) VALUES('amd');
INSERT INTOmaker (name) VALUES('Toshiba');
INSERT INTO maker (name) VALUES('Samsung');
INSERT INTO maker (name) VALUES('Kingston');
INSERT INTO maker (name) VALUES('Wd Western');
INSERT INTO maker (name) VALUES('Nvidia');

Insertando datos en la tabla articles (articulos)
INSERT INTO articles(name,price ,codMaker) VALUES('Placa De Video Msi R9 270x Gaming 2gb Dvi-hdmi Box ', 420,1);
INSERT INTOarticles(name,price ,codMaker) VALUES('Disco Externo Portatil 1tb Usb ', 360,2);
INSERT INTO articles(name,price ,codMaker) VALUES(' Gabinete Noganet Gamer Extrem 4 Cooler Con Led Ng-cp626', 1050,3);
INSERT INTO articles(name,price ,codMaker) VALUES('Disco Rigido Externo Portatil 1tb Usb 3.0', 430,2);
INSERT INTO articles(name,price ,codMaker) VALUES(' Disco Ssd 120gb Estado Solido Sata 3 ',560,5);
INSERT INTO articles(name,price ,codMaker) VALUES(' Disco Rigido Portatil -Digital Passport Se 1tb Usb ', 500,5);
INSERT INTO articles(name,price ,codMaker) VALUES(' Disco Ssd 240gb Estado Solido Sata 3', 200,5);
INSERT INTO articles(name,price ,codMaker) VALUES(' Hd 1tb Sata 3 64m 6 Gb/s Wd Caviar Black Disco Rigido - Mexx ', 666,6);
INSERT INTO articles(name,price ,codMaker) VALUES('Video Geforce Nvidia Gtx 750ti 2gb Ddr5 Hdmi Dvi 128bit Dx11',440,7);
INSERT INTO articles(name,price ,codMaker) VALUES(' Disco Rigido Wd 1tb Caviar Green Sata 64mb ',450,6);
INSERT INTO articles(name,price ,codMaker) VALUES(' HyperX Memory RAM 4gb ', 33,5);
INSERT INTO articles(name,price ,codMaker) VALUES(' AMD Radeon HD 7900 Series Graphics Cards ', 500,1);
INSERT INTO articles(name,price...