Write the SQL DDL statement to create the BOOK table. Specify constraints such as PK, FK as appropriate.

Write the SQL DDL statement to create the BOOK_COPIES table. Specify constraints such as PK, FK as appropriate.

Write an SQL statement to delete all books where No_of_copies show as 0 (zero).

Write an SQL statement to retrieve all books whose title starts with letter 'A'. Include all attributes of book in the output.

Write an SQL statement to retrieve the titles of all books by author 'Navathe'.

Write an SQL statement to retrieve the number of copies of 'Fundamentals of Database Systems'.

Write an SQL statement to retrieve all book titles borrowed by 'Anna Kim'.

Write an SQL statement to retrieve title and author of all books sorted by author in ascending order.

Write an SQL statement to insert a new book into the library database. Use your favorite book data.

Write an SQL statement to update misspelled book authors. You should replace 'Elamarsi' with 'Elmarsi

BOOK ld Title Publisher name BOOK AUTHORS Book id Author name PUBLISHER Name Address Phone BOOK COPIES Book idBranch id No of copies BOOK LOANS Book id Branch id Card no Date out Due date LIBRARY BRANCH ld Branch name Address BORROWER NumberName AddressPhone