3. Consider a research article submission system, where researchers submit articles to journals in order to have them published. An article can be written by more than one author. When an article is submitted, they receive a unique submission number and an editor is assigned to manage the review of the article for scientific correctness and to evaluate its impact. The review itself is conducted by exactly two reviewers, who are assigned by the editor. The final decision of whether to accepted the article is made by the editor. If accepted, the article is published in an issue of the corresponding journal. Reviewers and editors can also submit articles. Editors inform authors about the result of decision. Reviewers can work for more than one journal, but editors can only work for one journal Journals have many editors and reviewers The following is additional information Authors have unique ID, as well as a name, association and, their specialization area . Journals each have unique ID, as well as a name, address, and contact info An issues is identified by its number in the current year of published articles An article has a title, abstract and exactly four key words. Articles may have the same title, but will have a unique title in combination with its list of key words (a) (20 points) Create an ER Diagram using BOTH Chen and Crow's Foot notation (to be sure that you get practice!). Be sure to clearly and appropriately indicate any keys, weak entities. relationship constraints, etc. authors name) Article(title:string, abstract:string, keywords:string, ID:int, name) Check whether this schema satisfies 1CNF, 2CNF, and 3CNF, making any adjustments as (b) (5 points) It may appear tempting to create Article with the following schema (where name is needed. Show all your work. The underline indicates the primary key 3. Consider a research article submission system, where researchers submit articles to journals in order to have them published. An article can be written by more than one author. When an article is submitted, they receive a unique submission number and an editor is assigned to manage the review of the article for scientific correctness and to evaluate its impact. The review itself is conducted by exactly two reviewers, who are assigned by the editor. The final decision of whether to accepted the article is made by the editor. If accepted, the article is published in an issue of the corresponding journal. Reviewers and editors can also submit articles. Editors inform authors about the result of decision. Reviewers can work for more than one journal, but editors can only work for one journal Journals have many editors and reviewers The following is additional information Authors have unique ID, as well as a name, association and, their specialization area . Journals each have unique ID, as well as a name, address, and contact info An issues is identified by its number in the current year of published articles An article has a title, abstract and exactly four key words. Articles may have the same title, but will have a unique title in combination with its list of key words (a) (20 points) Create an ER Diagram using BOTH Chen and Crow's Foot notation (to be sure that you get practice!). Be sure to clearly and appropriately indicate any keys, weak entities. relationship constraints, etc. authors name) Article(title:string, abstract:string, keywords:string, ID:int, name) Check whether this schema satisfies 1CNF, 2CNF, and 3CNF, making any adjustments as (b) (5 points) It may appear tempting to create Article with the following schema (where name is needed. Show all your work. The underline indicates the primary key