Ejercicios algebra relacional

Programación y Taller de Base de Datos
Alumno: Hugo Palominos Cornejo
Ayudante: José Luis Peña
Solución Ejercicios de Laboratorio

s |
B | C | E |
1 | S | M |
2 | D | B |
3 | G | N |4 | S | M |
5 | F | L |
6 | G | N |
7 | H | B |
8 | G | L |
9 | A | P |
r |
A | B | C | D |
1 | 1 | S | r |
2 | 5 | F | e |
3 | 9 | S | f |
4 | 8 | A | j |
5 | 7 | H | f |
6| 6 | G | j |
7 | 5 | D | K |
8 | 6 | G | p |
9 | 9 | A | x |

1.- | σA<=4(r) |
A | B | C | D |
1 | 1 | S | r |
2 | 5 | F | e |
3 | 9 | S | f |
4 | 8 | A | j |

2.- |ΠA,C,D(r) |
A | C | D |
1 | S | r |
2 | F | e |
3 | S | f |
4 | A | j |
5 | H | f |
6 | G | j |
7 | D | K |
8 | G | p |
9 | A | x |

3.- | r * s |
A | B | C | D | E |
1 | 1 | S | r |M |
2 | 5 | F | e | L |
5 | 7 | H | f | B |
6 | 6 | G | j | N |
8 | 6 | G | p | N |
9 | 9 | A | x | P |

4.- | r x s |
A | B | C | D | B | C | E |
1 | 1 | S | r | 1 | S | M |
1 | 1| S | r | 2 | D | B |
1 | 1 | S | r | 3 | G | N |
1 | 1 | S | r | 4 | S | M |
1 | 1 | S | r | 5 | F | L |
1 | 1 | S | r | 6 | G | N |
1 | 1 | S | r | 7 | H | B |
1 | 1 | S | r | 8 | G | L|
1 | 1 | S | r | 9 | A | P |
2 | 5 | F | e | 1 | S | M |
2 | 5 | F | e | 2 | D | B |
2 | 5 | F | e | 3 | G | N |
2 | 5 | F | e | 4 | S | M |
2 | 5 | F | e | 5 | F | L |
2 | 5 | F | e |6 | G | N |
2 | 5 | F | e | 7 | H | B |
2 | 5 | F | e | 8 | G | L |
2 | 5 | F | e | 9 | A | P |
2 | 5 | F | e | 1 | S | M |
3 | 9 | S | f | 2 | D | B |
3 | 9 | S | f | 3 | G | N |
3 | 9| S | f | 4 | S | M |
3 | 9 | S | f | 5 | F | L |
3 | 9 | S | f | 6 | G | N |
3 | 9 | S | f | 7 | H | B |
3 | 9 | S | f | 8 | G | L |
3 | 9 | S | f | 9 | A | P |
… | … | … | … | … | … | …|
8 | 6 | G | p | 1 | S | M |
8 | 6 | G | p | 2 | D | B |
8 | 6 | G | p | 3 | G | N |
8 | 6 | G | p | 4 | S | M |
8 | 6 | G | p | 5 | F | L |
8 | 6 | G | p | 6 | G | N |
8 | 6 | G |...