Question $2-24$ points

Consider a database that stores information about Books $($identified by bookid$)$ and authors $($identified by authorid$).$ In addition to id$,$ every book has a name, a genre and a publication date. An author also has a name, a city and a state. Authors write Books.

The same note on the ER diagram from question $1$ applies here.

$(8$ points$)$ Draw the ER diagram that describes this database. Do not add any additional constraints.

$(8$ points$)$ Write the database schema for this ER diagram.

$(8$ points$)$ Write the CREATE TABLE statements for all tables identified for this database.

The create statements must work when ran against the Oracle database.

The CREATE statements must be written in an order such that if executed in that order will not cause any error. Please use SQL plus.