Difference between revisions of "Lab 7"

From bd_en
Jump to: navigation, search
(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:

  1. operators in relational algebra
  2. functional and multivalued dependencies

Course slides

Exercises

  1. Exercises illustrating Relational Algebra concepts
  2. For the first three exercises in lab 4, identify the functional dependencies in the tables obtain as result of the joins.
  3. Modify one of the tables in order to obtain multivalues dependencies.