Question $21(50$ points$)$

You have been asked to design a database for a University Library System. The system must track the following information:

Books: Each book has a unique Book ID$,$ a title, an author, a publisher, and a publication year.

Students: Each student has a unique Student ID$,$ a name, an email address, and a major.

Borrowing Records: When a student borrows a book, the system records the date borrowed and the due date for return. A student can borrow multiple books, and each book can be borrowed by multiple students, but only one at a time.

Librarians: The system tracks the librarians who manage book checkouts. Each librarian has a unique Librarian ID$,$ a name, and a work shift $($morning$/$afternoon$/$evening$).$

Task:

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