1. A library maintains the records of usage of its electronic journals articles. The following E-R diagram shows this:

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

An article can be accessed by many members and a member can access many articles. Perform the following tasks for the given E-R diagram:

Design and implement normalised relations/tables. You must include primary key, validation checks and referential integrity constraints in your implementation.

Enter about 5 sets of meaningful data in each table.

Design and implement the following queries/forms/reports for the database.

Create two forms -one for entering information about online members and the other for entering information of Digital Articles.

Find the total number of articles in the "Databases" area (refer to Digital Article entity in ERD).

List the details of all the articles accessed by an online member whose User_id is "UOOl".

List the details of all online members in alphabetical order of their User_names.

List all the details of the articles whose cost IS more than RS 100.