Question: From the situation described below, draw the appropriate data model. The editors of a National Geographic magazine receive many articles that are submitted for publication.

From the situation described below, draw the appropriate data model.

The editors of a National Geographic magazine receive many articles that are submitted for publication. Each editor is uniquely identified by an editor ID. In addition, the editor's name, contact information, specific position (Associate, Assistant, Chief Editor) and email address are stored. The magazine has several sections and editors are assigned to sections such as 'Arts', 'Culture', 'Politics', 'Technology', and more. Editors can be assigned to more than one section of the magazine and sections can have multiple editors.

Articles published in the magazine are written by journalists. Each article is identified by an article ID. The title of the article, the content of the article, date of submission are also tracked. Articles are submitted to specific sections of the magazine and are only submitted to one section of the magazine.

Journalists can submit none or multiple articles to the magazine and Each journalist that submits an article to the magazine has their name, address, and email address stored. Journalists are of 2 types. Journalists either work on a contract basis with the magazine or on a freelance basis with the magazine and can submit many articles to the magazine. Contract journalists turn in articles on a regular basis but freelance journalists are paid on a per word basis. Occasionally multiple journalists may collaborate on an article. When multiple journalists collaborate on an article the order in which the article is credited (names show up in the article byline) is also stored.

After an article has been submitted by a journalist/s, the article is assigned an editor that reads the article for editorial approval and proof reading. An article can go through several such review processes before its ready to publish. Information about each iteration of revision such as the date the article was turned in, the date the feedback was provided, what the outcome of the editorial review process was (Accept, Reject, Resubmit) is stored in the database. Information about resubmissions after an initial submission are stored in the database where the resubmission is related to the initial article submission. Additionally the date of editorial comments and the comments and feedback themselves are recorded in the database.

After the editorial process is complete the article is ready to publish and the date of final acceptance is recorded and the article is also assigned a date to be published on the magazine's website and the issue number in which the article is to be published. Information about which articles are published in an issue are stored as a number of articles are published in each issue. Each issue has a year of publication, an issue number, a date of publication and information about the chief editor of the issue. An editor can be the chief editor of multiple issues of the magazine or never be a chief editor.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!