In this assignment, you need to create a simple database. Before starting this homework, make sure to watch the introduction to MySQL video.

Here, we want to create a simple database with two tables for the following entities:

$1-$ Authors

$2-$ Books

We know that each author may publish one or more books. the attributes of the authors are as follows.

$1)$ AID represents the Author's ID and its an integer number $($INT data type$).$ This column is the primary key of the table.

$2)$ AFName represents the Author's First Name and its data type is a string $($varchar$(32)$ data type$).$

$3)$ ALName represents the Author's Last Name and its data type is a string $($varchar$(32)$ data type$).$

$4)$ AStAddress represents the Author's street address and its data type is a string $($varchar$(32)$ data type$).$

$5)$ ACity that represents the Author's City and its data type is a string $($varchar$(32)$ data type$).$

$6)$ AState that represents the Author's state and its data type is a string $($varchar$(32)$ data type$).$

$7)$ AZipcode that represents the Author's zip code and its data type is an integer.

$8)$ ADOB represents the Author's date of birth and its data type is the date $($date data type$).$

the attributes of the Book are as follows.

$1)$ BID $($Book ID$,$ integer data type$).$ This column is the primary key of the table.

$2)$ BName $($Book Name, varchar$(32)$ data type$)$

$3)$ BISBN $($Book ISBN, varchar$(13)$ data type$)$

$4)$ BPDate $($Book published date, date data type$)$

$5)$ AID $($Author$\text{'}$s ID$)$ and its foreign key.