Hello everyone I need just to answer question just 3.2.2 and I put the question

ID: 3776546 • Letter: H

Question

Hello everyone I need just to answer question just 3.2.2 and I put the question 3.2.1 and its answer so that helps you to answer question 3.2.2

Exercise 3.2.2: Repeat Exercise 3.2.1 for t:he following schemas and sets of FD's::

Here is the question 3.2.1 and its answer

Exercise 3.2,1: Consider a relation with schema R(A, B, C,D) and FD's

a) What are all. the nontrivial FD's that follow from the given FD's? You should restrict yourself to FD's 'With single attributes on the right side

b) What are all the keys of R?

c) What are all the superkeys £or R that are not keys?

The answer:

Following are functional dependencies (FD) { A -> B,B -> C , B->D
AB->C, BC->D,CD->A ,AD->B

A->B,B->C,C->D and D->A}

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.