ERD 4

4) Library Management System ER Diagram:
plaintext
Copy code
                                    +-------------+
                                    |    Member   |
                                    +-------------+
                                    | member_id (PK)|
                                    | name        |
                                    | email       |
                                    | address     |
                                    +-------------+
                                            |
                                            |
                                  +---------+---------+
                                  |                   |
                          +-------+-------+   +-------+-------+
                          |     Borrows   |   |    Book       |
                          |               |   +---------------+
                          +---------------+   | book_id (PK)  |
                          | borrow_id (PK)|   | title         |
                          | member_id (FK)|   | author        |
                          | book_id (FK)  |   | available     |
                          | borrow_date   |   +---------------+
                          | return_date   |
                          +---------------+