1. Create a database/schema with the name Testing123.

2. Inside this database, create the following tables:

Please code the answer to the above problem in SQL. Thank you.

- BOOK (isbn, title, num-pages, publisher, year, genre, price, aut-id). The first attribute is the primary key; the last one is a foreign key to AUTHOR. 1 - CUSTOMER(customer-id, name, address, city, state, zip, age). The first attribute is the primary key. - SALES (isbn, custid, num-copies, day, month, year, total). The first attribute is a foreign key to BOOK and the second a foreign key to CUSTOMER. The key of this table is the two foreign keys together. - AUTHOR (author-id, name, dob, nationality, address, city, state, zip). The first attribute is the primary key