Tabelas_cliente_item_pedido

Prévia do material em texto

1 - CREATE TABLE 
cliente(cliente_id INT NOT NULL,
cliente_nome VARCHAR(40) not NULL,
cliente_empresa VARCHAR(20) NOT NULL,
cod_empresa INT NOT NULL);
INSERT INTO cliente VALUES (1,'Kirk','enterprise',10) ;
INSERT INTO cliente VALUES (2,'Spock','enterprise',9);
INSERT INTO cliente VALUES (3,'Scott','enterprise',8) ;
INSERT INTO cliente VALUES (4,'Bones','enterprise',8);
INSERT INTO cliente VALUES (5,'Gom','PlanetoidArena',1) ;
INSERT INTO cliente VALUES (6,'Khan','CetiAlphaFive',2);
INSERT INTO cliente VALUES (7,'Uhura','Enterprise',7);
INSERT INTO cliente VALUES (8,'Chekov','Enterprise',6) ;
INSERT INTO cliente VALUES (9,'Sulu','Enterprise',6);
2 - CREATE TABLE 
item(item_id INT NOT NULL,
nome_item VARCHAR(40) not NULL,
valor_item DECIMAL NOT NULL);
INSERT INTO item VALUES (125,'phaser',350,2) ;
INSERT INTO item VALUES (137,'beam',1500,250) ;
INSERT INTO item VALUES (143,'shield',4500,3000) ;
INSERT INTO item VALUES (175,'fusionMissille',2750,500) ;
INSERT INTO item VALUES (211,'capitainslog',50,2) ;
INSERT INTO item VALUES (234,'Starship',25000,15000) ;
INSERT INTO item VALUES (356,'sensor',245,15) ;
INSERT INTO item VALUES (368,'intercom',1200,75) ;
INSERT INTO item VALUES (399,'medicalKit',75,3) ;
3- CREATE TABLE 
pedido(pedido_id INT NOT NULL,
cliente_id INT NOT NULL,
item_id INT NOT NULL,
 qtd_item VARCHAR(20) NOT NULL,
total_pedido DECIMAL NOT NULL);
 
INSERT INTO pedido VALUES (10012,5,125,2,700) ;
INSERT INTO pedido VALUES (10023,6,175,20,55000) ;
INSERT INTO pedido VALUES (10042,3,137,3,4500) ;
INSERT INTO pedido VALUES (10058,1,211,1,50) ;
INSERT INTO pedido VALUES (10232,7,368,1,1200) ;
INSERT INTO pedido VALUES (10266,2,356,50,12250) ;
INSERT INTO pedido VALUES (10371,4,399,10,750) ;
INSERT INTO pedido VALUES (11070,9,143,1,4500) ;
INSERT INTO pedido VALUES (11593,8,125,2,700) ;
INSERT INTO pedido VALUES (11775,6,125,3,1050) ;
INSERT INTO pedido VALUES (12001,1,234,1,25000) ;]