The following is the translation of the E/R Diagram into relations. Everything is in BCNF and 4NF.
Conversion of Entity Sets
Words(stem) Criticism(publication, url, synopsis, title) Author(name, birth, death, description) Period(region, era) Works(id, title, year, length)
Conversion of Relationships
Pages(work, pageNumber) WordContexts(work, pageNumber, position, actualText) Instance(word, work, pageNumber, position) Synonym(root, child) WrittenIn(work, region, era) Criticized(work, url) WroteCriticism(author, url) LivedIn(name, region, era) WrittenBy(author, work)
Functional Dependencies
Criticism: url -> publication, synopsis, title Author: name -> birth, death, description Works: id -> title, year, length WordContexts: work, pageNumber, position -> actualText