Create an ERD that captures the entities, their attributes, and the relationships between them.

Ensure your diagram clearly shows:

The entities involved $($Books$,$ Students, Borrowing Records, Librarians$).$

The relationships between the entities $($e$.$g$.,$ who borrows books, which librarian checks out books$).$

The cardinality of relationships $($e$.$g$.,$ one$-$to$-$many, many$-$to$-$many$).$

The primary keys for each entity.

Any relevant attributes for each entity $($e$.$g$.,$ Book ID$,$ Student Name, Borrow Date$).$

After designing your ERD, take the database structure you designed and normalize it to Third Normal Form $(3$NF$).$