Please read the following situation and construct an E-R diagram, using the concepts we learnt in class. We should use a computer graphing package, such as MS Powerpoint, to construct the E-R diagram, so it looks professional. Turn in a hard copy of the sketch at the due time. .

POP organization:

The POP (publish-or-perish) organization publishes several academic journals. They would like us to build them a database system, to help manage their business. As a first step, you interview 5 key users, and this is what we end up with after the interview.

Description of user requirements:

POP publishes a few hundred journals. A journal has a name, a chief editor, and several area editors. Each issue of a journal has a date and contains several articles. For example, the Journal of IS will have several issues, each one with an issue ID, starting from 1. Each article has a title, up to 10 authors, an area topic, and an abstract. POP interfaces heavily with the research community. All work at POP is done by members of the research community. Members of the research community have a name, an institution (no pun) to which they belong, an address, a phone number and up to 3 different research specialties.

A researcher can be a chief editor of up to 3 journals (all different of course), at any one time. In addition, a researcher can be an area editor of up to 8 journals. Chief editors and area editors of a journal are disjoint sets (the same person cannot both chief edit and area edit the same journal). Researchers also serve as reviewers for articles that have been submitted for review to a particular journal. All articles are written by researchers, and all articles are submitted for review to journals. A submitted article has a name, authors, an area topic, an abstract and from 2-4 reviewers. If it gets published, it becomes a published article, and appears in an issue of the journal to which it was submitted. If an article is submitted to multiple journals, it is treated as a separate submission (a new article) each time.

Reviewers for a particular journal are disjoint from the editors of that journal. A researcher cannot submit an article to a journal for which he/she is an editor, and also cannot review an article for which he/she is an author. Note that a researcher can be an editor as well as a reviewer, just not of the same journal. Similarly, researchers can be reviewers as well as authors, just not for the same article. Finally, researchers can be chief and area editors, just not of the same journal.