Bases De Datos
nfactura varchar(30) not null,
fecha varchar(30) not null,
cc/nit_client varchar(30) not null,
PRIMARY KEY (nfactura),
Foreing Key (cc/nit_client),
)
INSERT INTO GRUPO1(nfactura,No_DATE,cc/nit_client)
VALUES
"A1,A2,A3,A4,A5,A6,A7,A8,A9,A10",
"8-Apr-12,10-Feb-11,1-May-10,28-May-10,01-Dic-11,02-Dic-11,03-Dic-11,04-Dic-11,05-Dic-11,06-Dic-11""e6565a/T4546,564ae/76TR66,5654t/GH653,5645tt/6765TU,234357/TYU567,434tr5/TY564,6546ttr/4564TY,45645y/5434ty,67trtyy/6767GY,f565t2/5645gg");
CREATE TABLE ART2(
nfactura varchar(30) not null,
codigo char(30) not null,category char(30) not null,
descripcion char(30) not null,
vr.unit varchar(30) not null,
cant.merc varchar(30) not null,
primary key (nfactura),
foreing key (codigo),
)
INSERT INTO ART2(nfactura,codigo,category,descripcion,vr.unit,cant.merc)
values
"a001,a002,a003,a004,a005,a006,a007,a008,a009,a010",
"b001,b002,b003,b004,b005,b006,b007,b008,b009,b010","memory,monitores,motherboars,unidades,perifericos");
"articulo no rembolsable"
"por asignar"
"por asignar");
CREATE TABLE ART3(
codigo char(30) not null,
category char(30) not null,
descripcion char(30) not null,
vr.unitvarchar(30) not null,
primary key (codigo),
foreing key (category),
)
INSERT INTO ART3(
nfactura,codigo,category,descripcion,vr.unit)
VALUES
"B1,B2,B3,B4,B5,B6,B7,B8,B9,B10","memory,screen,motherboars,unidades,perif");
"PRODUCTOS"
"POR ASIGNAR");
CREATE TABLE GRUPO4(
cc/nit_client varchar(30) not null,
nome_client char(30) not null,
dir_client char(30) not null,
tel_ client char(30) not null,
primary key (cc/nit_client),
foreing key (nome_client),
INSERT INTO GRUPO4(
cc/nit_client,nome_client,dir_client,tel_ client,)
VALUES"e6565a/T4546,564ae/76TR66,5654t/GH653,5645tt/6765TU,234357/TYU567,434tr5/TY564,6546ttr/4564TY,45645y/5434ty,67trtyy/6767GY,f565t2/5645gg");
"MONICA SILVA, DANIEL HERNANDEZ , OSCAR GALVIS, NELSON CASTIBLANCO, MAURICIO HERNANDEZ, JUAN...
Regístrate para leer el documento completo.