1. A database system is to be designed to record data about articles and authors. The following E-R diagram shows this:

<img src='./qimages/13947-1.jpg'>

The assumptions of the E-R diagram are:

• An article can be written by many authors, also an author may have written many articles.

• a_id is the article id and aut_id is the author id.

Perform the following tasks for the E-R diagram given above:

Design and implement normalised relations/tables for the E-R diagram. You should include primary key, validation checks and referential integrity constraints in your implementation.

Enter 5 sets of meaningful data in every table that you have created in part

Design and implement the following forms/queries/reports for the database system created as above:

Create two forms -one for input of information of an article and the other for input of information about an author.

List all the articles written in 2015.

List the author id, author name and organisation of the author who has published maximum number of articles.

Display the title and names of all its authors, for the article whose id is "A001".

List the details of all the authors, in the alphabetical order of author name.