Database normalization

Let’s assume that we have a R (year, author, title, ISSN, journal, affiliation) relationship and the following functional dependencies: title -> author, ISSN -> journal, title -> ISSN, title -> year . We also have the multi-valued author - >> affiliation . My question is how can I find the canditdate keys of the relationship? What do I do with the multi-valued dependency, do I treat it as a functional dependency?

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.