Using SQL$,$ create a database that tracks the inventory of books. You must have the following tables: BOOKS, AUTHORS, PUBLISHERS, GENRE, and BOOK$\_$TYPE.

The BOOKS table must have the following attributes: ISBN, TITLE, AUTHOR$\_$ID$,$ PUBLISHER$\_$ID$,$ BOOK$\_$TYPE, GENRE, and PUBLISH$\_$DATE.

The AUTHORS table must have the following attributes: AUTHOR$\_$ID$,$ LAST$\_$NAME, and FIRST$\_$NAME.

The PUBLISHERS table must have the following attributes: PUBLISHER$\_$ID$,$ COMPANY$\_$NAME, and STATE.

The GENRE table is a lookup table with one field: GENRE$\_$TYPE.

The BOOK$\_$TYPE table is a lookup table with one field BOOK$\_$TYPE.

Make sure you have the appropriate Primary and Foreign Keys where needed. You must establish relationships between BOOKS and the other tables.

Populate the two lookup tables:

GENRE will have: Romance, Thriller, Western, Spy$,$ History

BOOK$\_$TYPE will have: Hardback, Paperback, Electronic

You can only use SQL Statements. Test your work and submit the SQL file.