. For each of the descriptions below, perform the following tasks: (13+13+14+9=49p)

1. Identify the degree and cardinalities of the relationship.
2. Explain why you use either mandatory or optional relationship constrains
3. Identify relationships attributes
4. Draw E-R diagram in Lucidchart and provide a shared Read-Only link to it.

1. A book is identified by its ISBN number, and it has a title, a price, and a date of publication. It is published by a publisher, which has its own ID number and a name. Each book has exactly one publisher, but one publisher typically publishes multiple books over time. (13p)