Question

Classify the entities, attributes and relationship among them for following scenario, and create a database for the company.

A publishing company produces scientific books on a variety of subjects. The books are written by authors who specialize in one particular subject. The company employs editors who, not essentially being specialists in a particular area, each take sole responsibility for editing one or more publications. A publication covers basically one of the specialist subjects and is usually written by a single author. When writing a particular book, each author works with one editor, but may submit another work for publication to be supervised by other editors. To advance their competitiveness, the company tries to employ a variety of authors, additional than one author being a specialist in a particular subject.