DATABASE COURSE

I need the ER diagram to be drawn clearly, the stocks have to be clear...

By the following:- 1. BOOKLIST: a. Book ID b. Book Title d. Book Author e. Book Status 2. MEMBER REGISTRATION: a. Member ID b. First Name c. Last Name 3. BOWRING LIST: a. Book Name b. Borrow Data c. Return Date d. Status (Borrowed/Returned) 4. RETURNING THE BOOKS LIST: a. Book Name b. Book ID c. Return Date e. Fine (if any, in $)

I want to apply the following requirements to (A LIBRARY database system BORROWED BOOKS module). not the university example ***** - Select a software application and select one module of that application (For example, University System Courses registration Module). - Create the scenarios of using that module and determine the semantics of the information needed to be stored - Create the ER diagram for the module (refine the relations if needed) including any integrity constraints - Write the SQL queries that create the designed module