Write SQL script to perform the following actions. Your submission must include a .sql file with the following queries.

Write create statements to create the following two tables for Good Reading bookstore and insert 2 records in each table. Make sure you enforce the following and Choose the correct data types for the columns

1) Date columns need to be of type Date

2) Author numbers are 5-digit alphanumeric string, two letters and three numbers.

3) You want to minimize disk space requirements. Identify the columns that should be fixed length string types, and which should be variable length string types.

4)Tables must be created in the schema Good_Reading

Table 1: Write SQL queries to create table and insert 2 records

PUBLISHER

PublisherName

City

Country

Telephone

YearFounded

Table 2: Write SQL queries to create table and insert 2 records

AUTHOR

AuthorNumber

AuthorName

YearBorn