Identify the entities, attributes and relationship


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

A publishing company produces scientific books on various subjects. The books are written by authors who specialize in one particular subject. The company employs editors who, not necessarily being specialists in a particular area, each take sole responsibility for editing one or more publications. A publication covers essentially one of the specialist subjects and is normally 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 improve their competitiveness, the company tries to employ a variety of authors, more than one author being a specialist in a particular subject.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: Identify the entities, attributes and relationship
Reference No:- TGS090307

Expected delivery within 24 Hours