Functional Dependency Preservation Problem

Pensu

Pensu

@pensu-8tNeGU Oct 15, 2024

I have a problem regarding decomposition of a relation. Suppose i have a relation R(A,B,C,D) with functional dependencies A->B, B->C, C->D, D->A.

Now I have divided this in the following three relations :
R1(AB), R2(BC), R3(CD).

My question: Is the functional dependency preserved in this decomposition? If yes, then How?

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

CrazyEngineers powered by Jatra Community Platform

  • Pensu

    Pensu

    @pensu-8tNeGU Jan 20, 2011

    No reply.....😔