Use MySQL Workbench to create a simple ER model and use the Forward Engineering functionality of Workbench to create a simple DB (specs follow). This focuses on how MySQL Workbench is used to create a model and then a DB from it, rather than on ER modeling.

The sample model you are to create is on books, authors, and publishers - a model that could be part of a larger ER model for a library. A book has an ISBN number and can have one or more authors, while an author can have written or co-authored more than one book. You need to make additional assumptions when creating entities and relationships - they must be reasonable and clearly stated. Entities representing books, authors, and publishers, respectively, should each have at least 4 attributes each, but no more than seven. Furthermore, assign at least 3 different names/values for each attribute. Identifiers in your model must be such that names (identifiers chosen) for primary keys must end with an underscore followed by the digits '444'.

Once your model is complete and ready, use MySQL Workbench to create a DB using Forward Engineer functionality. Once the DB is created, enter data into tables while ensuring that there are at least two books that have multiple authors; one that has just one author; and at least one author who co-authored at least two books. Furthermore, for each of the entities representing one of book, author, or publisher, the primary key value must end with an underscore followed by the digits '444'. That is, when you are inserting tuples into a table/relation representing one of book, publisher, or author tables, the primary key value must end with an underscore followed by the digits '444'.

Answer the following questions and submit the following as well: 1. Assumptions that you made when creating your entities and relationships (your assumptions must not contradict the specs above (i.e., that a book has an ISBN number and can have one or more authors, while an author can have written or co-authored more than one book)). 2. Screenshot of your final model that shows the whole Workbench window. 3. Screenshot of just your model diagram (as opposed to the whole Workbench Window). 4. Screen shots showing content of your tables. 5. A sequence of screenshots such that each one shows a model after you added one relation. Thus, if there are two relations, there should be two screenshots. 6. The auto-generated script from using the Forward Engineering function