1. Following the data normalization process, develop a database design for the following scenario. We have some authors who wrote some books published by different publishers (a book might have two authors, for example book "A"). Besides, each author works with one publisher only. The following is an unnormalized table. a) Develop the First, Second, and Third Normal Forms (For each table, specify the key field(s) by highlighting in yellow, and remove the duplicates). b) Draw the Entity Relationship Diagram (ERD) for this database. Specify the type of relationships between tables (one-to-one, one-to-many, or many-to-many) 1. Following the data normalization process, develop a database design for the following scenario. We have some authors who wrote some books published by different publishers (a book might have two authors, for example book "A"). Besides, each author works with one publisher only. The following is an unnormalized table. a) Develop the First, Second, and Third Normal Forms (For each table, specify the key field(s) by highlighting in yellow, and remove the duplicates). b) Draw the Entity Relationship Diagram (ERD) for this database. Specify the type of relationships between tables (one-to-one, one-to-many, or many-to-many)