CODEWITHSUNDEEP
databasedatabase-schemafunctional-dependencies
jsan
jsan

Reputation: 1057

Removing triviality from functional dependencies

For a relation schema R=(A,B,C,D,E,G,H,I)

If there is the FD GHB --> AB, can I remove B from both sides, since B --> B is trivial, giving me GH --> A?

Upvotes: 0

Views: 189

Answers (1)

Agnieszka
Agnieszka

Reputation: 336

No. You can remove B from the right side, getting the functional dependency GHB -> A. But all three of GHB are needed to determine A.

Upvotes: 1

Related Questions