The Book Database, whose relational scheme is given below, contains data on publishers, books, authors and the availability of books in university libraries.

YAYINEV$($YVNO$,$ YVADI, $$LKE$,$ ADRES$)$

YAZAR $($YAZNO$,$ YAZADI, $$LKE$,$ ADRES$)$

K$$TAP $($KNO$,$ KADI, YVNO, D$$L$)$

KTYAZ $($KNO$,$ YAZNO, SIRNO$)$

K$$TBASKI $($KNO$,$ BASKINO, BASKIYILI$)$

ANAHS$$Z $($AS$$ZC$$K$,$ A$$IKLAMA$)$

$$LG$$L$($KNO$,$ AS$$ZC$$K$)$

$$N$$VERS$$TE $($NO$,$ADI$,$ KENT$)$

K$$TAPLIK $($KTPNO$,$ KTPADI, $$NO$,$ KENT$)$

BULUNAN $($KTPNO$,$ KNO, BASKINO, ADET$)$

Brief explanations about the database are as follows.

$$ YAYINEV$$ relationship includes the numbers, names, countries and addresses of the publishing houses.

$$ YAZAR relationship includes the number, name, country and address data of the book authors.

$$ K$$TAP relationship includes the ISBN number, title, language and publishing house number of each book.

$$ KTYAZ relationship includes the authors of each book and the order of the authors of the book.

$$ K$$TBASKI relationship includes the number and year of publication of each edition of each book.

$$ ANAHS$$Z relationship includes the keywords used in the books and their explanations.

$$LG$$L$$ relationship shows which keywords each book is related to$.$

$$N$$VERS$$TE relationship includes the number, name and city of each university in Turkey.

$$ K$$TAPLIK relationship includes the number, name, university it is affiliated with and the city where the library is located.

$$ BULUNAN relationship shows how many copies of which book and which edition number are available in each library.

$1\mathrm{.}1$ Create an entity$-$relationship diagram of this database $($Show existence dependencies with weak entity sets in the diagram, use only binary relation sets and try to use as few relation sets as possible$).$

$1\mathrm{.}2$ Answer the following queries about the Book Database with the given relational schema using relational operators and SQL$.$

a$)$ "Find the number and name of books with a single author".

b$)$ "Find the number and name of books that were published more than once in the same year".

c$)$ "Find the number and name of authors who are the first $(1$st$)$ author of at least two books".

d$)$ "Find the number and name of books in all libraries".

e$)$ "Find the number and name of the books that are not available in any of the libraries of at least one university".