Scribd
Upload
4 views2 pages

Script BDen 3 FN

Uploaded by

Dayle Garcia

Copyright:

© All Rights Reserved
Download as TXT, PDF, TXT or read online from Scribd
Download as txt, pdf, or txt

Script BDen 3 FN

Uploaded by

Dayle Garcia
4 views2 pages

Original Title

ScriptBDen3FN

Copyright

© © All Rights Reserved

Available Formats

TXT, PDF, TXT or read online from Scribd

Did you find this document useful?

Is this content inappropriate?

Copyright:

© All Rights Reserved
Download as TXT, PDF, TXT or read online from Scribd
Download as txt, pdf, or txt
4 views2 pages

Script BDen 3 FN

Uploaded by

Dayle Garcia

Copyright:

© All Rights Reserved
Download as TXT, PDF, TXT or read online from Scribd
Download as txt, pdf, or txt
You are on page 1/ 2

CREATE TABLE ARTICULOS

(
ID_ART VARCHAR(10) PRIMARY KEY,
NOM_ART VARCHAR(30) NOT NULL,
MAR_ART VARCHAR(30) NOT NULL,
COS_UNI NUMBER NOT NULL
);

CREATE TABLE SUELDOS


(
TIP_VEND VARCHAR(10) PRIMARY KEY,
SUE_VEND NUMBER NOT NULL
);

CREATE TABLE VENDEDORES


(
CED_VEN VARCHAR(10) PRIMARY KEY,
NOM_VEN VARCHAR(30) NOT NULL,
NOM2_VEN VARCHAR(30),
APE_VEN VARCHAR(30) NOT NULL,
APE2_VEN VARCHAR(30),
TIP_VEN VARCHAR(10) NOT NULL REFERENCES SUELDOS(TIP_VEND)
);

CREATE TABLE CLIENTES


(
ID_CLI VARCHAR(10) PRIMARY KEY,
NOM_CLI VARCHAR(30) NOT NULL,
NOM2_CLI VARCHAR(30) ,
APE_CLI VARCHAR(30) NOT NULL,
APE2_CLI VARCHAR(30)
);

CREATE TABLE VENTAS


(
ID_VEN NUMBER PRIMARY KEY,
FEC_VEN DATE NOT NULL,
ID_ART_VEN VARCHAR(10) NOT NULL REFERENCES ARTICULOS(ID_ART),
ID_CLI_VEN VARCHAR(10) NOT NULL REFERENCES CLIENTES(ID_CLI),
CED_VEN_VEND VARCHAR(10) NOT NULL REFERENCES VENDEDORES(CED_VEN),
CANT NUMBER NOT NULL,
TOTAL NUMBER NOT NULL
);

INSERT INTO SUELDOS (TIP_VEND, SUE_VEND) VALUES ('TIPO1', 1500);


INSERT INTO SUELDOS (TIP_VEND, SUE_VEND) VALUES ('TIPO2', 2000);
INSERT INTO SUELDOS (TIP_VEND, SUE_VEND) VALUES ('TIPO3', 2500);
INSERT INTO SUELDOS (TIP_VEND, SUE_VEND) VALUES ('TIPO4', 3000); INSERT INTO
SUELDOS (TIP_VEND, SUE_VEND) VALUES ('TIPO5', 3500);

INSERT INTO ARTICULOS (ID_ART, NOM_ART, MAR_ART, COS_UNI) VALUES ('A001', 'Laptop',
'HP', 1200);
INSERT INTO ARTICULOS (ID_ART, NOM_ART, MAR_ART, COS_UNI) VALUES ('A002', 'Mouse',
'Logitech', 25);
INSERT INTO ARTICULOS (ID_ART, NOM_ART, MAR_ART, COS_UNI) VALUES ('A003',
'Teclado', 'Razer', 75);
INSERT INTO ARTICULOS (ID_ART, NOM_ART, MAR_ART, COS_UNI) VALUES ('A004',
'Monitor', 'Samsung', 300);
INSERT INTO ARTICULOS (ID_ART, NOM_ART, MAR_ART, COS_UNI) VALUES ('A005',
'Impresora', 'Canon', 150);

INSERT INTO CLIENTES (ID_CLI, NOM_CLI, NOM2_CLI, APE_CLI, APE2_CLI) VALUES ('C001',
'Juan', 'Carlos', 'Pérez', 'Gómez');
INSERT INTO CLIENTES (ID_CLI, NOM_CLI, NOM2_CLI, APE_CLI, APE2_CLI) VALUES ('C002',
'Ana', NULL, 'Martínez', 'Lopez');
INSERT INTO CLIENTES (ID_CLI, NOM_CLI, NOM2_CLI, APE_CLI, APE2_CLI) VALUES ('C003',
'Pedro', 'Luis', 'García', 'Fernández');
INSERT INTO CLIENTES (ID_CLI, NOM_CLI, NOM2_CLI, APE_CLI, APE2_CLI) VALUES ('C004',
'María', 'Teresa', 'Sánchez', 'Ruiz');
INSERT INTO CLIENTES (ID_CLI, NOM_CLI, NOM2_CLI, APE_CLI, APE2_CLI) VALUES ('C005',
'Luis', NULL, 'Morales', 'Guzmán');

INSERT INTO VENDEDORES (CED_VEN, NOM_VEN, NOM2_VEN, APE_VEN, APE2_VEN, TIP_VEN)


VALUES ('V001', 'Carlos', NULL, 'Ramírez', 'González', 'TIPO1');
INSERT INTO VENDEDORES (CED_VEN, NOM_VEN, NOM2_VEN, APE_VEN, APE2_VEN, TIP_VEN)
VALUES ('V002', 'Luisa', 'María', 'Fernández', 'López', 'TIPO2');
INSERT INTO VENDEDORES (CED_VEN, NOM_VEN, NOM2_VEN, APE_VEN, APE2_VEN, TIP_VEN)
VALUES ('V003', 'Andrés', NULL, 'Gómez', 'Pérez', 'TIPO3');
INSERT INTO VENDEDORES (CED_VEN, NOM_VEN, NOM2_VEN, APE_VEN, APE2_VEN, TIP_VEN)
VALUES ('V004', 'Sofía', NULL, 'Luna', 'Martínez', 'TIPO4');
INSERT INTO VENDEDORES (CED_VEN, NOM_VEN, NOM2_VEN, APE_VEN, APE2_VEN, TIP_VEN)
VALUES ('V005', 'Javier', 'Eduardo', 'Torres', 'Mendoza', 'TIPO5');

INSERT INTO VENTAS (ID_VEN, FEC_VEN, ID_ART_VEN, ID_CLI_VEN, CED_VEN_VEND, CANT,


TOTAL)
VALUES (1, TO_DATE('2024-11-15', 'YYYY-MM-DD'), 'A001', 'C001', 'V001', 2, 2400);
INSERT INTO VENTAS (ID_VEN, FEC_VEN, ID_ART_VEN, ID_CLI_VEN, CED_VEN_VEND, CANT,
TOTAL)
VALUES (2, TO_DATE('2024-11-16', 'YYYY-MM-DD'), 'A003', 'C002', 'V002', 1, 75);
INSERT INTO VENTAS (ID_VEN, FEC_VEN, ID_ART_VEN, ID_CLI_VEN, CED_VEN_VEND, CANT,
TOTAL)
VALUES (3, TO_DATE('2024-11-17', 'YYYY-MM-DD'), 'A002', 'C003', 'V003', 5, 125);
INSERT INTO VENTAS (ID_VEN, FEC_VEN, ID_ART_VEN, ID_CLI_VEN, CED_VEN_VEND, CANT,
TOTAL) VALUES (4, TO_DATE('2024-11-18', 'YYYY-MM-DD'), 'A004', 'C004', 'V004', 3,
900);
INSERT INTO VENTAS (ID_VEN, FEC_VEN, ID_ART_VEN, ID_CLI_VEN, CED_VEN_VEND, CANT,
TOTAL) VALUES (5, TO_DATE('2024-11-19', 'YYYY-MM-DD'), 'A005', 'C005', 'V005', 1,
150);

You might also like