Subject: Relational Database

Program: MySQL Workbench

For this assignment you will be designing and creating a database for Coastal Publishing. The publisher has been using a primitive method to keep track of Authors, their Agents, Books, and their Editors, so they have hired you to help create a database to hold the appropriate information. They have already contracted the creation of the following ER diagram that will serve their needs AuthorLastName BookGenre (O) AuthorName ) BookTtle BookPubishDate Authori AUTHOR Writes BOOK BookNumPages Represents Edits EditorFirstName AgentiD AGENT AgentPhone EditoriD EDITOR (EditorName) Mentor Mentoree ( AgentName) EditorLastName Mentors AgentLastName Part 1: EER Diagram Begin by using MySQL's Workbench to create the EER Diagram that corresponds to the ER Diagram above. Be sure to name your schema CoastalPublishing. Save the image of your EER Diagram for submission, and give it the name CostalPublishingEER