[Database Design Normalization: multi-valued dependency] In the relation BOOK(Book_Name, Author, Edition, Copyright_Year), there are three multi-valued dependencies (MVDs):

MVD1: {Book_Name} {Author}

MVD2: {Book_Name} {Edition}

MVD3: {Book_Name} {Copyright_Year}

MVD1 is independent of the other two. On the other hand, MVD2 and MVD3 are not independent of each other. Indeed, some books have multiple editions published in the same year and, thus, there is a functional dependency (FD): {Book_Name, Edition} -> {Copyright_Year}.

Now, decompose the relation BOOK into the fourth normal form. In each decomposed relation, underline primary keys, show foreign keys (if there is any), and list the FDs or MVDs applicable to the relation.