Using SQL, create the Author, Phone, Book, Publisher, and Member relations as well as any relevant relationship tables (if necessary).Populate them with the information provided below. (Note: this data is comma-separated and contains composite fields that must be broken apart. This will require you to modify the schemas appropriately, as well as to massage the data to handle Great place to do a little programming.) As is usually the case, the data contains extra fields from the ER diagram - I'm looking for you to implement the ER diagram. This data may require other massaging as well to fit into your schemas. Be sure to keep the scripts that create and populate the database - you will need them for future lab assignments.1. Author Data. This data is comma-separated with the following fields: Author ID, Name, Phone numbers2. Publisher Data. This data is comma-separated with the following fields: Publisher ID, Name3. Member Data. This data is comma-separated with the following fields:First line: Member ID, Name, DOBIndented lines: ISBN, Checkout Date, Checkin Date (if no Checkin Date, book is still checked out)4. Book Data This data is comma-separated with the following fields:First line: ISBN, Number of Copies, Shelf, Floor, Title, Publisher, Date PublishedIndented line: Authors