This is for the following class CS-432_Database Systems. Please answer the following question(s) and keep it simple. Thank you(will leave like). Please provide code in SQL (or SQL Plus) and also a drawn design.

Using UML Diagram to design a ER Model for a community library database system (limited to books).

In this system, there should be Member Info, Book Info, and Borrowing Transaction Info.

There should be at least CheckoutTime, dueDate, returnedDate, related to each item borrowed.

The database needs to support searches using title, keywords, authors, availability, and locations (eg. branch, and etc.).

============================================================================

Think how you would like to design the keywords info, author info, location info. Please keep in mind, a book may have many keywords, one keyword may be used by many books; a book may have many authors (in different order).

One book may have many copies, each of which has its availability and location. (Note: each copy needs unique code. when we say a book is borrowed, actually a copy is borrowed.).