Come up with instances of the tables to illustrate the following. (a) We have a table...

Transcribed Image Text:

Come up with instances of the tables to illustrate the following. (a) We have a table R(A, B, C), and functional dependency A → B, but the functional dependency B→ A does not hold. (b) We have a table R(A, B, C), with (minimal) key (A, C), and functional dependency A → B. Show an instance that has redundancy. Highlight the value which is redundant. Come up with instances of the tables to illustrate the following. (a) We have a table R(A, B, C), and functional dependency A → B, but the functional dependency B→ A does not hold. (b) We have a table R(A, B, C), with (minimal) key (A, C), and functional dependency A → B. Show an instance that has redundancy. Highlight the value which is redundant.

Answer rating: 100% (QA)

a Table RA B C with the functional dependency A B but not B A A B C 1 2 3 2 3 4 3 4 5 In th... View the full answer