Home Work $1$

A$.$ Given the following Library Schema

write a SQL statement to

$1-$ Create tables of library database

$2-$ Find a list of all publisher's names

$3-$ Find Book$\_$id$,$ Branch$\_$id for all books where number

of copies less than or equal $3$

$4-$ Find Book$\_$id$,$ Book$\_$name, Branch$\_$id for all books

published by "Longman"

$5-$ Find Book$\_$id$,$ Branch$\_$id for all books where the due

date $($date to return loaned book$)$ is $10-6-2022$ or

before.

$6-$ Find Branch$\_$name and address where the book title

is "Fundamental of Databases"

$7-$ Find book$\_$id$,$ title for all books borrowed by "Olaa

Husin"