Derivada fragmenta

Solo disponible en BuenasTareas
  • Páginas : 2 (462 palabras )
  • Descarga(s) : 0
  • Publicado : 3 de marzo de 2011
Leer documento completo
Vista previa del texto
Bases de Datos Distribuidas

De las siguientes tablas elaborar las siguientes fragmentaciones horizontales derivadas:
E
ENO | ENAME | TITLE |
E1 | J.DOC | ELECT. ENGT |
E2 | M., SMITH |SYST. ANAL. |
E3 | A., LEE | MECH. ENG. |
E4 | J., MILLER | PROGRAMMER |
E5 | B., CASEY | SYST. ANAL |
E6 | L., CHU | ELECT. ENG. |
E7 | R. DAVIS | MECH. ENG. |
E8 | J. JONES | SYST. ANAL. |J
JNO | JNAME | BUDGET | LOC |
J1 | INSTRUMENTATION | 150000 | MONTREAL |
J2 | DTABASE DEVELOP | 135000 | NEW YORK |
J3 | CAD/CAM | 250000 | NEW YORK |
J4 | MAINTENANCE | 310000 | PARIS |J5 | CAD/CAM | 500000 | BOSTON |

G
ENO | JNO | RESP | DUR |
E1 | J1 | MANAGER | 12 |
E2 | J1 | ANALYST | 24 |
E2 | J2 | ANALYST | 6 |
E3 | J3 | CONSULTANT | 10 |
E3 | J4 | ENGINEER |48 |
E4 | J2 | PROGRAMMER | 18 |
E5 | J2 | MANAGER | 24 |
E6 | J4 | MANAGER | 48 |
E7 | J3 | ENGINEER | 36 |
E7 | J5 | ENGINEER | 23 |
E8 | J3 | MANAGER | 40 |

S
TITTLE | SAL |ELECT. ENG | 40000 |
SYST. ANAL. | 34000 |
MECH. ENG. | 27000 |
PROGRAMMER | 24000 |

Ejercicio 1
Dividir los grupos cuya localidad sea igual a New York.
P1 LOC =’New York’ m1= Loc=New York m2= LOC New York
J1
JNO | JNAME | BUDGET | LOC |
J2 | Database Develop | 135000 | New York |
J3 | CAD/CAM | 250000 | New York |

J2

JNO | JNAME | BUDGET | LOC |
J1 |Instrumentation | 150000 | Montreal |
J4 | Maintenance | 310000 | Paris |
J5 | CAD/CAM | 500000 | Boston |

G1= G J1
ENO | JNO | RESP | DUR |
E2 | J2 | Analyst | 6 |
E3 | J3 |Consultant | 10 |
E4 | J2 | Programmer | 18 |
E5 | J2 | Manager | 24 |
E6 | J3 | Engineer | 36 |

G2= G J2

ENO | JNO | RESP | DUR |
E1 | J1 | Engineer | 12 |
E2 | J1 |Analyst | 24 |
E3 | J4 | Engineer | 48 |
E6 | J4 | Manager | 48 |
E7 | J5 | Engineer | 23 |

Ejercicio 2:
Dividir los grupos cuyo Titulo sea igual a 'Analista de Sistemas'.
E1
ENO | ENAME |...
tracking img