Using the relations in the image below, create an ER diagram that shows the entities, attributes, and relations, of our library system. Please use arrows for your connecting lines that have the standard crows foot notation used in ER diagrams.

In the library, there is a reporting relationship between the head librarian and other librarians that report to the head librarian. This is known as a Unary relationship. You must be able to both describe and model this relationship within your relation and within your entity relationship diagram.

Your assignment must include the following:

- an entity relationship (ER) diagram that defines the following relations and the relationships between them:

Book

Borrower

BookLended

Librarian

- the following defined entities in the diagram and make sure that the entities define the attributes appropriate for each entity:

Book

Borrower

BookLended

Librarian

- each relationship is labeled with the cardinality of the relationship

- the unary librarian relationship is defined?

Book Bomower Bookended Librarian Title Author Text Borrower Checkout Date Date Return_date Dte Text Name Address Postal code Phone numbe:r Text Text Text Number text Text Phone number Number Publication date Date Cost Nunber er te Date