-*- 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 |
+---------+------------------+----+---------+----------+
               (
geocities.com/ar)