II- ER diagram Desigin a databee for a "Tibrarye Baned on the following deccifeiou, draw ille correupotiling Ets diagram by A hibrary database contains information about books, authors of books, the subject of books and other informutipa. Drawy and ER dagram that descrities the lbrary database and make sure to write any assumptions you make and any comstrains you thins stould hold. Make sure that your assumptions are bogical, Fach book is identified by a publiating nambet and has a titie. Every wehor has a ruane, an 55N and 3 corotact phene number and each atuthor has at least one book that he wrote. Ali books are indeced by subjects where each sutefect hassubject tite and a subject number that identifies the subject. Every ibrary carries a certain number of books and each hit aty has a name and a focation (city)