mysql> use final;
Database changed
mysql> select * from producto;
+--------------+----------+----------+--------+
| cod_producto | nombre   | cantidad | costo  |
+--------------+----------+----------+--------+
| AZ01         | Arroz    |       89 |   1300 |
| AZ010        | ASDA     |      207 |   1233 |
| AZ011        | ASDAS    |      117 |   1244 |
| az015        | asdad    |      117 |   2134 |
| AZ02         | Frijoles |       94 |   1500 |
| az023        | asd      |      117 | 213344 |
| AZ03         | Lentejas |      184 |   1200 |
| AZ04         | Spaggeti |      183 |   1200 |
| AZ05         | Caldo    |      174 |   1400 |
| AZ06         | LOQUESEA |      124 |   1234 |
| AZ07         | SDFS     |      117 |   2134 |
| AZ08         | asd      |      207 |   1233 |
| AZ09         | ASD      |       26 |   3456 |
+--------------+----------+----------+--------+
13 rows in set (0.00 sec)

mysql> delete from producto;
Query OK, 13 rows affected (0.05 sec)

mysql> insert into producto(cod_producto,nombre,cantidad,costo) values ('AZ01','Arroz',100,1300),
    -> ('AZ02','Frijoles',100,1400),
    -> ('AZ03','Lentejas',100,1250),
    -> ('AZ04','Quesito',50,2000);
Query OK, 4 rows affected (0.01 sec)
Records: 4  Duplicates: 0  Warnings: 0

mysql> select * from cliente;
+----------+---------+----------+-----------+-----------+-----------+----------+--------+
| cedula   | nombre1 | nombre2  | apellido1 | apellido2 | direccion | telefono | estado |
+----------+---------+----------+-----------+-----------+-----------+----------+--------+
| 15512675 | Luis    | Fernando | Garcia    | Pati¤o    | Rionegro  | 6147089  | Activo |
| 34657887 | Kelly   | Alexa    | Londo¤o   | Arango    | Medellin  | 4965005  | Activo |
| 39448557 | Jhojan  | Estiven  | Garcia    | Pati¤o    | Rionegro  | 6147089  | Activo |
| 39448559 | Diana   | Milena   | Pati¤o    | Ramirez   | Medellin  | 6147089  | Activo |
+----------+---------+----------+-----------+-----------+-----------+----------+--------+
4 rows in set (0.00 sec)

mysql> show tables;
+-----------------+
| Tables_in_final |
+-----------------+
| cliente         |
| compra          |
| detalle_compra  |
| detalle_factura |
| detalle_pedido  |
| domicilio       |
| empleado        |
| factura         |
| inicio          |
| pedido          |
| perfil          |
| producto        |
| proveedor       |
| supermercado    |
+-----------------+
14 rows in set (0.00 sec)

mysql> select * from empleado;
+-------+----------+---------+-----------+-----------+-----------+----------+--------+------------+
| id    | nombre1  | nombre2 | apellido1 | apellido2 | direccion | telefono | estado | cod_perfil |
+-------+----------+---------+-----------+-----------+-----------+----------+--------+------------+
| SEC01 | Diana    | Milena  | Pati¤o    | Ramirez   | Rionegro  | 6148089  | Activo | CAR02      |
| VEN01 | Santiago |         | Garcia    | Pati¤o    | Medellin  | 5612512  | Activo | CAR01      |
| VEN02 | Jair     |         | Pati¤o    | Ramirez   | Rionegro  | 5612512  | Activo | CAR01      |
+-------+----------+---------+-----------+-----------+-----------+----------+--------+------------+
3 rows in set (0.00 sec)

mysql> select * from detalle_factura;
Empty set (0.00 sec)

mysql> describe detalle_compra;
+--------------+----------+------+-----+---------+-------+
| Field        | Type     | Null | Key | Default | Extra |
+--------------+----------+------+-----+---------+-------+
| cod_compra   | char(10) | NO   | MUL | NULL    |       |
| cod_producto | char(5)  | NO   | MUL | NULL    |       |
| descripcion  | char(60) | YES  |     | NULL    |       |
| cantidad     | int(4)   | NO   |     | NULL    |       |
| precio_venta | float    | NO   |     | NULL    |       |
| subtotal     | float    | NO   |     | NULL    |       |
+--------------+----------+------+-----+---------+-------+
6 rows in set (0.01 sec)

mysql> describe detalle_factura;
+----------------+----------+------+-----+---------+-------+
| Field          | Type     | Null | Key | Default | Extra |
+----------------+----------+------+-----+---------+-------+
| codigo_factura | char(10) | NO   | MUL | NULL    |       |
| cantidad       | int(4)   | NO   |     | NULL    |       |
| precio_venta   | float    | NO   |     | NULL    |       |
| subtotal       | float    | NO   |     | NULL    |       |
| cod_producto   | char(5)  | NO   | MUL | NULL    |       |
+----------------+----------+------+-----+---------+-------+
5 rows in set (0.01 sec)

mysql> select * from factura;
+-------------+------------+-------+------+-------+----------+
| cod_factura | fecha      | hora  | neto | id    | cedula   |
+-------------+------------+-------+------+-------+----------+
| FAC01       | 2013-02-03 | 09:50 | 6695 | VEN01 | 15512675 |
| FAC02       | 2013-08-09 | 09:50 | 6695 | VEN01 | 15512675 |
| FAC03       | 2013-06-06 | 09:50 | 6695 | VEN01 | 15512675 |
| FAC04       | 2013-02-02 | 09:50 | 6695 | VEN01 | 15512675 |
| FAC05       | 2013-02-02 | 09:30 | 6695 | VEN01 | 15512675 |
| FAC06       | 2013-02-02 | 09:30 | 6695 | VEN01 | 39448559 |
| FAC07       | 2013-02-02 | 09:30 | 6695 | ven01 | 15512675 |
+-------------+------------+-------+------+-------+----------+
7 rows in set (0.00 sec)

mysql> delete from factura;
Query OK, 7 rows affected (0.05 sec)

mysql> insert into factura(cod_factura,hora,fecha,neto,id,cedula) values ('FAC01','2013-02-03','09:50',0,'VEN01','15512675'),
    -> ('FAC02','2013-02-09','19:30',0,'SEC01','39448559'),
    -> ('FAC03','2013-01-01','17:31',0,'VEN02','39448557'),
    -> ('FAC04','2013-07-01','14:31',0,'VEN01','39448557'),
    -> ('FAC05','2013-08-02','14:31',0,'SEC01','34657887'),
    -> ('FAC06','2013-09-03','15:31',0,'VEN02','15512675');
Query OK, 6 rows affected, 12 warnings (0.05 sec)
Records: 6  Duplicates: 0  Warnings: 12

mysql> SELECT * FROM PRODUCTO;
+--------------+----------+----------+-------+
| cod_producto | nombre   | cantidad | costo |
+--------------+----------+----------+-------+
| AZ01         | Arroz    |      100 |  1300 |
| AZ02         | Frijoles |      100 |  1400 |
| AZ03         | Lentejas |      100 |  1250 |
| AZ04         | Quesito  |       50 |  2000 |
+--------------+----------+----------+-------+
4 rows in set (0.00 sec)

mysql> SELECT * FROM factura;
+-------------+------------+-----------+------+-------+----------+
| cod_factura | fecha      | hora      | neto | id    | cedula   |
+-------------+------------+-----------+------+-------+----------+
| FAC01       | 0000-00-00 | 2013-02-0 |    0 | VEN01 | 15512675 |
| FAC02       | 0000-00-00 | 2013-02-0 |    0 | SEC01 | 39448559 |
| FAC03       | 0000-00-00 | 2013-01-0 |    0 | VEN02 | 39448557 |
| FAC04       | 0000-00-00 | 2013-07-0 |    0 | VEN01 | 39448557 |
| FAC05       | 0000-00-00 | 2013-08-0 |    0 | SEC01 | 34657887 |
| FAC06       | 0000-00-00 | 2013-09-0 |    0 | VEN02 | 15512675 |
+-------------+------------+-----------+------+-------+----------+
6 rows in set (0.00 sec)

mysql> update factura set fecha='2013-02-02' where cod_factura='FAC01';
Query OK, 1 row affected (0.06 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from factura;
+-------------+------------+-----------+------+-------+----------+
| cod_factura | fecha      | hora      | neto | id    | cedula   |
+-------------+------------+-----------+------+-------+----------+
| FAC01       | 2013-02-02 | 2013-02-0 |    0 | VEN01 | 15512675 |
| FAC02       | 0000-00-00 | 2013-02-0 |    0 | SEC01 | 39448559 |
| FAC03       | 0000-00-00 | 2013-01-0 |    0 | VEN02 | 39448557 |
| FAC04       | 0000-00-00 | 2013-07-0 |    0 | VEN01 | 39448557 |
| FAC05       | 0000-00-00 | 2013-08-0 |    0 | SEC01 | 34657887 |
| FAC06       | 0000-00-00 | 2013-09-0 |    0 | VEN02 | 15512675 |
+-------------+------------+-----------+------+-------+----------+
6 rows in set (0.00 sec)

mysql> update factura set fecha='2013-02-03' where cod_factura='FAC02';
Query OK, 1 row affected (0.02 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> update factura set fecha='2013-02-04' where cod_factura='FAC03';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> update factura set fecha='2013-02-05' where cod_factura='FAC04';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> update factura set fecha='2013-03-05' where cod_factura='FAC05';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> update factura set fecha='2013-03-07' where cod_factura='FAC06';
Query OK, 1 row affected (0.03 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from factura
    -> ;
+-------------+------------+-----------+------+-------+----------+
| cod_factura | fecha      | hora      | neto | id    | cedula   |
+-------------+------------+-----------+------+-------+----------+
| FAC01       | 2013-02-02 | 2013-02-0 |    0 | VEN01 | 15512675 |
| FAC02       | 2013-02-03 | 2013-02-0 |    0 | SEC01 | 39448559 |
| FAC03       | 2013-02-04 | 2013-01-0 |    0 | VEN02 | 39448557 |
| FAC04       | 2013-02-05 | 2013-07-0 |    0 | VEN01 | 39448557 |
| FAC05       | 2013-03-05 | 2013-08-0 |    0 | SEC01 | 34657887 |
| FAC06       | 2013-03-07 | 2013-09-0 |    0 | VEN02 | 15512675 |
+-------------+------------+-----------+------+-------+----------+
6 rows in set (0.00 sec)

mysql> show tables;
+-----------------+
| Tables_in_final |
+-----------------+
| cliente         |
| compra          |
| detalle_compra  |
| detalle_factura |
| detalle_pedido  |
| domicilio       |
| empleado        |
| factura         |
| inicio          |
| pedido          |
| perfil          |
| producto        |
| proveedor       |
| supermercado    |
+-----------------+
14 rows in set (0.00 sec)

mysql> select * from compra;
+------------+------------+-------+-------------+------+
| cod_compra | fecha      | hora  | descripcion | nit  |
+------------+------------+-------+-------------+------+
| COM01      | 2013-02-02 | 09:30 | Mercado     | 1111 |
| COM02      | 2013-02-02 | 09:40 | Mercado     | 1111 |
| COM03      | 2013-02-02 | 09:30 | Mercad0     | 1111 |
+------------+------------+-------+-------------+------+
3 rows in set (0.00 sec)

mysql> select * from pedido;
+------------+------------+-------+---------------+
| cod_pedido | fecha      | hora  | cod_proveedor |
+------------+------------+-------+---------------+
|          1 | 2013-02-02 | 09:50 | PROV01        |
+------------+------------+-------+---------------+
1 row in set (0.00 sec)

mysql> select * from proveedor;
+---------------+------------+-----------+----------+--------+
| cod_proveedor | nombre     | direccion | telefono | estado |
+---------------+------------+-----------+----------+--------+
| PROV01        | Fritolight | Medellin  | 3456789  | Activo |
+---------------+------------+-----------+----------+--------+
1 row in set (0.00 sec)

mysql> insert into proveedor(cod_proveedor,nombre,direccion,telefono,estado) values ('PROV02','Coca-cola','EE.UU','2323433','Activo'),
    -> ('PROV03','Postobon','EE.UU','2324423','Activo'),
    -> ('PROV04','Pepsi','EE.UU','2322323','Activo');
Query OK, 3 rows affected (0.04 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> select * from proveedor;
+---------------+------------+-----------+----------+--------+
| cod_proveedor | nombre     | direccion | telefono | estado |
+---------------+------------+-----------+----------+--------+
| PROV01        | Fritolight | Medellin  | 3456789  | Activo |
| PROV02        | Coca-cola  | EE.UU     | 2323433  | Activo |
| PROV03        | Postobon   | EE.UU     | 2324423  | Activo |
| PROV04        | Pepsi      | EE.UU     | 2322323  | Activo |
+---------------+------------+-----------+----------+--------+
4 rows in set (0.00 sec)

mysql> alter table pedido add producto char(10) not null;
Query OK, 1 row affected (0.11 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> describe pedido;
+---------------+----------+------+-----+---------+----------------+
| Field         | Type     | Null | Key | Default | Extra          |
+---------------+----------+------+-----+---------+----------------+
| cod_pedido    | int(11)  | NO   | PRI | NULL    | auto_increment |
| fecha         | date     | NO   |     | NULL    |                |
| hora          | char(9)  | NO   |     | NULL    |                |
| cod_proveedor | char(10) | NO   | MUL | NULL    |                |
| producto      | char(10) | NO   |     | NULL    |                |
+---------------+----------+------+-----+---------+----------------+
5 rows in set (0.01 sec)

mysql> select * from producto;
+--------------+----------+----------+-------+
| cod_producto | nombre   | cantidad | costo |
+--------------+----------+----------+-------+
| AZ01         | Arroz    |      100 |  1300 |
| AZ02         | Frijoles |      100 |  1400 |
| AZ03         | Lentejas |      100 |  1250 |
| AZ04         | Quesito  |       50 |  2000 |
+--------------+----------+----------+-------+
4 rows in set (0.00 sec)

mysql> alter table pedido drop producto;
Query OK, 1 row affected (0.07 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into pedido(fecha,hora,cod_proveedor) values ('2013-02-02','10:50','PROV01'),
    -> ('2013-02-03','09:40','PROV02'),
    -> ('2013-02-04','12:10','PROV02'),
    -> ('2013-02-05','19:40','PROV03'),
    -> ('2013-02-06','18:20','PROV03'),
    -> ('2013-02-07','15:05','PROV01');
Query OK, 6 rows affected (0.05 sec)
Records: 6  Duplicates: 0  Warnings: 0

mysql> describe detalle_pedido;
+--------------+---------+------+-----+---------+----------------+
| Field        | Type    | Null | Key | Default | Extra          |
+--------------+---------+------+-----+---------+----------------+
| cod_pedido   | int(11) | NO   | MUL | NULL    | auto_increment |
| cod_producto | char(5) | NO   | MUL | NULL    |                |
| cantidad     | int(4)  | NO   |     | NULL    |                |
| precio_venta | float   | NO   |     | NULL    |                |
| subtotal     | float   | NO   |     | NULL    |                |
+--------------+---------+------+-----+---------+----------------+
5 rows in set (0.05 sec)

mysql> select * from producto;
+--------------+----------+----------+-------+
| cod_producto | nombre   | cantidad | costo |
+--------------+----------+----------+-------+
| AZ01         | Arroz    |      100 |  1300 |
| AZ02         | Frijoles |      100 |  1400 |
| AZ03         | Lentejas |      100 |  1250 |
| AZ04         | Quesito  |       50 |  2000 |
+--------------+----------+----------+-------+
4 rows in set (0.00 sec)

mysql> insert into detalle_pedido(cod_pedido,cod_producto,cantidad,precio_venta,subtotal) values (1,'AZ01',50,0,0),
    -> (2,'AZ02',60,0,0),
    -> (3,'AZ03',70,0,0),
    -> (4,'AZ04',80,0,0);
Query OK, 4 rows affected (0.05 sec)
Records: 4  Duplicates: 0  Warnings: 0

mysql> select * from detalle_pedido;
+------------+--------------+----------+--------------+----------+
| cod_pedido | cod_producto | cantidad | precio_venta | subtotal |
+------------+--------------+----------+--------------+----------+
|          1 | AZ01         |       50 |            0 |        0 |
|          2 | AZ02         |       60 |            0 |        0 |
|          3 | AZ03         |       70 |            0 |        0 |
|          4 | AZ04         |       80 |            0 |        0 |
+------------+--------------+----------+--------------+----------+
4 rows in set (0.00 sec)

mysql> show tables;
+-----------------+
| Tables_in_final |
+-----------------+
| cliente         |
| compra          |
| detalle_compra  |
| detalle_factura |
| detalle_pedido  |
| domicilio       |
| empleado        |
| factura         |
| inicio          |
| pedido          |
| perfil          |
| producto        |
| proveedor       |
| supermercado    |
+-----------------+
14 rows in set (0.00 sec)

mysql> select * from detalle_compra;
Empty set (0.00 sec)

mysql> describe detalle_compra;
+--------------+----------+------+-----+---------+-------+
| Field        | Type     | Null | Key | Default | Extra |
+--------------+----------+------+-----+---------+-------+
| cod_compra   | char(10) | NO   | MUL | NULL    |       |
| cod_producto | char(5)  | NO   | MUL | NULL    |       |
| descripcion  | char(60) | YES  |     | NULL    |       |
| cantidad     | int(4)   | NO   |     | NULL    |       |
| precio_venta | float    | NO   |     | NULL    |       |
| subtotal     | float    | NO   |     | NULL    |       |
+--------------+----------+------+-----+---------+-------+
6 rows in set (0.01 sec)

mysql> select * from inicio;
+---------+------------+
| usuario | contrase¤a |
+---------+------------+
| diana   | diana01    |
| jhojan  | 1234       |
| luis    | luis01     |
+---------+------------+
3 rows in set (0.04 sec)

mysql> insert into detalle_compra(cod_compra,cod_producto,descripcion,cantidad,precio_venta,subtotal) values ('COM01','AZ01','Mercado',3,0,0),
    -> ('COM01','AZ02','',3,0,0),
    -> ('COM01','AZ04','',5,0,0),
    -> ('COM02','AZ02','',1,0,0),
    -> ('COM02','AZ03','',2,0,0),
    -> ('COM03','AZ01','',5,0,0),
    -> ('COM03','AZ04','',3,0,0);
Query OK, 7 rows affected (0.05 sec)
Records: 7  Duplicates: 0  Warnings: 0

mysql> select * from detalle_pedido;
+------------+--------------+----------+--------------+----------+
| cod_pedido | cod_producto | cantidad | precio_venta | subtotal |
+------------+--------------+----------+--------------+----------+
|          1 | AZ01         |       50 |            0 |        0 |
|          2 | AZ02         |       60 |            0 |        0 |
|          3 | AZ03         |       70 |            0 |        0 |
|          4 | AZ04         |       80 |            0 |        0 |
+------------+--------------+----------+--------------+----------+
4 rows in set (0.00 sec)

mysql> select * from detalle_factura;
Empty set (0.00 sec)

mysql> describe detalle_factura;
+----------------+----------+------+-----+---------+-------+
| Field          | Type     | Null | Key | Default | Extra |
+----------------+----------+------+-----+---------+-------+
| codigo_factura | char(10) | NO   | MUL | NULL    |       |
| cantidad       | int(4)   | NO   |     | NULL    |       |
| precio_venta   | float    | NO   |     | NULL    |       |
| subtotal       | float    | NO   |     | NULL    |       |
| cod_producto   | char(5)  | NO   | MUL | NULL    |       |
+----------------+----------+------+-----+---------+-------+
5 rows in set (0.01 sec)

mysql> insert into detalle_factura(codigo_factura,cantidad,precio_venta,subtotal,cod_producto) values ('FAC01',3,0,0,'AZ01');
Query OK, 1 row affected (0.01 sec)

mysql> select * from factura;
+-------------+------------+-----------+------+-------+----------+
| cod_factura | fecha      | hora      | neto | id    | cedula   |
+-------------+------------+-----------+------+-------+----------+
| FAC01       | 2013-02-02 | 2013-02-0 |    0 | VEN01 | 15512675 |
| FAC02       | 2013-02-03 | 2013-02-0 |    0 | SEC01 | 39448559 |
| FAC03       | 2013-02-04 | 2013-01-0 |    0 | VEN02 | 39448557 |
| FAC04       | 2013-02-05 | 2013-07-0 |    0 | VEN01 | 39448557 |
| FAC05       | 2013-03-05 | 2013-08-0 |    0 | SEC01 | 34657887 |
| FAC06       | 2013-03-07 | 2013-09-0 |    0 | VEN02 | 15512675 |
+-------------+------------+-----------+------+-------+----------+
6 rows in set (0.01 sec)

mysql> insert into detalle_factura(codigo_factura,cantidad,precio_venta,subtotal,cod_producto) values ('FAC01',4,0,0,'AZ04'),
    -> ('FAC01',1,0,0,'AZ03'),
    -> ('FAC01',8,0,0,'AZ02'),
    -> ('FAC02',20,0,0,'AZ01'),
    -> ('FAC02',10,0,0,'AZ04'),
    -> ('FAC03',1,0,0,'AZ02'),
    -> ('FAC04',19,0,0,'AZ03'),
    -> ('FAC04',15,0,0,'AZ01'),
    -> ('FAC05',15,0,0,'AZ01'),
    -> ('FAC05',15,0,0,'AZ03'),
    -> ('FAC06',30,0,0,'AZ01');
Query OK, 11 rows affected (0.05 sec)
Records: 11  Duplicates: 0  Warnings: 0

mysql> SELECT * FROM DETALLE_FACTURA;
+----------------+----------+--------------+----------+--------------+
| codigo_factura | cantidad | precio_venta | subtotal | cod_producto |
+----------------+----------+--------------+----------+--------------+
| FAC01          |        3 |            0 |        0 | AZ01         |
| FAC01          |        4 |            0 |        0 | AZ04         |
| FAC01          |        1 |            0 |        0 | AZ03         |
| FAC01          |        8 |            0 |        0 | AZ02         |
| FAC02          |       20 |            0 |        0 | AZ01         |
| FAC02          |       10 |            0 |        0 | AZ04         |
| FAC03          |        1 |            0 |        0 | AZ02         |
| FAC04          |       19 |            0 |        0 | AZ03         |
| FAC04          |       15 |            0 |        0 | AZ01         |
| FAC05          |       15 |            0 |        0 | AZ01         |
| FAC05          |       15 |            0 |        0 | AZ03         |
| FAC06          |       30 |            0 |        0 | AZ01         |
+----------------+----------+--------------+----------+--------------+
12 rows in set (0.00 sec)

mysql> show tables;
+-----------------+
| Tables_in_final |
+-----------------+
| cliente         |
| compra          |
| detalle_compra  |
| detalle_factura |
| detalle_pedido  |
| domicilio       |
| empleado        |
| factura         |
| inicio          |
| pedido          |
| perfil          |
| producto        |
| proveedor       |
| supermercado    |
+-----------------+
14 rows in set (0.00 sec)

mysql> select * from cliente;
+----------+---------+----------+-----------+-----------+-----------+----------+--------+
| cedula   | nombre1 | nombre2  | apellido1 | apellido2 | direccion | telefono | estado |
+----------+---------+----------+-----------+-----------+-----------+----------+--------+
| 15512675 | Luis    | Fernando | Garcia    | Pati¤o    | Rionegro  | 6147089  | Activo |
| 34657887 | Kelly   | Alexa    | Londo¤o   | Arango    | Medellin  | 4965005  | Activo |
| 39448557 | Jhojan  | Estiven  | Garcia    | Pati¤o    | Rionegro  | 6147089  | Activo |
| 39448559 | Diana   | Milena   | Pati¤o    | Ramirez   | Medellin  | 6147089  | Activo |
+----------+---------+----------+-----------+-----------+-----------+----------+--------+
4 rows in set (0.00 sec)

mysql> select * from compra;
+------------+------------+-------+-------------+------+
| cod_compra | fecha      | hora  | descripcion | nit  |
+------------+------------+-------+-------------+------+
| COM01      | 2013-02-02 | 09:30 | Mercado     | 1111 |
| COM02      | 2013-02-02 | 09:40 | Mercado     | 1111 |
| COM03      | 2013-02-02 | 09:30 | Mercad0     | 1111 |
+------------+------------+-------+-------------+------+
3 rows in set (0.00 sec)

mysql> select * from detalle_compra;
+------------+--------------+-------------+----------+--------------+----------+
| cod_compra | cod_producto | descripcion | cantidad | precio_venta | subtotal |
+------------+--------------+-------------+----------+--------------+----------+
| COM01      | AZ01         | Mercado     |        3 |            0 |        0 |
| COM01      | AZ02         |             |        3 |            0 |        0 |
| COM01      | AZ04         |             |        5 |            0 |        0 |
| COM02      | AZ02         |             |        1 |            0 |        0 |
| COM02      | AZ03         |             |        2 |            0 |        0 |
| COM03      | AZ01         |             |        5 |            0 |        0 |
| COM03      | AZ04         |             |        3 |            0 |        0 |
+------------+--------------+-------------+----------+--------------+----------+
7 rows in set (0.00 sec)

mysql> select * from detalle_factura;
+----------------+----------+--------------+----------+--------------+
| codigo_factura | cantidad | precio_venta | subtotal | cod_producto |
+----------------+----------+--------------+----------+--------------+
| FAC01          |        3 |            0 |        0 | AZ01         |
| FAC01          |        4 |            0 |        0 | AZ04         |
| FAC01          |        1 |            0 |        0 | AZ03         |
| FAC01          |        8 |            0 |        0 | AZ02         |
| FAC02          |       20 |            0 |        0 | AZ01         |
| FAC02          |       10 |            0 |        0 | AZ04         |
| FAC03          |        1 |            0 |        0 | AZ02         |
| FAC04          |       19 |            0 |        0 | AZ03         |
| FAC04          |       15 |            0 |        0 | AZ01         |
| FAC05          |       15 |            0 |        0 | AZ01         |
| FAC05          |       15 |            0 |        0 | AZ03         |
| FAC06          |       30 |            0 |        0 | AZ01         |
+----------------+----------+--------------+----------+--------------+
12 rows in set (0.00 sec)

mysql> select * from detalle_pedido;
+------------+--------------+----------+--------------+----------+
| cod_pedido | cod_producto | cantidad | precio_venta | subtotal |
+------------+--------------+----------+--------------+----------+
|          1 | AZ01         |       50 |            0 |        0 |
|          2 | AZ02         |       60 |            0 |        0 |
|          3 | AZ03         |       70 |            0 |        0 |
|          4 | AZ04         |       80 |            0 |        0 |
+------------+--------------+----------+--------------+----------+
4 rows in set (0.00 sec)

mysql> select * from domicilio;
+---------------+------------+-------+-------------+----------+
| cod_domicilio | fecha      | hora  | descripcion | cedula   |
+---------------+------------+-------+-------------+----------+
| DOM01         | 2013-05-06 | 12:43 | Mercado     | 39448559 |
| DOM02         | 2013-02-01 | 11:15 | Mercado     | 15512675 |
| DOM03         | 2013-12-12 | 12:50 | Mercado     | 39448557 |
| DOM04         | 2013-02-02 | 09:30 | Mercado     | 15512675 |
+---------------+------------+-------+-------------+----------+
4 rows in set (0.00 sec)

mysql> select * from empleado;
+-------+----------+---------+-----------+-----------+-----------+----------+--------+------------+
| id    | nombre1  | nombre2 | apellido1 | apellido2 | direccion | telefono | estado | cod_perfil |
+-------+----------+---------+-----------+-----------+-----------+----------+--------+------------+
| SEC01 | Diana    | Milena  | Pati¤o    | Ramirez   | Rionegro  | 6148089  | Activo | CAR02      |
| VEN01 | Santiago |         | Garcia    | Pati¤o    | Medellin  | 5612512  | Activo | CAR01      |
| VEN02 | Jair     |         | Pati¤o    | Ramirez   | Rionegro  | 5612512  | Activo | CAR01      |
+-------+----------+---------+-----------+-----------+-----------+----------+--------+------------+
3 rows in set (0.00 sec)

mysql> select * from factura;
+-------------+------------+-----------+------+-------+----------+
| cod_factura | fecha      | hora      | neto | id    | cedula   |
+-------------+------------+-----------+------+-------+----------+
| FAC01       | 2013-02-02 | 2013-02-0 |    0 | VEN01 | 15512675 |
| FAC02       | 2013-02-03 | 2013-02-0 |    0 | SEC01 | 39448559 |
| FAC03       | 2013-02-04 | 2013-01-0 |    0 | VEN02 | 39448557 |
| FAC04       | 2013-02-05 | 2013-07-0 |    0 | VEN01 | 39448557 |
| FAC05       | 2013-03-05 | 2013-08-0 |    0 | SEC01 | 34657887 |
| FAC06       | 2013-03-07 | 2013-09-0 |    0 | VEN02 | 15512675 |
+-------------+------------+-----------+------+-------+----------+
6 rows in set (0.00 sec)

mysql> select * from pedido;
+------------+------------+-------+---------------+
| cod_pedido | fecha      | hora  | cod_proveedor |
+------------+------------+-------+---------------+
|          1 | 2013-02-02 | 09:50 | PROV01        |
|          2 | 2013-02-02 | 10:50 | PROV01        |
|          3 | 2013-02-03 | 09:40 | PROV02        |
|          4 | 2013-02-04 | 12:10 | PROV02        |
|          5 | 2013-02-05 | 19:40 | PROV03        |
|          6 | 2013-02-06 | 18:20 | PROV03        |
|          7 | 2013-02-07 | 15:05 | PROV01        |
+------------+------------+-------+---------------+
7 rows in set (0.00 sec)

mysql> select * from perfil;
+------------+---------------+------------------------------+
| cod_perfil | cargo         | descripcion                  |
+------------+---------------+------------------------------+
| CAR01      | Cajero        | Encargado de manejar la caja |
| CAR02      | Secretario(a) | Administrativo               |
+------------+---------------+------------------------------+
2 rows in set (0.00 sec)

mysql> select * from producto;
+--------------+----------+----------+-------+
| cod_producto | nombre   | cantidad | costo |
+--------------+----------+----------+-------+
| AZ01         | Arroz    |      100 |  1300 |
| AZ02         | Frijoles |      100 |  1400 |
| AZ03         | Lentejas |      100 |  1250 |
| AZ04         | Quesito  |       50 |  2000 |
+--------------+----------+----------+-------+
4 rows in set (0.00 sec)

mysql> select * from proveedor
    -> ;
+---------------+------------+-----------+----------+--------+
| cod_proveedor | nombre     | direccion | telefono | estado |
+---------------+------------+-----------+----------+--------+
| PROV01        | Fritolight | Medellin  | 3456789  | Activo |
| PROV02        | Coca-cola  | EE.UU     | 2323433  | Activo |
| PROV03        | Postobon   | EE.UU     | 2324423  | Activo |
| PROV04        | Pepsi      | EE.UU     | 2322323  | Activo |
+---------------+------------+-----------+----------+--------+
4 rows in set (0.00 sec)

mysql> select * from supermercado;
+------+-----------+-----------+----------+
| nit  | nombre    | direccion | telefono |
+------+-----------+-----------+----------+
| 1111 | Distrimar | Rionegro  | 7659876  |
+------+-----------+-----------+----------+
1 row in set (0.02 sec)

mysql> describe factura;
+-------------+----------+------+-----+---------+-------+
| Field       | Type     | Null | Key | Default | Extra |
+-------------+----------+------+-----+---------+-------+
| cod_factura | char(10) | NO   | PRI | NULL    |       |
| fecha       | date     | NO   |     | NULL    |       |
| hora        | char(9)  | NO   |     | NULL    |       |
| neto        | float    | NO   |     | NULL    |       |
| id          | char(10) | NO   | MUL | NULL    |       |
| cedula      | char(10) | NO   | MUL | NULL    |       |
+-------------+----------+------+-----+---------+-------+
6 rows in set (0.01 sec)

mysql> select cliente.cedula,empleado.id,factura.cod_factura,producto.cod_producto from factura inner join cliente on factura.cedula=cliente.cedula inner join empleado on factura.id=empleado.id inner join detalle_factura on factura.cod_factura=detalle_factura.codigo_factura inner join producto on detalle_factura.cod_producto=producto.cod_producto;
+----------+-------+-------------+--------------+
| cedula   | id    | cod_factura | cod_producto |
+----------+-------+-------------+--------------+
| 15512675 | VEN01 | FAC01       | AZ01         |
| 15512675 | VEN01 | FAC01       | AZ04         |
| 15512675 | VEN01 | FAC01       | AZ03         |
| 15512675 | VEN01 | FAC01       | AZ02         |
| 39448557 | VEN01 | FAC04       | AZ03         |
| 39448557 | VEN01 | FAC04       | AZ01         |
| 39448557 | VEN02 | FAC03       | AZ02         |
| 15512675 | VEN02 | FAC06       | AZ01         |
| 39448559 | SEC01 | FAC02       | AZ01         |
| 39448559 | SEC01 | FAC02       | AZ04         |
| 34657887 | SEC01 | FAC05       | AZ01         |
| 34657887 | SEC01 | FAC05       | AZ03         |
+----------+-------+-------------+--------------+
12 rows in set (0.00 sec)

mysql> show tables;
+-----------------+
| Tables_in_final |
+-----------------+
| cliente         |
| compra          |
| detalle_compra  |
| detalle_factura |
| detalle_pedido  |
| domicilio       |
| empleado        |
| factura         |
| inicio          |
| pedido          |
| perfil          |
| producto        |
| proveedor       |
| supermercado    |
+-----------------+
14 rows in set (0.00 sec)

mysql> select empleado.cod_perfil,perfil.cod_perfil from empleado inner join perfil on empleado.cod_perfil=perfil.cod_perfil;
+------------+------------+
| cod_perfil | cod_perfil |
+------------+------------+
| CAR01      | CAR01      |
| CAR01      | CAR01      |
| CAR02      | CAR02      |
+------------+------------+
3 rows in set (0.00 sec)

mysql> describe cliente;
+-----------+----------+------+-----+---------+-------+
| Field     | Type     | Null | Key | Default | Extra |
+-----------+----------+------+-----+---------+-------+
| cedula    | char(10) | NO   | PRI | NULL    |       |
| nombre1   | char(20) | NO   |     | NULL    |       |
| nombre2   | char(20) | YES  |     | NULL    |       |
| apellido1 | char(20) | NO   |     | NULL    |       |
| apellido2 | char(20) | NO   |     | NULL    |       |
| direccion | char(15) | NO   |     | NULL    |       |
| telefono  | char(10) | NO   |     | NULL    |       |
| estado    | char(20) | NO   |     | NULL    |       |
+-----------+----------+------+-----+---------+-------+
8 rows in set (0.01 sec)

mysql> describe domicilio;
+---------------+----------+------+-----+---------+-------+
| Field         | Type     | Null | Key | Default | Extra |
+---------------+----------+------+-----+---------+-------+
| cod_domicilio | char(5)  | NO   | PRI | NULL    |       |
| fecha         | date     | NO   |     | NULL    |       |
| hora          | char(5)  | NO   |     | NULL    |       |
| descripcion   | char(70) | YES  |     | NULL    |       |
| cedula        | char(10) | NO   | MUL | NULL    |       |
+---------------+----------+------+-----+---------+-------+
5 rows in set (0.01 sec)

mysql> select cliente.cedula,cliente.nombre1,cliente.nombre2,domicilio.cod_domicilio from cliente inner join domicilio on cliente.cedula=domicilio.cedula;
+----------+---------+----------+---------------+
| cedula   | nombre1 | nombre2  | cod_domicilio |
+----------+---------+----------+---------------+
| 15512675 | Luis    | Fernando | DOM02         |
| 15512675 | Luis    | Fernando | DOM04         |
| 39448557 | Jhojan  | Estiven  | DOM03         |
| 39448559 | Diana   | Milena   | DOM01         |
+----------+---------+----------+---------------+
4 rows in set (0.00 sec)

mysql> show tables;
+-----------------+
| Tables_in_final |
+-----------------+
| cliente         |
| compra          |
| detalle_compra  |
| detalle_factura |
| detalle_pedido  |
| domicilio       |
| empleado        |
| factura         |
| inicio          |
| pedido          |
| perfil          |
| producto        |
| proveedor       |
| supermercado    |
+-----------------+
14 rows in set (0.00 sec)

mysql> select pedido.cod_pedido,producto.cod_producto,producto.nombre,proveedor.cod_proveedor,proveedor.nombre from pedido inner join detalle_pedido on pedido.cod_pedido=detalle_pedido.cod_pedido inner join producto on detalle_pedido.cod_producto=producto.cod_producto inner join proveedor on pedido.cod_proveedor=proveedor.cod_proveedor;
+------------+--------------+----------+---------------+------------+
| cod_pedido | cod_producto | nombre   | cod_proveedor | nombre     |
+------------+--------------+----------+---------------+------------+
|          1 | AZ01         | Arroz    | PROV01        | Fritolight |
|          2 | AZ02         | Frijoles | PROV01        | Fritolight |
|          3 | AZ03         | Lentejas | PROV02        | Coca-cola  |
|          4 | AZ04         | Quesito  | PROV02        | Coca-cola  |
+------------+--------------+----------+---------------+------------+
4 rows in set (0.00 sec)

mysql> select * from detalle_factura;
+----------------+----------+--------------+----------+--------------+
| codigo_factura | cantidad | precio_venta | subtotal | cod_producto |
+----------------+----------+--------------+----------+--------------+
| FAC01          |        3 |            0 |        0 | AZ01         |
| FAC01          |        4 |            0 |        0 | AZ04         |
| FAC01          |        1 |            0 |        0 | AZ03         |
| FAC01          |        8 |            0 |        0 | AZ02         |
| FAC02          |       20 |            0 |        0 | AZ01         |
| FAC02          |       10 |            0 |        0 | AZ04         |
| FAC03          |        1 |            0 |        0 | AZ02         |
| FAC04          |       19 |            0 |        0 | AZ03         |
| FAC04          |       15 |            0 |        0 | AZ01         |
| FAC05          |       15 |            0 |        0 | AZ01         |
| FAC05          |       15 |            0 |        0 | AZ03         |
| FAC06          |       30 |            0 |        0 | AZ01         |
+----------------+----------+--------------+----------+--------------+
12 rows in set (0.00 sec)

mysql> select * from producto; 
+--------------+----------+----------+-------+
| cod_producto | nombre   | cantidad | costo |
+--------------+----------+----------+-------+
| AZ01         | Arroz    |      100 |  1300 |
| AZ02         | Frijoles |      100 |  1400 |
| AZ03         | Lentejas |      100 |  1250 |
| AZ04         | Quesito  |       50 |  2000 |
+--------------+----------+----------+-------+
4 rows in set (0.00 sec)

mysql> update detalle_factura set precio_venta=cantidad*(select costo from producto where producto.cod_producto=detalle_factura.cod_producto);
Query OK, 12 rows affected (0.05 sec)
Rows matched: 12  Changed: 12  Warnings: 0

mysql> select * from detalle_factura;
+----------------+----------+--------------+----------+--------------+
| codigo_factura | cantidad | precio_venta | subtotal | cod_producto |
+----------------+----------+--------------+----------+--------------+
| FAC01          |        3 |         3900 |        0 | AZ01         |
| FAC01          |        4 |         8000 |        0 | AZ04         |
| FAC01          |        1 |         1250 |        0 | AZ03         |
| FAC01          |        8 |        11200 |        0 | AZ02         |
| FAC02          |       20 |        26000 |        0 | AZ01         |
| FAC02          |       10 |        20000 |        0 | AZ04         |
| FAC03          |        1 |         1400 |        0 | AZ02         |
| FAC04          |       19 |        23750 |        0 | AZ03         |
| FAC04          |       15 |        19500 |        0 | AZ01         |
| FAC05          |       15 |        19500 |        0 | AZ01         |
| FAC05          |       15 |        18750 |        0 | AZ03         |
| FAC06          |       30 |        39000 |        0 | AZ01         |
+----------------+----------+--------------+----------+--------------+
12 rows in set (0.00 sec)

mysql> update detalle_factura set subtotal=precio_venta+(precio_venta*0.15);
Query OK, 12 rows affected (0.04 sec)
Rows matched: 12  Changed: 12  Warnings: 0

mysql> select * from detalle_factura;
+----------------+----------+--------------+----------+--------------+
| codigo_factura | cantidad | precio_venta | subtotal | cod_producto |
+----------------+----------+--------------+----------+--------------+
| FAC01          |        3 |         3900 |     4485 | AZ01         |
| FAC01          |        4 |         8000 |     9200 | AZ04         |
| FAC01          |        1 |         1250 |   1437.5 | AZ03         |
| FAC01          |        8 |        11200 |    12880 | AZ02         |
| FAC02          |       20 |        26000 |    29900 | AZ01         |
| FAC02          |       10 |        20000 |    23000 | AZ04         |
| FAC03          |        1 |         1400 |     1610 | AZ02         |
| FAC04          |       19 |        23750 |  27312.5 | AZ03         |
| FAC04          |       15 |        19500 |    22425 | AZ01         |
| FAC05          |       15 |        19500 |    22425 | AZ01         |
| FAC05          |       15 |        18750 |  21562.5 | AZ03         |
| FAC06          |       30 |        39000 |    44850 | AZ01         |
+----------------+----------+--------------+----------+--------------+
12 rows in set (0.00 sec)

mysql> select * from cliente;
+----------+---------+----------+-----------+-----------+-----------+----------+--------+
| cedula   | nombre1 | nombre2  | apellido1 | apellido2 | direccion | telefono | estado |
+----------+---------+----------+-----------+-----------+-----------+----------+--------+
| 15512675 | Luis    | Fernando | Garcia    | Pati¤o    | Rionegro  | 6147089  | Activo |
| 34657887 | Kelly   | Alexa    | Londo¤o   | Arango    | Medellin  | 4965005  | Activo |
| 39448557 | Jhojan  | Estiven  | Garcia    | Pati¤o    | Rionegro  | 6147089  | Activo |
| 39448559 | Diana   | Milena   | Pati¤o    | Ramirez   | Medellin  | 6147089  | Activo |
+----------+---------+----------+-----------+-----------+-----------+----------+--------+
4 rows in set (0.00 sec)

mysql> update cliente set estado='Inactivo' where direccion='Medellin';
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2  Changed: 2  Warnings: 0

mysql> select * from cliente;
+----------+---------+----------+-----------+-----------+-----------+----------+----------+
| cedula   | nombre1 | nombre2  | apellido1 | apellido2 | direccion | telefono | estado   |
+----------+---------+----------+-----------+-----------+-----------+----------+----------+
| 15512675 | Luis    | Fernando | Garcia    | Pati¤o    | Rionegro  | 6147089  | Activo   |
| 34657887 | Kelly   | Alexa    | Londo¤o   | Arango    | Medellin  | 4965005  | Inactivo |
| 39448557 | Jhojan  | Estiven  | Garcia    | Pati¤o    | Rionegro  | 6147089  | Activo   |
| 39448559 | Diana   | Milena   | Pati¤o    | Ramirez   | Medellin  | 6147089  | Inactivo |
+----------+---------+----------+-----------+-----------+-----------+----------+----------+
4 rows in set (0.00 sec)

mysql> select * from detalle_pedido;
+------------+--------------+----------+--------------+----------+
| cod_pedido | cod_producto | cantidad | precio_venta | subtotal |
+------------+--------------+----------+--------------+----------+
|          1 | AZ01         |       50 |            0 |        0 |
|          2 | AZ02         |       60 |            0 |        0 |
|          3 | AZ03         |       70 |            0 |        0 |
|          4 | AZ04         |       80 |            0 |        0 |
+------------+--------------+----------+--------------+----------+
4 rows in set (0.00 sec)

mysql> select * from detalle_pedido;
+------------+--------------+----------+--------------+----------+
| cod_pedido | cod_producto | cantidad | precio_venta | subtotal |
+------------+--------------+----------+--------------+----------+
|          1 | AZ01         |       50 |            0 |        0 |
|          2 | AZ02         |       60 |            0 |        0 |
|          3 | AZ03         |       70 |            0 |        0 |
|          4 | AZ04         |       80 |            0 |        0 |
+------------+--------------+----------+--------------+----------+
4 rows in set (0.00 sec)

mysql> select * from detalle_compra;
+------------+--------------+-------------+----------+--------------+----------+
| cod_compra | cod_producto | descripcion | cantidad | precio_venta | subtotal |
+------------+--------------+-------------+----------+--------------+----------+
| COM01      | AZ01         | Mercado     |        3 |            0 |        0 |
| COM01      | AZ02         |             |        3 |            0 |        0 |
| COM01      | AZ04         |             |        5 |            0 |        0 |
| COM02      | AZ02         |             |        1 |            0 |        0 |
| COM02      | AZ03         |             |        2 |            0 |        0 |
| COM03      | AZ01         |             |        5 |            0 |        0 |
| COM03      | AZ04         |             |        3 |            0 |        0 |
+------------+--------------+-------------+----------+--------------+----------+
7 rows in set (0.00 sec)

mysql> update detalle_pedido set precio_venta=cantidad*(select costo from producto where producto.cod_producto=detalle_pedido.cod_producto);
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4  Changed: 4  Warnings: 0

mysql> select * from detalle_pedido;
+------------+--------------+----------+--------------+----------+
| cod_pedido | cod_producto | cantidad | precio_venta | subtotal |
+------------+--------------+----------+--------------+----------+
|          1 | AZ01         |       50 |        65000 |        0 |
|          2 | AZ02         |       60 |        84000 |        0 |
|          3 | AZ03         |       70 |        87500 |        0 |
|          4 | AZ04         |       80 |       160000 |        0 |
+------------+--------------+----------+--------------+----------+
4 rows in set (0.00 sec)

mysql> update detalle_pedido set subtotal=precio_venta+(precio_venta*0.15);
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4  Changed: 4  Warnings: 0

mysql> select * from detalle_pedido;
+------------+--------------+----------+--------------+----------+
| cod_pedido | cod_producto | cantidad | precio_venta | subtotal |
+------------+--------------+----------+--------------+----------+
|          1 | AZ01         |       50 |        65000 |    74750 |
|          2 | AZ02         |       60 |        84000 |    96600 |
|          3 | AZ03         |       70 |        87500 |   100625 |
|          4 | AZ04         |       80 |       160000 |   184000 |
+------------+--------------+----------+--------------+----------+
4 rows in set (0.00 sec)

mysql> select * from detalle_compra;
+------------+--------------+-------------+----------+--------------+----------+
| cod_compra | cod_producto | descripcion | cantidad | precio_venta | subtotal |
+------------+--------------+-------------+----------+--------------+----------+
| COM01      | AZ01         | Mercado     |        3 |            0 |        0 |
| COM01      | AZ02         |             |        3 |            0 |        0 |
| COM01      | AZ04         |             |        5 |            0 |        0 |
| COM02      | AZ02         |             |        1 |            0 |        0 |
| COM02      | AZ03         |             |        2 |            0 |        0 |
| COM03      | AZ01         |             |        5 |            0 |        0 |
| COM03      | AZ04         |             |        3 |            0 |        0 |
+------------+--------------+-------------+----------+--------------+----------+
7 rows in set (0.00 sec)

mysql> update detalle_compra set precio_venta=cantidad*(select costo from producto where producto.cod_producto=detalle_compra.cod_producto);
Query OK, 7 rows affected (0.00 sec)
Rows matched: 7  Changed: 7  Warnings: 0

mysql> select * from detalle_compra;
+------------+--------------+-------------+----------+--------------+----------+
| cod_compra | cod_producto | descripcion | cantidad | precio_venta | subtotal |
+------------+--------------+-------------+----------+--------------+----------+
| COM01      | AZ01         | Mercado     |        3 |         3900 |        0 |
| COM01      | AZ02         |             |        3 |         4200 |        0 |
| COM01      | AZ04         |             |        5 |        10000 |        0 |
| COM02      | AZ02         |             |        1 |         1400 |        0 |
| COM02      | AZ03         |             |        2 |         2500 |        0 |
| COM03      | AZ01         |             |        5 |         6500 |        0 |
| COM03      | AZ04         |             |        3 |         6000 |        0 |
+------------+--------------+-------------+----------+--------------+----------+
7 rows in set (0.00 sec)

mysql> update detalle_compra set subtotal=precio_venta+(precio_venta*0.15);
Query OK, 7 rows affected (0.00 sec)
Rows matched: 7  Changed: 7  Warnings: 0

mysql> select * from detalle_compra;
+------------+--------------+-------------+----------+--------------+----------+
| cod_compra | cod_producto | descripcion | cantidad | precio_venta | subtotal |
+------------+--------------+-------------+----------+--------------+----------+
| COM01      | AZ01         | Mercado     |        3 |         3900 |     4485 |
| COM01      | AZ02         |             |        3 |         4200 |     4830 |
| COM01      | AZ04         |             |        5 |        10000 |    11500 |
| COM02      | AZ02         |             |        1 |         1400 |     1610 |
| COM02      | AZ03         |             |        2 |         2500 |     2875 |
| COM03      | AZ01         |             |        5 |         6500 |     7475 |
| COM03      | AZ04         |             |        3 |         6000 |     6900 |
+------------+--------------+-------------+----------+--------------+----------+
7 rows in set (0.00 sec)

mysql> select * from factura;
+-------------+------------+-----------+------+-------+----------+
| cod_factura | fecha      | hora      | neto | id    | cedula   |
+-------------+------------+-----------+------+-------+----------+
| FAC01       | 2013-02-02 | 2013-02-0 |    0 | VEN01 | 15512675 |
| FAC02       | 2013-02-03 | 2013-02-0 |    0 | SEC01 | 39448559 |
| FAC03       | 2013-02-04 | 2013-01-0 |    0 | VEN02 | 39448557 |
| FAC04       | 2013-02-05 | 2013-07-0 |    0 | VEN01 | 39448557 |
| FAC05       | 2013-03-05 | 2013-08-0 |    0 | SEC01 | 34657887 |
| FAC06       | 2013-03-07 | 2013-09-0 |    0 | VEN02 | 15512675 |
+-------------+------------+-----------+------+-------+----------+
6 rows in set (0.00 sec)

mysql> select * from detalle_factura;
+----------------+----------+--------------+----------+--------------+
| codigo_factura | cantidad | precio_venta | subtotal | cod_producto |
+----------------+----------+--------------+----------+--------------+
| FAC01          |        3 |         3900 |     4485 | AZ01         |
| FAC01          |        4 |         8000 |     9200 | AZ04         |
| FAC01          |        1 |         1250 |   1437.5 | AZ03         |
| FAC01          |        8 |        11200 |    12880 | AZ02         |
| FAC02          |       20 |        26000 |    29900 | AZ01         |
| FAC02          |       10 |        20000 |    23000 | AZ04         |
| FAC03          |        1 |         1400 |     1610 | AZ02         |
| FAC04          |       19 |        23750 |  27312.5 | AZ03         |
| FAC04          |       15 |        19500 |    22425 | AZ01         |
| FAC05          |       15 |        19500 |    22425 | AZ01         |
| FAC05          |       15 |        18750 |  21562.5 | AZ03         |
| FAC06          |       30 |        39000 |    44850 | AZ01         |
+----------------+----------+--------------+----------+--------------+
12 rows in set (0.00 sec)

mysql> select * from domicilio;
+---------------+------------+-------+-------------+----------+
| cod_domicilio | fecha      | hora  | descripcion | cedula   |
+---------------+------------+-------+-------------+----------+
| DOM01         | 2013-05-06 | 12:43 | Mercado     | 39448559 |
| DOM02         | 2013-02-01 | 11:15 | Mercado     | 15512675 |
| DOM03         | 2013-12-12 | 12:50 | Mercado     | 39448557 |
| DOM04         | 2013-02-02 | 09:30 | Mercado     | 15512675 |
+---------------+------------+-------+-------------+----------+
4 rows in set (0.00 sec)

mysql> select * from cliente;
+----------+---------+----------+-----------+-----------+-----------+----------+----------+
| cedula   | nombre1 | nombre2  | apellido1 | apellido2 | direccion | telefono | estado   |
+----------+---------+----------+-----------+-----------+-----------+----------+----------+
| 15512675 | Luis    | Fernando | Garcia    | Pati¤o    | Rionegro  | 6147089  | Activo   |
| 34657887 | Kelly   | Alexa    | Londo¤o   | Arango    | Medellin  | 4965005  | Inactivo |
| 39448557 | Jhojan  | Estiven  | Garcia    | Pati¤o    | Rionegro  | 6147089  | Activo   |
| 39448559 | Diana   | Milena   | Pati¤o    | Ramirez   | Medellin  | 6147089  | Inactivo |
+----------+---------+----------+-----------+-----------+-----------+----------+----------+
4 rows in set (0.00 sec)


mysql> select cliente.nombre1, cliente.nombre2, cliente.cedula from cliente left join domicilio on cliente.cedula=domicilio.cedula where domicilio.cedula is null; 
+---------+---------+----------+
| nombre1 | nombre2 | cedula   |
+---------+---------+----------+
| Kelly   | Alexa   | 34657887 |
+---------+---------+----------+
1 row in set (0.00 sec)