$1.$ Design the ERD for Library Management System. Make an engaging ERD that links entities, attributes, and relationships.

Entities and Attributes:

Identify entities: Book, Librarian, User.

Attributes for Librarian: FirstName, LibrarianID $($PK$),$ LastName

Attributes for User: MaxDaysAllowed, UserType $($Student$/$Faculty$),$ UserID $($PK$),$ MaxBooksAllowed.

Attributes for Book: Title, BookID $($PK$),$ StorageLocation, ISBN, UnitNumber, Author, RowNumber, Illustrator.

Relationships:

Define relationships: Book has CheckOutRecord $(1$:M$),$ Librarian facilitates CheckOut $(1$:M$),$ and User checks out Book $($M:M$).$

Add foreign keys: UserID $($FK$)$ in CheckOut, BookID $($FK$)$ in CheckOutRecord, and LibrarianID $($FK$)$ in CheckOut.

Additional Entities:

Create entities for CheckOutRecord and CheckOut.

Attributes for CheckOut: FineAmount, CheckOutID $($PK$),$ ActualReturnDate, CheckOutDate, ReturnDate.

Attributes for CheckOutRecord: Duration, CheckOutRecordID $($PK$).$

$2.$ Map ERD into the Relational Model

Librarian Table:

Librarian $($FirstName$,$ LibrarianID

$($PK$),$ LastName$)$

User Table:

User $($MaxDaysAllowed$,$ UserType, UserID $($PK$),$ MaxBooksAllowed$)$

Book Table:

Book$($Title$,$ BookID $($PK$),$ StorageLocation, ISBN,

UnitNumber, Author, RowNumber, Illustrator$)$

CheckOut Table:

CheckOut $($LibrarianID FK$,$

CheckOutID PK$,$ CheckOutDate,

UserID FK$,$ ReturnDate,

FineAmount $,$ActualReturnDate$)$

CheckOutRecord Table:

CheckOutRecord$($CheckOut$|$D FK$,$

BookID FK$,$ CheckOutRecordID

PK$,$Duration$)$