Difference between revisions of "Lab 7"
From bd_en
(→Exercises) |
(→Exercises) |
||
Line 6: | Line 6: | ||
==Exercises== | ==Exercises== | ||
− | # https://profs.info.uaic.ro/~vcosmin/pagini/resurse_bd/Relational_Algebra_Exercices.pdf Exercises illustrating Relational Algebra concepts] | + | # [https://profs.info.uaic.ro/~vcosmin/pagini/resurse_bd/Relational_Algebra_Exercices.pdf Exercises illustrating Relational Algebra concepts] |
# For the first three exercises in lab 4, identify the functional dependencies in the tables obtain as result of the joins. | # For the first three exercises in lab 4, identify the functional dependencies in the tables obtain as result of the joins. | ||
# Modify one of the tables in order to obtain multivalues dependencies. | # Modify one of the tables in order to obtain multivalues dependencies. |
Revision as of 21:30, 14 November 2017
Agenda:
- operators in relational algebra
- functional and multivalued dependencies
Exercises
- Exercises illustrating Relational Algebra concepts
- For the first three exercises in lab 4, identify the functional dependencies in the tables obtain as result of the joins.
- Modify one of the tables in order to obtain multivalues dependencies.