Draw an E$-$R diagram for each of the descriptions below. Identify the degree of the relationship. $1)$Consider designing a database for a book store, where each book is identified by its ISBN, and it has a title, a price, and publication date. Each book is published by a publisher. Each publisher has its own ID number, name, and a phone number. Each book has exactly one

publisher, but each publisher publishes one or more books over time.

$2)$ Ebony and Ivory, a piano manufacturer, wants to keep track of all the pianos it makes individually. Each piano has an identifying serial number and a manufacturing completion date. Ebony and Ivory employs piano technicians who are responsible for inspecting the instruments before they are shipped to the customers. Each piano technician is identified by

their employee number. Each piano is inspected by at least one technician. Each piano technician may inspect many pianos. Some tenchinicians may not be responsible for inspection jobs. For each separate inspection, the company needs to record its date and a quality

evaluation grade.

$3)$A book $($with the same attributes in question $1)$ can be related to several other books $($e$.$g$.,$Harry Poter book series$)$ or can be related to no books at all. A book in a series is related to atleast one but potentially many other books.