Question$1$:

$-$Create a detailed ER diagram that includes the five entities with their attributes, relationships,

cardinalities, and key constraints.

Indicate any identifying relationships and existence dependencies.

Draw ER as a diagram and not a code with PK and FK

$1-$ Book:

PK: book id $($integer$)$

Title $($String$)$

FK: Author id $($integer$)$

FK: Category id$($integer$)$

publication year $($integer$)$

copies available $($integer$)$

$2-$ Member:

PK: member id $($integer$)$

Nema $($String$)$

Email $($String$)$

Phone $($String$)$

$3-$ Author:

PK: Author id $($integer$)$

Author na $($String$)$

Nationality $($String$)$

Birthdate $($Date$)$

$4-$ Borrow:

$|$PK: borrow id $($integer$)$

FK: book id $($integer$)$

FK: member id $($integer$)$

Borrow date $($Date$)$

Returned date $($Date$)$

Returned $($String$)$

$5-$ Category:

PK: category id $($integer$)$

category na $($String$)$

description $($String$)$