-*- coding:iso-8859-1.unix; -*-

Sistemas de bases de datos, conceptos fundamentales
Elmasri, Navathe
segunda edición

Figura 6.6 (página 148)



       EMPLEADO

+--------+----+--------+---------+---------+--------------------------+----+-------+---------+---+
|NOMBREP |INIC|APELLIDO|NSS      |FECHAN   |DIRECCIÓN                 |SEXO|SALARIO|NSSSUPER | ND|
+--------+----+--------+---------+---------+--------------------------+----+-------+---------+---+
|José    |  B |Silva   |123456789|09-ENE-55| Fresnos 731, Higueras, MX|  M | 30000 |333445555| 5 |
|Federico|  T |Vizcarra|333445555|08-DIC-45| Valle 638, Higueras, MX  |	 M | 40000 |888665555| 5 |
|Alicia	 |  J |Zapata  |999887777|19-JUL-58| Catillo 3321, Sucre, MX  |	 F | 25000 |987654321| 4 |
|Jazmín	 |  S |Valdés  |987654321|20-JUN-31| Bravo 291, Belén, MX     |	 F | 43000 |888665555| 4 |
|Ramón	 |  K |Nieto   |666884444|15-SEP-52| Espiga 875, Heras, MX    |	 M | 38000 |333445555| 5 |
|Josefa	 |  A |Esparza |453453453|31-JUL-62| Rosas 5631, Higueras, MX |	 F | 25000 |333445555| 5 |
|Ahmed	 |  V |Jabbar  |987987987|29-MAR-59| Dallas 980, Higueras, MX |	 M | 25000 |987654321| 4 |
|Jaime	 |  E |Botello |888665555|10-NOV-27| Sorgo 450, Higueras, MX  |	 M | 55000 |   nulo  | 1 |
+--------+----+--------+---------+---------+--------------------------+----+-------+---------+---+


	DEPARTAMENTO

+---------------+-------+---------+-------------+
|NOMBRED        |NÚMEROD|  NSSGTE |FECHAINICGTE |
+---------------+-------+---------+-------------+
|Investigación	|   5	|333445555|  22-MAY-78  |
|Administración	|   4	|987654321|  01-ENE-85  |
|Dirección	|   1	|888665555|  19-jun-71  |
+---------------+-------+---------+-------------+


	LUGARES_DEPTOS

+-------+----------+
|NÚMEROD|LUGARD    |
+-------+----------+
|   1	|Higueras  |
|   4	|Santiago  |
|   5	|Belén     |
|   5	|Sacramento|
|   5  	|Higueras  |
+-------+----------+


	PROYECTO

+------------------+-------+----------+----+
|NOMBREP           |NÚMEROP|LUGARP    |NÚMD|
+------------------+-------+----------+----+
|ProductoX         |   1   |Belén     | 5  |
|ProductoY         |   2   |Sacramento| 5  |
|ProductoZ         |   3   |Higueras  | 5  |
|Automatización	   |  10   |Santiago  | 4  |
|Reorganización    |  20   |Higueras  | 1  |
|NuevasPrestaciones|  30   |Santiago  | 4  |
+------------------+-------+----------+----+


	TRABAJA_EN

+---------+----+------+
|NSSE     |NÚMP|HORAS |
+---------+----+------+
|123456789|  1 | 32.5 |
|123456789|  2 |  7.5 |
|666884444|  3 | 40.0 |
|453453453|  1 | 20.0 |
|453453453|  2 | 20.0 |
|333445555|  2 | 10.0 |
|333445555|  3 | 10.0 |
|333445555| 10 | 10.0 |
|333445555| 20 | 10.0 |
|999887777| 30 | 30.0 |
|999887777| 10 | 10.0 |
|987987987| 10 | 35.0 |
|987987987| 30 |  5.0 |
|987654321| 30 | 20.0 |
|987654321| 20 | 15.0 |
|888665555| 20 | nulo |
+---------+----+------+


	DEPENDIENTE

+---------+------------------+----+---------+----------+
|  NSSE   |NOMBRE_DEPENDIENTE|SEXO| FECHAN  |PARENTESCO|
+---------+------------------+----+---------+----------+
|333445555| Alicia	     |	F |05-ABR-76| HIJA     |
|333445555| Teodoro	     |  M |25-OCT-73| HIJO     |
|333445555| Jobita	     |  F |03-MAY-48| CÓNYUGE  |
|987654321| Adbiel	     |  M |29-FEB-32| CÓNYUGE  |
|123456789| Miguel	     |  M |01-ENE-78| HIJO     |
|123456789| Alicia	     |  F |31-DIC-78| HIJA     |
|123456789| Elizabeth	     |  F |05-MAY-57| CÓNYUGE  |
+---------+------------------+----+---------+----------+

    Source: geocities.com/ar/uap_sd2

               ( geocities.com/ar)