ER-Diagram Q1. For each of the descriptions below, perform the following tasks (i) and (ii): [15] i) Identify Entity types, attributes, and relationship types ii) Identify the degree and cardinalities of the relationship. iii) Express the relationships in each description graphically with an E-R diagram for all the instructions put together. a. A book is identified by its ISBN, and it has a title, a price, and a date of publication. It is published by a publisher, each of which has its own ID number and a name. Each book has exactly one publisher, but one publisher typically publishes multiple books over time. b. A Book can come in different categories. Journal, Fiction, and Autobiography. Journal only has the publisher and Authors are for each article in the journal. Fiction can have one or more authors while Autobiography has only one author. c. Each author is identified by an author number and has a name and date of birth. Each author has either one or multiple books; in addition, occasionally data are needed also regarding prospective authors who have not yet published any books. d. In the context specified above in (a) and (b), better information is needed regarding the relationship between a book and its authors. Specifically, it is important to record the percentage of the royalties that belong to a specific author, whether or not a specific author is a lead author of the book, and each author's position in the sequence of the book's authors. e. A book (see (a) above) can be part of a series, which is also identified as a book and has its own ISBN number. One book can belong to several sets and a set consists of at least one but potentially many books. Q2. Explain given Diagram by specifying type of Entity, degree and cardinality of the relationships. [10] STAFF Staff ID Job Title Staff Gender Staff Name (First, MI,Last) Staff Address {Credentials} APPOINTMENT Appointment ID Date Scheduled Time Scheduled Date Made Time Made {Reason} PATIENT Patient ID Patient Gender Patient Date of Birth Patient Name(First, MI,Last) Patient Current Address {Allergy)