Lesson 5 of 5 • 4 upvotes • 10:10mins
Example to calculate canonical cover; non loss and lossless join decomposition- what it actually is? ; How to calculate candidate keys (note : to calculate all candidate keys find closure for all possible subsets of a relation and if a closure has all the attributes then it a candidate key. Note: don't find closure for supersets of already found candidate keys as they are superkeys)
5 lessons • 47m