1. Design a database containing information about books in your home library. a. Data describing different objects should be in separate tables b. Each individual data (the area at the intersection of the row with the column) is irreducible. c. There is no redundancy d. The database should store information on at least: books, categories, authors, publishers. e. A book may have multiple authors. 2. Prepare appropriate sql scripts creating tables, primary keys, foreign keys 3. Fill in the table with sample data. (relevant sql code) 4. Prepare quiries: a. Assuming that the database contains books authored by Smith, prepare a sql query selecting all the books authored or co-authored by Smith. b. Assuming an example publisher ABC exists, prepare a query selecting the titles of all books published by that publisher. Please include sql scripts as a solution